DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_STEP_SS dependencies on HR_TRANSACTION_SS

Line 44: l_trans_tbl hr_transaction_ss.transaction_table;

40:
41: l_transaction_id number;
42: l_transaction_step_id number default null;
43: l_trns_object_version_number number default null;
44: l_trans_tbl hr_transaction_ss.transaction_table;
45: l_count number;
46: l_result varchar2(100) default null;
47:
48: l_assignment_id number;

Line 150: hr_transaction_ss.delete_transaction_step

146: if (nvl(p_step_id,hr_api.g_number) = nvl(l_step_id_db,hr_api.g_number)) AND
147: (nvl(p_reason,hr_api.g_varchar2) = nvl(l_reason_db,hr_api.g_varchar2)) then
148:
149: if l_transaction_step_id is not null then
150: hr_transaction_ss.delete_transaction_step
151: (p_transaction_step_id => l_transaction_step_id
152: ,p_login_person_id => p_login_person_id);
153: delete_pay_step(
154: p_item_type => p_item_type,

Line 389: l_transaction_id := hr_transaction_ss.get_transaction_id

385: rollback to normal_flow;
386: end if;
387:
388: if l_transaction_step_id is null then
389: l_transaction_id := hr_transaction_ss.get_transaction_id
390: (p_item_type => p_item_type
391: ,p_item_key => p_item_key);
392:
393: if l_transaction_id is null then

Line 394: hr_transaction_ss.start_transaction

390: (p_item_type => p_item_type
391: ,p_item_key => p_item_key);
392:
393: if l_transaction_id is null then
394: hr_transaction_ss.start_transaction
395: (itemtype => p_item_type
396: ,itemkey => p_item_key
397: ,actid => -1
398: ,funmode => 'RUN'

Line 405: l_transaction_id:=hr_transaction_ss.get_transaction_id

401: ,p_plan_id => p_plan_id
402: ,p_rptg_grp_id => p_rptg_grp_id
403: ,p_effective_date_option => p_effective_date_option);
404:
405: l_transaction_id:=hr_transaction_ss.get_transaction_id
406: (p_item_type => p_item_type
407: ,p_item_key => p_item_key);
408: end if;
409:

Line 528: hr_transaction_ss.save_transaction_step

524: l_trans_tbl(l_count).param_value := -1;
525: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
526:
527:
528: hr_transaction_ss.save_transaction_step
529: (p_item_type => p_item_type
530: ,p_item_key => p_item_key
531: ,p_actid => -1
532: ,p_login_person_id => p_login_person_id

Line 826: hr_transaction_ss.get_wf_effective_date

822: if (p_effective_date is not null) then
823: l_effective_date:= to_date(p_effective_date,g_date_format);
824: else
825: l_effective_date:= to_date(
826: hr_transaction_ss.get_wf_effective_date
827: (p_transaction_step_id => p_transaction_step_id),g_date_format);
828: end if;
829:
830: get_transaction_data

Line 1089: hr_transaction_ss.delete_transaction_step

1085: ,p_name => 'P_REVIEW_ACTID');
1086: -- for Pay Rate GSP Txn, Review Activity Id is -1
1087: if((lv_gsp_activity_id is not null) and (to_number(lv_gsp_activity_id) = -1))
1088: THEN
1089: hr_transaction_ss.delete_transaction_step
1090: (p_transaction_step_id => ln_gsp_step_id
1091: ,p_login_person_id => p_login_person_id);
1092: delete from per_pay_transactions where TRANSACTION_STEP_ID=ln_gsp_step_id;
1093: end if;