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 137: hr_transaction_ss.delete_transaction_step

133: if (nvl(p_step_id,hr_api.g_number) = nvl(l_step_id_db,hr_api.g_number)) AND
134: (nvl(p_reason,hr_api.g_varchar2) = nvl(l_reason_db,hr_api.g_varchar2)) then
135:
136: if l_transaction_step_id is not null then
137: hr_transaction_ss.delete_transaction_step
138: (p_transaction_step_id => l_transaction_step_id
139: ,p_login_person_id => p_login_person_id);
140: delete_pay_step(
141: p_item_type => p_item_type,

Line 384: l_transaction_id := hr_transaction_ss.get_transaction_id

380: rollback to normal_flow;
381: end if;
382:
383: if l_transaction_step_id is null then
384: l_transaction_id := hr_transaction_ss.get_transaction_id
385: (p_item_type => p_item_type
386: ,p_item_key => p_item_key);
387:
388: if l_transaction_id is null then

Line 389: hr_transaction_ss.start_transaction

385: (p_item_type => p_item_type
386: ,p_item_key => p_item_key);
387:
388: if l_transaction_id is null then
389: hr_transaction_ss.start_transaction
390: (itemtype => p_item_type
391: ,itemkey => p_item_key
392: ,actid => -1
393: ,funmode => 'RUN'

Line 400: l_transaction_id:=hr_transaction_ss.get_transaction_id

396: ,p_plan_id => p_plan_id
397: ,p_rptg_grp_id => p_rptg_grp_id
398: ,p_effective_date_option => p_effective_date_option);
399:
400: l_transaction_id:=hr_transaction_ss.get_transaction_id
401: (p_item_type => p_item_type
402: ,p_item_key => p_item_key);
403: end if;
404:

Line 523: hr_transaction_ss.save_transaction_step

519: l_trans_tbl(l_count).param_value := -1;
520: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
521:
522:
523: hr_transaction_ss.save_transaction_step
524: (p_item_type => p_item_type
525: ,p_item_key => p_item_key
526: ,p_actid => -1
527: ,p_login_person_id => p_login_person_id

Line 821: hr_transaction_ss.get_wf_effective_date

817: if (p_effective_date is not null) then
818: l_effective_date:= to_date(p_effective_date,g_date_format);
819: else
820: l_effective_date:= to_date(
821: hr_transaction_ss.get_wf_effective_date
822: (p_transaction_step_id => p_transaction_step_id),g_date_format);
823: end if;
824:
825: get_transaction_data

Line 1084: hr_transaction_ss.delete_transaction_step

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