Disabling parameter in Concurrent Program based on the above parameter.

Disabling parameter based on the above parameter:
Para1
organization: PER_ORG_UNITS_RESTRICTED_BY_DATE_PARAM
P_ORGANIZATION_ID

Para2:
dummay org: PER_CHAR
 P_DUMMY_ORGANIZATION
SQL Statement
select decode(:$FLEX$.PER_ORG_UNITS_RESTRICTED_BY_DATE_PARAM:NULL,'','X','') from sys.dual

para3:
Empolyee: PER_EMPLOYEES_SKIP
P_PERSON_ID

Check for details "Absence Report" seeded report for the same in HRMS.

Query Soft Coding KeyFlex Field

SELECT PERSON_ID, SEGMENT1 EMPLOYER, SEGMENT2 CIVIL_REG, SEGMENT3 SOCIAL_SEC
FROM HR_SOFT_CODING_KEYFLEX SCK,
PER_ALL_ASSIGNMENTS_F PAAF
WHERE PAAF.SOFT_CODING_KEYFLEX_ID = SCK.SOFT_CODING_KEYFLEX_ID
AND SYSDATE BETWEEN PAAF.EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND PERSON_ID = 25584

Query Job Position

SELECT DISTINCT EMPLOYEE_NUMBER, FULL_NAME,POSITION_ID, JOB_ID,
(SELECT PJ.NAME
FROM PER_JOBS PJ
WHERE PJ.JOB_ID = PAAF.JOB_ID) JOB_NAME,
(SELECT NVL(PKFV.SEGMENT2,'')
 FROM hr_all_positions_f HAPF,
 PER_POSITION_DEFINITIONS_KFV PKFV
 WHERE HAPF.POSITION_ID = PAAF.POSITION_ID
 AND :P_AS_ON_DATE BETWEEN  HAPF.EFFECTIVE_START_DATE AND HAPF.EFFECTIVE_END_DATE
 AND HAPF.POSITION_DEFINITION_ID = PKFV.POSITION_DEFINITION_ID
 AND ID_FLEX_NUM = 50311
 )POSITION_NAME
FROM PER_ALL_PEOPLE_F PAPF,
PER_ALL_ASSIGNMENTS_F PAAF
--PER_JOBS P
where :P_AS_ON_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND :P_AS_ON_DATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID = PAAF.PERSON_ID
AND PAYROLL_ID = 82--PALACE
AND PAAF.PERSON_ID = NVL(:P_PERSON_ID, PAAF.PERSON_ID)
AND PAAF.POSITION_ID = NVL(:P_POSITION_ID, PAAF.POSITION_ID)
AND PAAF.JOB_ID = NVL(:P_JOB_ID, PAAF.JOB_ID)
ORDER BY 1

Calling Procedure in personalization or Running Conc Program from Personalization

Calling procedure to execute from personalization
Actions:
10 Builtin     

Builtin Type: Exceute a Procedure
Argument :

='declare
begin
XX_I_JOIN_DATE_I_REQUEST('''||${ps.per_security_profile_id.value}||''')
end'



Notes:

XX_I_JOIN_DATE_I_REQUEST is the procedure having parameter
CREATE OR REPLACE procedure APPS.XX_I_JOIN_DATE_I_REQUEST(P_PER_SEC_PRO_ID number)
IS
vRequest_id varchar2(20);
BEGIN
vRequest_id:= APPS.FND_REQUEST.SUBMIT_REQUEST(
                'PER',
                'DUTY_RESUME',--This is the short_name of Concurrent Program
                '',
                '',
                NULL,
                P_PER_SEC_PRO_ID);
                COMMIT;
END;

Notes2:
${ps.per_security_profile_id.value} where ps = profile security

More in Detailed:
 Steps:
1. Personalize the form
2. Create an action of type “BuiltIn”
3. BuiltIn Type for Action should be “Execute a Procedure”
4. Argument should be as below
=’declare
v_field_value VARCHAR2(200) ;
begin
plsql_package.procedurenameHere ;
end’
or alternately
=’declare
v_field_value VARCHAR2(200) ;
begin
XX_PRC(”’||${item.PO_CONTROL_RULES.OBJECT_CODE_DISPLAYED_VALUE.value}||”’);
end’
Note the syntax, after =, entire declare begin end is within single quote.
Also, there is no semi colon after “end”
You can pass field values as
”’||${item.BLOCKNAME.FIELDNAME.value}||”’
e.g.
A simple way to understand is the begin end block should be enclosed in single quotes and the fields should be enclosed in double quotes.
=‘begin
test_procedure( “’||:GLOBAL.field||’”,”‘||${item.block.field.value}||’”);
end’

