eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PROCESS_CONTACT_SS dependencies on HR_API_TRANSACTION_STEPS

Line 1654: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

1650: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)) ;
1651: -- and primary_contact_flag = 'Y';
1652: --
1653: l_transaction_table hr_transaction_ss.transaction_table;
1654: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1655: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
1656: l_cont_old_ovn number ;
1657: l_per_old_ovn number;
1658: l_old_contact_relationship_id number;

Line 1655: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

1651: -- and primary_contact_flag = 'Y';
1652: --
1653: l_transaction_table hr_transaction_ss.transaction_table;
1654: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1655: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
1656: l_cont_old_ovn number ;
1657: l_per_old_ovn number;
1658: l_old_contact_relationship_id number;
1659: l_employee_number per_all_people_f.employee_number%type ;

Line 6719: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

6715: )
6716: IS
6717: l_count INTEGER := 0;
6718: l_transaction_table hr_transaction_ss.transaction_table;
6719: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6720: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6721: l_attribute_update_mode varchar2(100) default null;
6722: l_validate_mode boolean default false;
6723: l_con_name_combination_warning boolean;

Line 6720: l_object_version_number hr_api_transaction_steps.object_version_number%type;

6716: IS
6717: l_count INTEGER := 0;
6718: l_transaction_table hr_transaction_ss.transaction_table;
6719: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6720: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6721: l_attribute_update_mode varchar2(100) default null;
6722: l_validate_mode boolean default false;
6723: l_con_name_combination_warning boolean;
6724: l_per_name_combination_warning boolean;

Line 6795: from hr_api_transaction_steps hats,

6791: hr_utility.set_location('IF p_primary_contact_flag =Y :'||l_proc,10 );
6792: BEGIN
6793: select count(hats.transaction_step_id)
6794: into l_primary_contact_added
6795: from hr_api_transaction_steps hats,
6796: hr_api_transaction_values hatv
6797: where hats.item_type = p_item_type
6798: and hats.item_key = p_item_key
6799: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'

Line 6929: from hr_api_transaction_steps hats1

6925: else
6926: begin
6927: select nvl(max(hats1.transaction_step_id),0)
6928: into l_validate_g_per_step_id
6929: from hr_api_transaction_steps hats1
6930: where hats1.item_type = 'HRSSA'
6931: and hats1.item_key = p_item_key
6932: and hats1.api_name in( 'HR_PROCESS_PERSON_SS.PROCESS_API', 'BEN_PROCESS_COBRA_PERSON_SS.PROCESS_API');
6933:

Line 14916: select 'Y' from hr_api_transaction_steps where transaction_id =

14912: and date_from = c_date_from
14913: and primary_flag='Y';
14914:
14915: cursor csr_contact_api(c_transaction_step_id number) is
14916: select 'Y' from hr_api_transaction_steps where transaction_id =
14917: (select transaction_id from hr_api_transaction_steps where transaction_step_id =
14918: c_transaction_step_id) and api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
14919:
14920: begin

Line 14917: (select transaction_id from hr_api_transaction_steps where transaction_step_id =

14913: and primary_flag='Y';
14914:
14915: cursor csr_contact_api(c_transaction_step_id number) is
14916: select 'Y' from hr_api_transaction_steps where transaction_id =
14917: (select transaction_id from hr_api_transaction_steps where transaction_step_id =
14918: c_transaction_step_id) and api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
14919:
14920: begin
14921: hr_utility.set_location('Entering:'||l_proc, 5);

Line 15054: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

15050: and trunc(sysdate) between nvl(date_start, trunc(sysdate))
15051: and nvl(date_end, trunc(sysdate));
15052:
15053: l_transaction_table hr_transaction_ss.transaction_table;
15054: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
15055: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
15056: l_old_ovn number;
15057: l_old_contact_relationship_id number;
15058: l_count INTEGER := 0;

Line 15055: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

15051: and nvl(date_end, trunc(sysdate));
15052:
15053: l_transaction_table hr_transaction_ss.transaction_table;
15054: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
15055: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
15056: l_old_ovn number;
15057: l_old_contact_relationship_id number;
15058: l_count INTEGER := 0;
15059: l_transaction_id number default null;

Line 16977: from hr_api_transaction_steps hats1

16973: begin
16974: hr_utility.set_location('if p_person_id is not null then:'||l_proc, 15);
16975: select nvl(max(hats1.transaction_step_id),0)
16976: into l_validate_g_per_step_id
16977: from hr_api_transaction_steps hats1
16978: where hats1.item_type = 'HRSSA'
16979: and hats1.item_key = p_item_key
16980: and hats1.api_name in( 'HR_PROCESS_PERSON_SS.PROCESS_API', 'BEN_PROCESS_COBRA_PERSON_SS.PROCESS_API');
16981: