eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_SUM_TRANS dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 429: from pa_transaction_interface_all

425: where payroll_control_id = payroll_control_rec.payroll_control_id;
426:
427: select count(*)
428: into l_ti_not_complete
429: from pa_transaction_interface_all
430: where transaction_status_code = 'I'
431: and batch_name = to_char(l_gms_batch_name)
432: and transaction_source in ('GOLD', 'OLD');
433:

Line 4327: FROM pa_transaction_interface_all

4323: expenditure_id,
4324: interface_id,
4325: expenditure_item_id,
4326: txn_interface_id
4327: FROM pa_transaction_interface_all
4328: WHERE batch_name = p_gms_batch_name
4329: AND transaction_source = p_txn_source;
4330:
4331: CURSOR assign_susp_ac_cur(P_SUMMARY_LINE_ID IN NUMBER) IS

Line 4541: from pa_transaction_interface_all

4537: FUNCTION PROCESS_COMPLETE RETURN BOOLEAN IS
4538:
4539: cursor get_completion is
4540: select count(*), transaction_status_code
4541: from pa_transaction_interface_all
4542: where batch_name = p_gms_batch_name
4543: and transaction_source = p_txn_source
4544: and transaction_status_code in ('P', 'I')
4545: group by transaction_status_code ;

Line 4575: delete from pa_transaction_interface_all

4571: -- for some reason. Return 'NOT_RUN' in this case. So cleanup the tables and try to transfer
4572: -- again after summarization in the second pass.
4573: -- -------------------------------------------------------------------------------------------
4574:
4575: delete from pa_transaction_interface_all
4576: where batch_name = p_gms_batch_name
4577: and transaction_source = p_txn_source;
4578:
4579: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count:'||sql%rowcount);

Line 4579: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count:'||sql%rowcount);

4575: delete from pa_transaction_interface_all
4576: where batch_name = p_gms_batch_name
4577: and transaction_source = p_txn_source;
4578:
4579: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count:'||sql%rowcount);
4580:
4581:
4582: if p_txn_source = 'GOLD' then
4583: delete from gms_transaction_interface_all

Line 4646: FROM pa_transaction_interface_all

4642: -- to following select statement
4643:
4644: SELECT count(*)
4645: INTO l_cnt_gms_interface
4646: FROM pa_transaction_interface_all
4647: WHERE batch_name = p_gms_batch_name
4648: AND transaction_source = p_txn_source
4649: AND transaction_status_code in ('R', 'PO', 'PI', 'PR');
4650:

Line 4651: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' selected pa_transaction_interface_all with status_code in R,PO,PI,PR l_cnt_gms_interface :'||l_cnt_gms_interface);

4647: WHERE batch_name = p_gms_batch_name
4648: AND transaction_source = p_txn_source
4649: AND transaction_status_code in ('R', 'PO', 'PI', 'PR');
4650:
4651: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' selected pa_transaction_interface_all with status_code in R,PO,PI,PR l_cnt_gms_interface :'||l_cnt_gms_interface);
4652:
4653: /* moved this statement to beginning for 2444657 */
4654: UPDATE psp_payroll_controls
4655: SET phase = 'GL_Tie_Back'

Line 5120: DELETE pa_transaction_interface_all

5116: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
5117:
5118:
5119: -- Introduced for bug fix 2643228
5120: DELETE pa_transaction_interface_all
5121: WHERE transaction_source = p_txn_source
5122: AND batch_name = p_gms_batch_name;
5123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count: '||sql%rowcount);
5124:

Line 5123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count: '||sql%rowcount);

5119: -- Introduced for bug fix 2643228
5120: DELETE pa_transaction_interface_all
5121: WHERE transaction_source = p_txn_source
5122: AND batch_name = p_gms_batch_name;
5123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count: '||sql%rowcount);
5124:
5125:
5126: DELETE gms_transaction_interface_all
5127: WHERE transaction_source = p_txn_source

Line 5279: FROM PA_TRANSACTION_INTERFACE_ALL PTXN

5275: Set (PSL.STATUS_CODE, PSL.EXPENDITURE_ENDING_DATE,PSL.EXPENDITURE_ID,
5276: PSL.INTERFACE_ID,PSL.EXPENDITURE_ITEM_ID,PSL.TXN_INTERFACE_ID) =
5277: ( SELECT 'A', PTXN.EXPENDITURE_ENDING_DATE,PTXN.EXPENDITURE_ID, PTXN.INTERFACE_ID,
5278: PTXN.EXPENDITURE_ITEM_ID,PTXN.TXN_INTERFACE_ID
5279: FROM PA_TRANSACTION_INTERFACE_ALL PTXN
5280: WHERE PTXN.TRANSACTION_SOURCE = p_txn_source
5281: AND PTXN.ORIG_TRANSACTION_REFERENCE= SUMMARY_LINES_REC.L_SUMMARY_LINE_ID_CHAR(i)
5282: AND PTXN.BATCH_NAME = SUMMARY_LINES_REC.L_GMS_BATCH_NAME(i)
5283: )

Line 5297: from pa_transaction_interface_all PTXN

5293: SET (PSL.status_code, PSL.expenditure_ending_date,PSL.expenditure_id,
5294: PSL.interface_id,PSL.expenditure_item_id,PSL.txn_interface_id) =
5295: (select 'A', PTXN.expenditure_ending_date,PTXN.expenditure_id,
5296: PTXN.interface_id,PTXN.expenditure_item_id,PTXN.txn_interface_id
5297: from pa_transaction_interface_all PTXN
5298: where PTXN.transaction_source = p_txn_source
5299: and PTXN.orig_transaction_reference= to_char(PSL.summary_line_id)
5300: and PTXN.batch_name = p_gms_batch_name)
5301: WHERE gms_batch_name = p_gms_batch_name;

Line 5439: DELETE pa_transaction_interface_all

5435: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
5436:
5437:
5438: -- Introduced for bug fix 2643228
5439: DELETE pa_transaction_interface_all
5440: WHERE transaction_source = p_txn_source
5441: AND batch_name = p_gms_batch_name;
5442: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' delete from pa_transaction_interface_all for batch_name: '||p_gms_batch_name);
5443:

Line 5442: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' delete from pa_transaction_interface_all for batch_name: '||p_gms_batch_name);

5438: -- Introduced for bug fix 2643228
5439: DELETE pa_transaction_interface_all
5440: WHERE transaction_source = p_txn_source
5441: AND batch_name = p_gms_batch_name;
5442: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' delete from pa_transaction_interface_all for batch_name: '||p_gms_batch_name);
5443:
5444:
5445: DELETE gms_transaction_interface_all
5446: WHERE transaction_source = p_txn_source

Line 5455: delete pa_transaction_interface_all

5451: -- End of bug fix 2643228
5452: END IF;
5453: /***** Commented for bug fix 2643228
5454: -- introduced for 2445196
5455: delete pa_transaction_interface_all
5456: where transaction_source = p_txn_source
5457: and batch_name = p_gms_batch_name;
5458:
5459: delete gms_transaction_interface_all

Line 5545: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(

5541: END IF;
5542:
5543: -- dbms_output.put_line('batch name='||p_batch_name);
5544:
5545: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(
5546: TXN_INTERFACE_ID,
5547: TRANSACTION_SOURCE,
5548: BATCH_NAME,
5549: EXPENDITURE_ENDING_DATE,