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.BEN_CREATE_PTNL_LER_SS dependencies on HR_API_TRANSACTION_STEPS

Line 52: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type := to_number(p_transaction_step_id);

48: ) is
49:
50: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type := to_number(p_ptnl_ler_for_per_id);
51: l_object_version_number ben_ptnl_ler_for_per.object_version_number%type := to_number(p_object_version_number);
52: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type := to_number(p_transaction_step_id);
53: l_lf_evt_ocrd_date date;
54: l_ocrd_dt_cd hr_lookups.lookup_code%TYPE; -- UTF8 varchar2(30);
55:
56: cursor get_ler is

Line 180: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;

176:
177:
178: l_transaction_table hr_transaction_ss.transaction_table;
179: l_count INTEGER := 0;
180: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;
181: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
182: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;
183:
184: -- variable for the create person call

Line 181: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

177:
178: l_transaction_table hr_transaction_ss.transaction_table;
179: l_count INTEGER := 0;
180: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;
181: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
182: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;
183:
184: -- variable for the create person call
185: l_original_person_id per_all_people_f.person_id%type;

Line 182: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;

178: l_transaction_table hr_transaction_ss.transaction_table;
179: l_count INTEGER := 0;
180: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;
181: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
182: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;
183:
184: -- variable for the create person call
185: l_original_person_id per_all_people_f.person_id%type;
186: l_review_item_name varchar2(50);

Line 578: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;

574: ,p_flow_mode in varchar2
575: ,p_subflow_mode in varchar2
576: ,p_life_event_name out nocopy varchar2
577: ) is
578: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;
579: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
580: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;
581: l_proc varchar2(72) := g_package||'.GET_PTNL_LER_DATA_FROM_TT';
582:

Line 579: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

575: ,p_subflow_mode in varchar2
576: ,p_life_event_name out nocopy varchar2
577: ) is
578: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;
579: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
580: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;
581: l_proc varchar2(72) := g_package||'.GET_PTNL_LER_DATA_FROM_TT';
582:
583:

Line 580: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;

576: ,p_life_event_name out nocopy varchar2
577: ) is
578: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;
579: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
580: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;
581: l_proc varchar2(72) := g_package||'.GET_PTNL_LER_DATA_FROM_TT';
582:
583:
584: BEGIN

Line 1020: from hr_api_transaction_steps

1016: --
1017: cursor transaction_step is
1018: select transaction_step_id
1019: , object_version_number
1020: from hr_api_transaction_steps
1021: where item_type=p_item_type
1022: and item_key=p_item_key
1023: --and activity_id = p_activity_id --because when this is called from review page the activity id is different
1024: and api_name=p_api_name;