DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on HR_PROCESS_PERSON_SS

Line 1706: AND hats.api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'

1702: , hr_api_transaction_values hatv1
1703: , hr_api_transaction_values hatv2
1704: WHERE hat.transaction_id = l_source_pk1_value
1705: AND hats.transaction_id = hat.transaction_id
1706: AND hats.api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'
1707: AND hatv1.transaction_step_id = hats.transaction_step_id
1708: AND fads.attached_document_id = attached_documents_rec.attached_document_id
1709: AND hatv1.name like 'P_FND_DOC_ID%'
1710: AND hatv1.NUMBER_VALUE = fads.document_id

Line 1953: elsif(l_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API' OR

1949:
1950: l_entity_name := 'PER_ASSIGNMENTS_F';
1951: l_pk_value := trans_row.assignment_id;
1952:
1953: elsif(l_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API' OR
1954: l_api_name = 'HR_PROCESS_SIT_SS.PROCESS_API' OR
1955: l_api_name = 'HR_PROCESS_EIT_SS.PROCESS_API' OR
1956: l_api_name = 'HR_CAED_SS.PROCESS_API' OR
1957: l_api_name = 'HR_PROCESS_PHONE_NUMBERS_SS.PROCESS_API' OR

Line 1975: l_pk_value := hr_process_person_ss.g_person_id;

1971:
1972: if( l_pk_value is null) then
1973: hr_utility.set_location('l_pk_value is null' , 1);
1974:
1975: l_pk_value := hr_process_person_ss.g_person_id;
1976: end if;
1977:
1978: elsif(l_api_name = 'HR_TERMINATION_SS.PROCESS_API') then
1979:

Line 2009: IF l_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'

2005: ,p_dest_pk1_value => l_pk_value
2006: ,p_return_status => l_return_status);
2007:
2008: /* Added the following code as a part of ER#9879782 Starts*/
2009: IF l_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'
2010: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'
2011: THEN
2012: BEGIN
2013: SELECT COUNT(1)

Line 2246: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';

2242: select trs.transaction_step_id
2243: from hr_api_transaction_steps trs
2244: where trs.transaction_id = hr_transaction_ss.get_transaction_id
2245: (itemtype ,itemkey )
2246: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';
2247:
2248: cursor ethnic_dff is
2249: select DESCRIPTIVE_FLEXFIELD_NAME from FND_DESCR_FLEX_CONTEXTS
2250: where DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Person Info DDF'