APPS.PAY_BEE_SS dependencies on PAY_BATCH_HEADERS

Line 793: select pay_batch_headers_s.nextval into l_batch_id from dual;

789: begin
790:
791: -- -- -- bee_trace('Name is '||p_batch_name);
792:
793: select pay_batch_headers_s.nextval into l_batch_id from dual;
794:
795: select transaction_step_id into l_transaction_step_id
796: from hr_api_transaction_values
797: where name = 'P_BATCH_NAME'

Line 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)

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)
821: values(l_batch_id,p_business_group_id,p_batch_name,'U',l_action_if_exists,l_purge_after_transfer,l_reject_if_future_changes,l_date_effective_changes);
822:
823: update hr_api_transaction_values set number_value=l_batch_id
824: where name='P_BATCH_ID'

Line 904: select batch_id into l_batch_id from pay_batch_headers

900: from hr_api_transaction_values
901: where name like '%P_EMPLOYEE_NAME%'
902: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
903:
904: select batch_id into l_batch_id from pay_batch_headers
905: where batch_name = p_batch_name;
906:
907:
908:

Line 1095: select batch_id into l_batch_id from pay_batch_headers

1091:
1092: l_transaction_id := get_transaction_id_batch_name(p_batch_name=>p_batch_name);
1093: retcode :=0;
1094: -- bee_trace('Entered validate batch');
1095: select batch_id into l_batch_id from pay_batch_headers
1096: where batch_name = p_batch_name;
1097:
1098: -- bee_trace('Batch id is '||l_batch_id);
1099: l_request_id := pay_paywsqee_pkg.paylink_request_id(p_business_group_id=>p_business_group_id,

Line 1176: FROM pay_batch_headers

1172: -- -- -- bee_trace('Deleting batch header');
1173:
1174: --pay_batch_element_entry_api.delete_batch_header(p_batch_id=>l_batch_id,p_object_version_number=>1);
1175: SELECT batch_status into l_batch_status
1176: FROM pay_batch_headers
1177: WHERE batch_name =p_batch_name;
1178: --if l_validation_count=0 then
1179: --UPDATE hr_api_transaction_values
1180: --SET varchar2_value ='Valid'

Line 1192: delete from pay_batch_headers where batch_id=l_batch_id;

1188: --end if;
1189:
1190:
1191:
1192: delete from pay_batch_headers where batch_id=l_batch_id;
1193:
1194:
1195: --commit;
1196:

Line 1327: select batch_id into l_batch_id from pay_batch_headers

1323:
1324: -- bee_trace('bharath2'||l_transaction_step_id);
1325: -- bee_trace('p_batch_name'||p_batch_name);
1326:
1327: select batch_id into l_batch_id from pay_batch_headers
1328: where batch_name = p_batch_name;
1329: -- bee_trace('bharath3'||l_batch_id);
1330:
1331: open asg_entries_cur;

Line 1739: from pay_batch_headers

1735:
1736: end if;
1737:
1738: select batch_id into l_batch_id
1739: from pay_batch_headers
1740: where batch_name=l_batch_name;
1741:
1742: -- bee_trace('Batch id is '||l_batch_id);
1743:

Line 1779: from pay_batch_headers

1775:
1776: -- bee_trace('Entered transfer batch');
1777:
1778: select batch_id into l_batch_id
1779: from pay_batch_headers
1780: where batch_name=p_batch_name;
1781:
1782: -- bee_trace('Batch Id is '||l_batch_id);
1783: l_request_id := pay_paywsqee_pkg.paylink_request_id(p_business_group_id=>p_business_group_id,