APPS.PSP_SUM_TRANS dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 376: from pa_transaction_interface_all

372: where payroll_control_id = payroll_control_rec.payroll_control_id;
373:
374: select count(*)
375: into l_ti_not_complete
376: from pa_transaction_interface_all
377: where transaction_status_code = 'I'
378: and batch_name = to_char(l_gms_batch_name)
379: and transaction_source in ('GOLD', 'OLD');
380:

Line 4064: FROM pa_transaction_interface_all

4060: expenditure_id,
4061: interface_id,
4062: expenditure_item_id,
4063: txn_interface_id
4064: FROM pa_transaction_interface_all
4065: WHERE batch_name = p_gms_batch_name
4066: AND transaction_source = p_txn_source;
4067:
4068: CURSOR assign_susp_ac_cur(P_SUMMARY_LINE_ID IN NUMBER) IS

Line 4278: from pa_transaction_interface_all

4274: FUNCTION PROCESS_COMPLETE RETURN BOOLEAN IS
4275:
4276: cursor get_completion is
4277: select count(*), transaction_status_code
4278: from pa_transaction_interface_all
4279: where batch_name = p_gms_batch_name
4280: and transaction_source = p_txn_source
4281: and transaction_status_code in ('P', 'I')
4282: group by transaction_status_code ;

Line 4308: delete from pa_transaction_interface_all

4304: -- for some reason. Return 'NOT_RUN' in this case. So cleanup the tables and try to transfer
4305: -- again after summarization in the second pass.
4306: -- -------------------------------------------------------------------------------------------
4307:
4308: delete from pa_transaction_interface_all
4309: where batch_name = p_gms_batch_name
4310: and transaction_source = p_txn_source;
4311:
4312: if p_txn_source = 'GOLD' then

Line 4366: FROM pa_transaction_interface_all

4362: -- to following select statement
4363:
4364: SELECT count(*)
4365: INTO l_cnt_gms_interface
4366: FROM pa_transaction_interface_all
4367: WHERE batch_name = p_gms_batch_name
4368: AND transaction_source = p_txn_source
4369: AND transaction_status_code in ('R', 'PO', 'PI', 'PR');
4370:

Line 4770: DELETE pa_transaction_interface_all

4766: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
4767: WHERE payroll_control_id = p_payroll_control_id;
4768:
4769: -- Introduced for bug fix 2643228
4770: DELETE pa_transaction_interface_all
4771: WHERE transaction_source = p_txn_source
4772: AND batch_name = p_gms_batch_name;
4773:
4774: DELETE gms_transaction_interface_all

Line 4902: FROM PA_TRANSACTION_INTERFACE_ALL PTXN

4898: Set (PSL.STATUS_CODE, PSL.EXPENDITURE_ENDING_DATE,PSL.EXPENDITURE_ID,
4899: PSL.INTERFACE_ID,PSL.EXPENDITURE_ITEM_ID,PSL.TXN_INTERFACE_ID) =
4900: ( SELECT 'A', PTXN.EXPENDITURE_ENDING_DATE,PTXN.EXPENDITURE_ID, PTXN.INTERFACE_ID,
4901: PTXN.EXPENDITURE_ITEM_ID,PTXN.TXN_INTERFACE_ID
4902: FROM PA_TRANSACTION_INTERFACE_ALL PTXN
4903: WHERE PTXN.TRANSACTION_SOURCE = p_txn_source
4904: AND PTXN.ORIG_TRANSACTION_REFERENCE= SUMMARY_LINES_REC.L_SUMMARY_LINE_ID_CHAR(i)
4905: AND PTXN.BATCH_NAME = SUMMARY_LINES_REC.L_GMS_BATCH_NAME(i)
4906: )

Line 4917: from pa_transaction_interface_all PTXN

4913: SET (PSL.status_code, PSL.expenditure_ending_date,PSL.expenditure_id,
4914: PSL.interface_id,PSL.expenditure_item_id,PSL.txn_interface_id) =
4915: (select 'A', PTXN.expenditure_ending_date,PTXN.expenditure_id,
4916: PTXN.interface_id,PTXN.expenditure_item_id,PTXN.txn_interface_id
4917: from pa_transaction_interface_all PTXN
4918: where PTXN.transaction_source = p_txn_source
4919: and PTXN.orig_transaction_reference= to_char(PSL.summary_line_id)
4920: and PTXN.batch_name = p_gms_batch_name)
4921: WHERE gms_batch_name = p_gms_batch_name;

Line 5035: DELETE pa_transaction_interface_all

5031: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
5032: WHERE payroll_control_id = p_payroll_control_id;
5033:
5034: -- Introduced for bug fix 2643228
5035: DELETE pa_transaction_interface_all
5036: WHERE transaction_source = p_txn_source
5037: AND batch_name = p_gms_batch_name;
5038:
5039: DELETE gms_transaction_interface_all

Line 5046: delete pa_transaction_interface_all

5042: -- End of bug fix 2643228
5043: END IF;
5044: /***** Commented for bug fix 2643228
5045: -- introduced for 2445196
5046: delete pa_transaction_interface_all
5047: where transaction_source = p_txn_source
5048: and batch_name = p_gms_batch_name;
5049:
5050: delete gms_transaction_interface_all

Line 5129: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(

5125: BEGIN
5126:
5127: -- dbms_output.put_line('batch name='||p_batch_name);
5128:
5129: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(
5130: TXN_INTERFACE_ID,
5131: TRANSACTION_SOURCE,
5132: BATCH_NAME,
5133: EXPENDITURE_ENDING_DATE,