DBA Data[Home] [Help]

APPS.PAY_BEE_SS dependencies on HR_TRANSACTION_API

Line 77: hr_transaction_api.get_transaction_step_info

73:
74: -- First check step id already exists, which happens when user navigates
75: -- back from review or page after this page.
76: --
77: hr_transaction_api.get_transaction_step_info
78: (p_item_type => p_item_type
79: ,p_item_key => p_item_key
80: ,p_activity_id => p_actid
81: ,p_transaction_step_id => l_trans_step_ids

Line 93: hr_transaction_api.create_transaction_step

89: --
90: -- Create a transaction step
91: --
92: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
93: hr_transaction_api.create_transaction_step
94: (p_validate => false
95: ,p_creator_person_id => p_login_person_id
96: --nvl(p_login_person_id, p_parent_id)
97: ,p_transaction_id => l_transaction_id

Line 248: hr_transaction_api.get_transaction_step_info

244: (p_item_type => p_item_type
245: ,p_item_key => p_item_key);
246: -- -- -- bee_trace('Exception:Others 13'||l_proc);
247:
248: hr_transaction_api.get_transaction_step_info
249: (p_item_type => p_item_type
250: ,p_item_key => p_item_key
251: ,p_activity_id => p_actid
252: ,p_transaction_step_id => l_trans_step_ids

Line 272: hr_transaction_api.create_transaction_step

268: --
269: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
270: -- -- -- bee_trace('l_transaction_step_id is null');
271:
272: hr_transaction_api.create_transaction_step
273: (p_validate => false
274: ,p_creator_person_id => p_login_person_id
275: --nvl(p_login_person_id, p_parent_id)
276: ,p_transaction_id => l_transaction_id

Line 416: hr_transaction_api.get_transaction_step_info

412: SET varchar2_value ='Unprocessed'
413: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
414: and name = 'P_BATCH_STATUS_FLAG';
415:
416: hr_transaction_api.get_transaction_step_info
417: (p_item_type => p_item_type
418: ,p_item_key => p_item_key
419: ,p_activity_id => p_actid
420: ,p_transaction_step_id => l_trans_step_ids

Line 440: hr_transaction_api.create_transaction_step

436: --
437: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
438: ---- -- bee_trace('l_transaction_step_id is null');
439:
440: hr_transaction_api.create_transaction_step
441: (p_validate => false
442: ,p_creator_person_id => p_login_person_id
443: --nvl(p_login_person_id, p_parent_id)
444: ,p_transaction_id => l_transaction_id

Line 569: hr_transaction_api.get_transaction_step_info

565: (p_item_type => p_item_type
566: ,p_item_key => p_item_key);
567: -- -- -- bee_trace('Exception:Others 13'||l_proc);
568:
569: hr_transaction_api.get_transaction_step_info
570: (p_item_type => p_item_type
571: ,p_item_key => p_item_key
572: ,p_activity_id => p_actid
573: ,p_transaction_step_id => l_trans_step_ids

Line 593: hr_transaction_api.create_transaction_step

589: --
590: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
591: -- -- -- bee_trace('l_transaction_step_id is null');
592:
593: hr_transaction_api.create_transaction_step
594: (p_validate => false
595: ,p_creator_person_id => p_login_person_id
596: --nvl(p_login_person_id, p_parent_id)
597: ,p_transaction_id => l_transaction_id

Line 670: hr_transaction_api.get_transaction_step_info

666: (p_item_type => p_item_type
667: ,p_item_key => p_item_key);
668: -- -- -- bee_trace('Exception:Others 13'||l_proc);
669:
670: hr_transaction_api.get_transaction_step_info
671: (p_item_type => p_item_type
672: ,p_item_key => p_item_key
673: ,p_activity_id => p_actid
674: ,p_transaction_step_id => l_trans_step_ids

Line 694: hr_transaction_api.create_transaction_step

690: --
691: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
692: -- -- -- bee_trace('l_transaction_step_id is null');
693:
694: hr_transaction_api.create_transaction_step
695: (p_validate => false
696: ,p_creator_person_id => p_login_person_id
697: --nvl(p_login_person_id, p_parent_id)
698: ,p_transaction_id => l_transaction_id

Line 800: l_effective_date:=hr_transaction_api.get_date_value

796: from hr_api_transaction_values
797: where name = 'P_BATCH_NAME'
798: and varchar2_value = p_batch_name;
799:
800: l_effective_date:=hr_transaction_api.get_date_value
801: (p_transaction_step_id => l_transaction_step_id
802: ,p_name => 'P_EFFECTIVE_DATE');
803:
804: l_action_if_exists:=hr_transaction_api.get_varchar2_value

Line 804: l_action_if_exists:=hr_transaction_api.get_varchar2_value

800: l_effective_date:=hr_transaction_api.get_date_value
801: (p_transaction_step_id => l_transaction_step_id
802: ,p_name => 'P_EFFECTIVE_DATE');
803:
804: l_action_if_exists:=hr_transaction_api.get_varchar2_value
805: (p_transaction_step_id => l_transaction_step_id
806: ,p_name => 'P_ACTION_IF_EXISTS');
807:
808: l_date_effective_changes:=hr_transaction_api.get_varchar2_value

Line 808: l_date_effective_changes:=hr_transaction_api.get_varchar2_value

804: l_action_if_exists:=hr_transaction_api.get_varchar2_value
805: (p_transaction_step_id => l_transaction_step_id
806: ,p_name => 'P_ACTION_IF_EXISTS');
807:
808: l_date_effective_changes:=hr_transaction_api.get_varchar2_value
809: (p_transaction_step_id => l_transaction_step_id
810: ,p_name => 'P_DATE_EFFECTIVE_CHANGES');
811:
812: l_purge_after_transfer:=hr_transaction_api.get_varchar2_value

Line 812: l_purge_after_transfer:=hr_transaction_api.get_varchar2_value

808: l_date_effective_changes:=hr_transaction_api.get_varchar2_value
809: (p_transaction_step_id => l_transaction_step_id
810: ,p_name => 'P_DATE_EFFECTIVE_CHANGES');
811:
812: l_purge_after_transfer:=hr_transaction_api.get_varchar2_value
813: (p_transaction_step_id => l_transaction_step_id
814: ,p_name => 'P_PURGE_AFTER_TRANSFER');
815:
816: l_reject_if_future_changes:=hr_transaction_api.get_varchar2_value

Line 816: l_reject_if_future_changes:=hr_transaction_api.get_varchar2_value

812: l_purge_after_transfer:=hr_transaction_api.get_varchar2_value
813: (p_transaction_step_id => l_transaction_step_id
814: ,p_name => 'P_PURGE_AFTER_TRANSFER');
815:
816: l_reject_if_future_changes:=hr_transaction_api.get_varchar2_value
817: (p_transaction_step_id => l_transaction_step_id
818: ,p_name => 'P_REJECT_IF_FUTURE_CHANGES');
819:
820: insert into pay_batch_headers(BATCH_ID,BUSINESS_GROUP_ID,BATCH_NAME,batch_status,ACTION_IF_EXISTS,PURGE_AFTER_TRANSFER,REJECT_IF_FUTURE_CHANGES,DATE_EFFECTIVE_CHANGES)

Line 939: l_assignment_id:=hr_transaction_api.get_number_value(p_transaction_step_id => l_transaction_step_id,p_name=>l_temp10);

935: l_temp9 := l_assignment_number||'@'||l_element_type_id||'_%';
936:
937: l_temp10 := l_assignment_number||'@P_ASSIGNMENT_ID';
938:
939: l_assignment_id:=hr_transaction_api.get_number_value(p_transaction_step_id => l_transaction_step_id,p_name=>l_temp10);
940:
941: /* select distinct transaction_step_id into l_transaction_step_id_1
942: from hr_api_transaction_values
943: where name like l_temp9

Line 958: input_values(l_count) := hr_transaction_api.get_varchar2_value(p_transaction_step_id =>l_transaction_step_id,p_name=>l_input_value_attribute);

954: loop
955: fetch input_values_cur into l_input_value_id;
956: exit when input_values_cur%notfound;
957: l_input_value_attribute := l_assignment_number||'@'||l_element_type_id||'_'||l_input_value_id;
958: input_values(l_count) := hr_transaction_api.get_varchar2_value(p_transaction_step_id =>l_transaction_step_id,p_name=>l_input_value_attribute);
959: l_count := l_count+1;
960: end loop;
961: close input_values_cur;
962: /* pay_batch_element_entry_api.create_batch_line(p_session_date => sysdate,

Line 1374: input_values(l_count) := hr_transaction_api.get_varchar2_value(p_transaction_step_id =>l_transaction_step_id_1,p_name=>l_input_value_attribute);

1370:
1371:
1372: -- bee_trace('l_input_value_attribute'||l_input_value_attribute);
1373: -- bee_trace('stepid is'||l_transaction_step_id_1);
1374: input_values(l_count) := hr_transaction_api.get_varchar2_value(p_transaction_step_id =>l_transaction_step_id_1,p_name=>l_input_value_attribute);
1375: -- bee_trace('inputvalues are ---'||input_values(l_count));
1376: l_count := l_count+1;
1377: end loop;
1378: close input_values_cur;