http://www.oracleerpappsguide.com/2011/10/calling-stored-procedure-through-forms.html

1. How to View 'Diagnostics>Personalization' in Apps R12 forms or Enabling Personalization in Forms 2. How to View 'About this Page' in R12 OAF Pages or Enabling Personalization in OAF pages. 3. How to Clear Cache in Apps R12??

1. How to View 'Diagnostics>Personalization' in Apps R12 forms or Enabling Personalization in Forms
2. How to View  'About this Page' in R12 OAF Pages  or Enabling Personalization in OAF pages.
3. How to Clear Cache in Apps R12??


DO IT USER LEVEL:

1.System administrator Resp>profile
Query for : Utilities:%Diagnostics 
Change Value : Yes

2.1
System administrator Resp>profile
Query for : Personalize Self-Service Defn
Change Value : Yes

2.2
System administrator Resp>profile
Query for :FND: Personalization Region Link Enabled
Change Value : Yes

3.
Clearing Cache in Apps R12:
RESP>FUNCTIONAL ADMINISTRATOR
CORE SERVICES>CACHING FRAMEWORK>
GLOBAL CONFIGURATION>
CLICK , CLEAR ALL STATISTICS (YES)
CLICK , CLEAR ALL CACHE (YES)

Query for Payroll Results with given Element Names or Input Values or Employee Number....

select papf.employee_number,papf.full_name,ppa.effective_date,pp.payroll_name,
pet.element_name,piv.name input_value,prrv.result_value,ppa.payroll_action_id
from apps.pay_payroll_actions ppa,
 pay_assignment_actions paa,
pay_payrolls_f pp,
pay_run_results prr,
pay_run_result_values prrv,
pay_input_values_f piv,
pay_element_types_f pet,
apps.per_all_assignments_f paaf,
apps.per_all_people_f papf
--where ppa.payroll_action_id = :payroll_action_id -- give your payroll_action_id
where ppa.payroll_id = :payroll_id
--and paa.assignment_action_id = :assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.payroll_id = pp.payroll_id
and paa.assignment_action_id = prr.assignment_action_id
and prr.run_result_id= prrv.run_result_id
and prrv.input_value_id = piv.input_value_id
and piv.element_type_id = pet.element_type_id
and paaf.assignment_id = paa.assignment_id
and paaf.person_id = papf.person_id
and trunc(sysdate) between pp.effective_start_date and pp.effective_end_date
and trunc(sysdate) between pet.effective_start_date and pet.effective_end_date
and trunc(sysdate) between piv.effective_start_date and piv.effective_end_date
and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
and papf.employee_number = '3930'
and ppa.effective_date = '27-JUN-2013'
and ELEMENT_NAME = 'Basic Salary'--give ur element Name
order by employee_number

Query to retrive Concurrent Programs created or updated by User 2605.

"SELECT FCP.CONCURRENT_PROGRAM_NAME SHORT_NAME,
FCP.USER_CONCURRENT_PROGRAM_NAME ENGLISH,
FCPTL.USER_CONCURRENT_PROGRAM_NAME ARABIC,
decode(fe.EXECUTION_METHOD_CODE,'P','Oracle_Reports','I','PLSQL','')EXECUTION_METHOD,

FCP.CREATED_BY, FCP.LAST_UPDATED_BY, FCP.CREATION_DATE, FCP.LAST_UPDATE_DATE
,FCP.ENABLED_FLAG
FROM FND_CONCURRENT_PROGRAMS_VL FCP,
FND_CONCURRENT_PROGRAMS_TL FCPTL,
fnd_executables FE
WHERE 
(FCP.CREATED_BY = 2605 OR FCP.LAST_UPDATED_BY = 2605)  
AND FCP.ENABLED_FLAG = 'Y'
AND FCP.CONCURRENT_PROGRAM_ID = FCPTL.CONCURRENT_PROGRAM_ID
AND FCPTL.LANGUAGE = 'AR'
AND FE.EXECUTABLE_NAME = FCP.CONCURRENT_PROGRAM_NAME
ORDER BY 5,7"