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 6650: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

6646: )
6647: IS
6648: l_count INTEGER := 0;
6649: l_transaction_table hr_transaction_ss.transaction_table;
6650: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6651: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6652: l_attribute_update_mode varchar2(100) default null;
6653: l_validate_mode boolean default false;
6654: l_con_name_combination_warning boolean;

Line 6651: l_object_version_number hr_api_transaction_steps.object_version_number%type;

6647: IS
6648: l_count INTEGER := 0;
6649: l_transaction_table hr_transaction_ss.transaction_table;
6650: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6651: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6652: l_attribute_update_mode varchar2(100) default null;
6653: l_validate_mode boolean default false;
6654: l_con_name_combination_warning boolean;
6655: l_per_name_combination_warning boolean;

Line 6726: from hr_api_transaction_steps hats,

6722: hr_utility.set_location('IF p_primary_contact_flag =Y :'||l_proc,10 );
6723: BEGIN
6724: select count(hats.transaction_step_id)
6725: into l_primary_contact_added
6726: from hr_api_transaction_steps hats,
6727: hr_api_transaction_values hatv
6728: where hats.item_type = p_item_type
6729: and hats.item_key = p_item_key
6730: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'

Line 6860: from hr_api_transaction_steps hats1

6856: else
6857: begin
6858: select nvl(max(hats1.transaction_step_id),0)
6859: into l_validate_g_per_step_id
6860: from hr_api_transaction_steps hats1
6861: where hats1.item_type = 'HRSSA'
6862: and hats1.item_key = p_item_key
6863: and hats1.api_name in( 'HR_PROCESS_PERSON_SS.PROCESS_API', 'BEN_PROCESS_COBRA_PERSON_SS.PROCESS_API');
6864:

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

14744: and date_from = c_date_from
14745: and primary_flag='Y';
14746:
14747: cursor csr_contact_api(c_transaction_step_id number) is
14748: select 'Y' from hr_api_transaction_steps where transaction_id =
14749: (select transaction_id from hr_api_transaction_steps where transaction_step_id =
14750: c_transaction_step_id) and api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
14751:
14752: begin

Line 14749: (select transaction_id from hr_api_transaction_steps where transaction_step_id =

14745: and primary_flag='Y';
14746:
14747: cursor csr_contact_api(c_transaction_step_id number) is
14748: select 'Y' from hr_api_transaction_steps where transaction_id =
14749: (select transaction_id from hr_api_transaction_steps where transaction_step_id =
14750: c_transaction_step_id) and api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
14751:
14752: begin
14753: hr_utility.set_location('Entering:'||l_proc, 5);

Line 14886: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

14882: and trunc(sysdate) between nvl(date_start, trunc(sysdate))
14883: and nvl(date_end, trunc(sysdate));
14884:
14885: l_transaction_table hr_transaction_ss.transaction_table;
14886: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
14887: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
14888: l_old_ovn number;
14889: l_old_contact_relationship_id number;
14890: l_count INTEGER := 0;

Line 14887: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

14883: and nvl(date_end, trunc(sysdate));
14884:
14885: l_transaction_table hr_transaction_ss.transaction_table;
14886: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
14887: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
14888: l_old_ovn number;
14889: l_old_contact_relationship_id number;
14890: l_count INTEGER := 0;
14891: l_transaction_id number default null;

Line 16783: from hr_api_transaction_steps hats1

16779: begin
16780: hr_utility.set_location('if p_person_id is not null then:'||l_proc, 15);
16781: select nvl(max(hats1.transaction_step_id),0)
16782: into l_validate_g_per_step_id
16783: from hr_api_transaction_steps hats1
16784: where hats1.item_type = 'HRSSA'
16785: and hats1.item_key = p_item_key
16786: and hats1.api_name in( 'HR_PROCESS_PERSON_SS.PROCESS_API', 'BEN_PROCESS_COBRA_PERSON_SS.PROCESS_API');
16787: