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_ADJ dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 508: DELETE FROM pa_transaction_interface_all

504: /* End Changes to check migration to OAF Effort Reporting before Supercedence */
505:
506: /* Bug 2133056: Moved this stmt from Tie Back process */
507:
508: DELETE FROM pa_transaction_interface_all
509: -- WHERE batch_name = g_gms_batch_name
510: WHERE batch_name IN (SELECT GMS_BATCH_NAME
511: FROM psp_summary_lines
512: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id

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

514: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
515: ---AND transaction_status_code = 'A' delete 'R' also, for 2445196
516: AND transaction_source in ('OLD', 'GOLD');
517:
518: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' delete from pa_transaction_interface_all count : '||sql%rowcount);
519:
520: -- introduced following stmnt for 2445196
521: delete from gms_transaction_interface_all
522: -- where batch_name = g_gms_batch_name

Line 3474: UPDATE pa_transaction_interface_all

3470: SELECT to_char(psp_gms_batch_name_s.nextval)
3471: INTO l_gms_stat_batch_name
3472: FROM DUAL;
3473:
3474: UPDATE pa_transaction_interface_all
3475: SET BATCH_NAME = l_gms_stat_batch_name
3476: where DENOM_CURRENCY_CODE = 'STAT'
3477: and BATCH_NAME = l_gms_batch_name
3478: and TRANSACTION_SOURCE = l_txn_source;

Line 3479: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated pa_transaction_interface_all set batch_name to '||l_gms_stat_batch_name||' for STAT records count: '||sql%rowcount);

3475: SET BATCH_NAME = l_gms_stat_batch_name
3476: where DENOM_CURRENCY_CODE = 'STAT'
3477: and BATCH_NAME = l_gms_batch_name
3478: and TRANSACTION_SOURCE = l_txn_source;
3479: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated pa_transaction_interface_all set batch_name to '||l_gms_stat_batch_name||' for STAT records count: '||sql%rowcount);
3480:
3481: UPDATE psp_summary_lines
3482: SET gms_batch_name = l_gms_stat_batch_name
3483: WHERE payroll_control_id IN(select payroll_control_id from psp_payroll_controls

Line 3494: FROM pa_transaction_interface_all

3490:
3491:
3492:
3493: SELECT count(*) INTO l_not_stat_count
3494: FROM pa_transaction_interface_all
3495: WHERE BATCH_NAME = l_gms_batch_name;
3496:
3497: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||'l_gms_batch_name'||l_gms_batch_name);
3498: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||'l_gms_stat_batch_name'||l_gms_stat_batch_name);

Line 3587: FROM pa_transaction_interface_all

3583: END IF; -- l_not_stat_count
3584:
3585:
3586: SELECT count(*) INTO l_stat_count -- change
3587: FROM pa_transaction_interface_all
3588: WHERE BATCH_NAME = l_gms_stat_batch_name;
3589:
3590: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' l_stat_count'||l_stat_count);
3591:

Line 3758: FROM pa_transaction_interface_all

3754: CURSOR gms_tie_back_reject_cur(p_gms_batch_name number, p_payroll_control_id number, p_txn_src varchar2) IS
3755: SELECT nvl(transaction_rejection_code,'P'),
3756: orig_transaction_reference,
3757: transaction_status_code
3758: FROM pa_transaction_interface_all
3759: WHERE batch_name = to_char(p_gms_batch_name)
3760: AND transaction_status_code in ('R', 'PO', 'PI', 'PR')
3761: AND transaction_source = p_txn_src
3762: AND orig_transaction_reference in

Line 3841: FROM pa_transaction_interface_all

3837: AND gms_batch_name IS NOT NULL;
3838:
3839: CURSOR transaction_source_cur IS
3840: SELECT transaction_source
3841: FROM pa_transaction_interface_all
3842: WHERE batch_name = TO_CHAR(l_gms_batch_name);
3843:
3844: CURSOR cnt_gms_interface_cur IS
3845: SELECT count(*)

Line 3846: FROM pa_transaction_interface_all

3842: WHERE batch_name = TO_CHAR(l_gms_batch_name);
3843:
3844: CURSOR cnt_gms_interface_cur IS
3845: SELECT count(*)
3846: FROM pa_transaction_interface_all
3847: WHERE batch_name = TO_CHAR(l_gms_batch_name)
3848: AND transaction_source = l_txn_source
3849: AND transaction_status_code IN ('R', 'PO', 'PI', 'PR')
3850: AND orig_transaction_reference IN (SELECT TO_CHAR(summary_line_id)

Line 3858: from pa_transaction_interface_all

3854: FUNCTION PROCESS_COMPLETE RETURN BOOLEAN IS
3855:
3856: cursor get_completion is
3857: select count(*), transaction_status_code
3858: from pa_transaction_interface_all
3859: where batch_name = to_char(l_gms_batch_name)
3860: and transaction_source = l_txn_source
3861: and transaction_status_code in ('P', 'I')
3862: group by transaction_status_code ;

Line 3871: from pa_transaction_interface_all

3867: select expenditure_group
3868: from pa_expenditures_all
3869: where expenditure_id in
3870: (select expenditure_id
3871: from pa_transaction_interface_all
3872: where transaction_source in ('OLD', 'GOLD') and
3873: transaction_rejection_code is null and
3874: batch_name = l_gms_batch_name )
3875: and expenditure_group is not null;

Line 3904: delete from pa_transaction_interface_all

3900: -- for some reason. Return 'NOT_RUN' in this case. So cleanup the tables and try to transfer
3901: -- again after summarization in the second pass.
3902: -- -------------------------------------------------------------------------------------------
3903:
3904: delete from pa_transaction_interface_all
3905: where batch_name = to_char(l_gms_batch_name)
3906: and transaction_source = l_txn_source;
3907:
3908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from pa_transaction_interface_all count: '||sql%rowcount);

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

3904: delete from pa_transaction_interface_all
3905: where batch_name = to_char(l_gms_batch_name)
3906: and transaction_source = l_txn_source;
3907:
3908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from pa_transaction_interface_all count: '||sql%rowcount);
3909:
3910:
3911: if (l_txn_source = 'GOLD') then
3912: delete from gms_transaction_interface_all

Line 3992: delete pa_transaction_interface_all

3988: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gms_transaction_interface_all count: '||sql%rowcount);
3989:
3990: end if;
3991:
3992: delete pa_transaction_interface_all
3993: where transaction_source in ('GOLD','OLD') and
3994: batch_name = l_gms_batch_name;
3995:
3996: delete psp_summary_lines

Line 4173: from pa_transaction_interface_all PTXN

4169: SET (PSL.status_code, PSL.expenditure_ending_date,PSL.expenditure_id,
4170: PSL.interface_id,PSL.expenditure_item_id,PSL.txn_interface_id) =
4171: (select 'A', PTXN.expenditure_ending_date,PTXN.expenditure_id,
4172: PTXN.interface_id,PTXN.expenditure_item_id,PTXN.txn_interface_id
4173: from pa_transaction_interface_all PTXN
4174: where PTXN.transaction_source = l_txn_source
4175: and PTXN.orig_transaction_reference= to_char(PSL.summary_line_id)
4176: and PTXN.batch_name = l_gms_batch_name1)
4177: WHERE PSL.gms_batch_name = l_gms_batch_name1; --- changed g_gms_batch_name to l_gms_batch_name for 2444657

Line 4252: DELETE FROM pa_transaction_interface_all

4248: AND summary_line_id = l_summary_line_id
4249: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
4250:
4251: /* Bug 2133056: Moving this statment into Mark Batch End process, for del exp stmt to work.
4252: DELETE FROM pa_transaction_interface_all
4253: WHERE orig_transaction_reference = to_char(l_summary_line_id)
4254: AND transaction_status_code = 'A'
4255: AND transaction_source = l_txn_source; */
4256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_summary_lines, psp_adjustment_lines inserted into

Line 4349: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(

4345: END IF;
4346:
4347: /* Intoduced the following for Bug 2935850 */
4348:
4349: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(
4350: TXN_INTERFACE_ID,
4351: TRANSACTION_SOURCE,
4352: BATCH_NAME,
4353: EXPENDITURE_ENDING_DATE,

Line 4474: from pa_transaction_interface_all

4470: select expenditure_group
4471: from pa_expenditures_all
4472: where expenditure_id in
4473: (select expenditure_id
4474: from pa_transaction_interface_all
4475: where transaction_source in ('OLD', 'GOLD') and
4476: transaction_status_code = 'A' and
4477: -- batch_name = g_gms_batch_name and
4478: batch_name IN (SELECT gms_batch_name FROM psp_summary_lines WHERE payroll_control_id = p_payroll_control_id) and

Line 4547: from pa_transaction_interface_all XFACE

4543: -- Bug 2133056.. Corrected not to delete non-orphan expenditures
4544: delete pa_expenditures_all EXP
4545: where EXP.expenditure_id in
4546: (select XFACE.expenditure_id
4547: from pa_transaction_interface_all XFACE
4548: where XFACE.transaction_source in('OLD','GOLD')
4549: and XFACE.orig_transaction_reference in
4550: (select to_char(PSL.summary_line_id)
4551: from psp_summary_lines PSL

Line 4563: delete pa_transaction_interface_all

4559: where ITEMS.expenditure_id = EXP.expenditure_id);
4560:
4561: /*****************************************************************************
4562: Commenting the following for the Bug 2290051
4563: delete pa_transaction_interface_all
4564: where transaction_source in ('OLD','GOLD') and
4565: batch_name = g_gms_batch_name and
4566: orig_transaction_reference in
4567: (select to_char(summary_line_id)

Line 4713: FROM pa_transaction_interface_all

4709: AND transaction_source in ('OLD','GOLD'); --- Added condn for Bug 2133056
4710:
4711: CURSOR pa_txn_int_status_i_cur IS
4712: SELECT count(*)
4713: FROM pa_transaction_interface_all
4714: WHERE batch_name = TO_CHAR(l_gms_batch_name)
4715: AND transaction_source in ('OLD','GOLD')
4716: AND transaction_status_code = 'I'; --- Added condn for Bug 2133056
4717:

Line 4800: delete from pa_transaction_interface_all

4796: set gms_phase = NULL
4797: where payroll_control_id = payroll_control_rec.payroll_control_id
4798: and gms_phase = 'Submitted_Import_Request';
4799:
4800: delete from pa_transaction_interface_all
4801: where batch_name = to_char(l_gms_batch_name)
4802: and transaction_source in ('GOLD', 'OLD');
4803:
4804: delete from gms_transaction_interface_all