DBA Data[Home] [Help]

APPS.HR_PROCESS_PERSON_SS dependencies on HR_API_TRANSACTION_STEPS

Line 1825: SELECT transaction_step_id FROM hr_api_transaction_steps

1821: and asg.payroll_id is not null
1822: order by asg.assignment_id;
1823:
1824: cursor get_transaction_step_id IS
1825: SELECT transaction_step_id FROM hr_api_transaction_steps
1826: WHERE item_type = p_item_type
1827: AND item_key = p_item_key
1828: AND api_name = 'HR_PROCESS_PERSON_SS.PROCESS_DUMMY_API';
1829:

Line 1884: hr_api_transaction_steps.object_version_number%type default null;

1880: l_count number default 0;
1881: l_transaction_table hr_transaction_ss.transaction_table;
1882: l_dummy_txn_table hr_transaction_ss.transaction_table;
1883: l_trs_object_version_number
1884: hr_api_transaction_steps.object_version_number%type default null;
1885: l_transaction_step_id
1886: hr_api_transaction_steps.transaction_step_id%type default null;
1887: ln_dummy_txn_step_id
1888: hr_api_transaction_steps.transaction_step_id%type default null;

Line 1886: hr_api_transaction_steps.transaction_step_id%type default null;

1882: l_dummy_txn_table hr_transaction_ss.transaction_table;
1883: l_trs_object_version_number
1884: hr_api_transaction_steps.object_version_number%type default null;
1885: l_transaction_step_id
1886: hr_api_transaction_steps.transaction_step_id%type default null;
1887: ln_dummy_txn_step_id
1888: hr_api_transaction_steps.transaction_step_id%type default null;
1889: l_transaction_id number default null;
1890: l_ovn number default null;

Line 1888: hr_api_transaction_steps.transaction_step_id%type default null;

1884: hr_api_transaction_steps.object_version_number%type default null;
1885: l_transaction_step_id
1886: hr_api_transaction_steps.transaction_step_id%type default null;
1887: ln_dummy_txn_step_id
1888: hr_api_transaction_steps.transaction_step_id%type default null;
1889: l_transaction_id number default null;
1890: l_ovn number default null;
1891:
1892: l_name_combination_warning boolean default false;

Line 5765: from HR_API_TRANSACTION_STEPS

5761: else
5762: hr_utility.set_location('Business group Id: '|| l_business_grp_Id,23);
5763:
5764: select CREATOR_PERSON_ID into login_person_id
5765: from HR_API_TRANSACTION_STEPS
5766: where TRANSACTION_STEP_ID = p_transaction_step_id;
5767:
5768: hr_utility.set_location('Creator Person Id: '|| login_person_id,24);
5769: l_orgid := hr_multi_tenancy_pkg.get_org_id_for_person(login_person_id, l_business_grp_Id);