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 442: DELETE FROM pa_transaction_interface_all

438: /* End Changes to check migration to OAF Effort Reporting before Supercedence */
439:
440: /* Bug 2133056: Moved this stmt from Tie Back process */
441:
442: DELETE FROM pa_transaction_interface_all
443: -- WHERE batch_name = g_gms_batch_name
444: WHERE batch_name IN (SELECT GMS_BATCH_NAME
445: FROM psp_summary_lines
446: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id

Line 3399: FROM pa_transaction_interface_all

3395: CURSOR gms_tie_back_reject_cur(p_gms_batch_name number, p_payroll_control_id number, p_txn_src varchar2) IS
3396: SELECT nvl(transaction_rejection_code,'P'),
3397: orig_transaction_reference,
3398: transaction_status_code
3399: FROM pa_transaction_interface_all
3400: WHERE batch_name = to_char(p_gms_batch_name)
3401: AND transaction_status_code in ('R', 'PO', 'PI', 'PR')
3402: AND transaction_source = p_txn_src
3403: AND orig_transaction_reference in

Line 3482: FROM pa_transaction_interface_all

3478: AND gms_batch_name IS NOT NULL;
3479:
3480: CURSOR transaction_source_cur IS
3481: SELECT transaction_source
3482: FROM pa_transaction_interface_all
3483: WHERE batch_name = TO_CHAR(l_gms_batch_name);
3484:
3485: CURSOR cnt_gms_interface_cur IS
3486: SELECT count(*)

Line 3487: FROM pa_transaction_interface_all

3483: WHERE batch_name = TO_CHAR(l_gms_batch_name);
3484:
3485: CURSOR cnt_gms_interface_cur IS
3486: SELECT count(*)
3487: FROM pa_transaction_interface_all
3488: WHERE batch_name = TO_CHAR(l_gms_batch_name)
3489: AND transaction_source = l_txn_source
3490: AND transaction_status_code IN ('R', 'PO', 'PI', 'PR')
3491: AND orig_transaction_reference IN (SELECT TO_CHAR(summary_line_id)

Line 3499: from pa_transaction_interface_all

3495: FUNCTION PROCESS_COMPLETE RETURN BOOLEAN IS
3496:
3497: cursor get_completion is
3498: select count(*), transaction_status_code
3499: from pa_transaction_interface_all
3500: where batch_name = to_char(l_gms_batch_name)
3501: and transaction_source = l_txn_source
3502: and transaction_status_code in ('P', 'I')
3503: group by transaction_status_code ;

Line 3512: from pa_transaction_interface_all

3508: select expenditure_group
3509: from pa_expenditures_all
3510: where expenditure_id in
3511: (select expenditure_id
3512: from pa_transaction_interface_all
3513: where transaction_source in ('OLD', 'GOLD') and
3514: transaction_rejection_code is null and
3515: batch_name = l_gms_batch_name )
3516: and expenditure_group is not null;

Line 3541: delete from pa_transaction_interface_all

3537: -- for some reason. Return 'NOT_RUN' in this case. So cleanup the tables and try to transfer
3538: -- again after summarization in the second pass.
3539: -- -------------------------------------------------------------------------------------------
3540:
3541: delete from pa_transaction_interface_all
3542: where batch_name = to_char(l_gms_batch_name)
3543: and transaction_source = l_txn_source;
3544:
3545: if (l_txn_source = 'GOLD') then

Line 3610: delete pa_transaction_interface_all

3606: where transaction_source in ('GOLD') and
3607: batch_name = l_gms_batch_name;
3608: end if;
3609:
3610: delete pa_transaction_interface_all
3611: where transaction_source in ('GOLD','OLD') and
3612: batch_name = l_gms_batch_name;
3613:
3614: delete psp_summary_lines

Line 3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');

3640:
3641: BEGIN
3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:

Line 3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');

3641: BEGIN
3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:
3649: open pc_batch_cur;

Line 3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');

3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:
3649: open pc_batch_cur;
3650: loop

Line 3758: from pa_transaction_interface_all PTXN

3754: SET (PSL.status_code, PSL.expenditure_ending_date,PSL.expenditure_id,
3755: PSL.interface_id,PSL.expenditure_item_id,PSL.txn_interface_id) =
3756: (select 'A', PTXN.expenditure_ending_date,PTXN.expenditure_id,
3757: PTXN.interface_id,PTXN.expenditure_item_id,PTXN.txn_interface_id
3758: from pa_transaction_interface_all PTXN
3759: where PTXN.transaction_source = l_txn_source
3760: and PTXN.orig_transaction_reference= to_char(PSL.summary_line_id)
3761: and PTXN.batch_name = l_gms_batch_name1)
3762: WHERE PSL.gms_batch_name = l_gms_batch_name1; --- changed g_gms_batch_name to l_gms_batch_name for 2444657

Line 3837: DELETE FROM pa_transaction_interface_all

3833: AND summary_line_id = l_summary_line_id
3834: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
3835:
3836: /* Bug 2133056: Moving this statment into Mark Batch End process, for del exp stmt to work.
3837: DELETE FROM pa_transaction_interface_all
3838: WHERE orig_transaction_reference = to_char(l_summary_line_id)
3839: AND transaction_status_code = 'A'
3840: AND transaction_source = l_txn_source; */
3841:

Line 3920: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(

3916: END IF;
3917:
3918: /* Intoduced the following for Bug 2935850 */
3919:
3920: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(
3921: TXN_INTERFACE_ID,
3922: TRANSACTION_SOURCE,
3923: BATCH_NAME,
3924: EXPENDITURE_ENDING_DATE,

Line 4043: from pa_transaction_interface_all

4039: select expenditure_group
4040: from pa_expenditures_all
4041: where expenditure_id in
4042: (select expenditure_id
4043: from pa_transaction_interface_all
4044: where transaction_source in ('OLD', 'GOLD') and
4045: transaction_status_code = 'A' and
4046: -- batch_name = g_gms_batch_name and
4047: batch_name IN (SELECT gms_batch_name FROM psp_summary_lines WHERE payroll_control_id = p_payroll_control_id) and

Line 4116: from pa_transaction_interface_all XFACE

4112: -- Bug 2133056.. Corrected not to delete non-orphan expenditures
4113: delete pa_expenditures_all EXP
4114: where EXP.expenditure_id in
4115: (select XFACE.expenditure_id
4116: from pa_transaction_interface_all XFACE
4117: where XFACE.transaction_source in('OLD','GOLD')
4118: and XFACE.orig_transaction_reference in
4119: (select to_char(PSL.summary_line_id)
4120: from psp_summary_lines PSL

Line 4132: delete pa_transaction_interface_all

4128: where ITEMS.expenditure_id = EXP.expenditure_id);
4129:
4130: /*****************************************************************************
4131: Commenting the following for the Bug 2290051
4132: delete pa_transaction_interface_all
4133: where transaction_source in ('OLD','GOLD') and
4134: batch_name = g_gms_batch_name and
4135: orig_transaction_reference in
4136: (select to_char(summary_line_id)

Line 4282: FROM pa_transaction_interface_all

4278: AND transaction_source in ('OLD','GOLD'); --- Added condn for Bug 2133056
4279:
4280: CURSOR pa_txn_int_status_i_cur IS
4281: SELECT count(*)
4282: FROM pa_transaction_interface_all
4283: WHERE batch_name = TO_CHAR(l_gms_batch_name)
4284: AND transaction_source in ('OLD','GOLD')
4285: AND transaction_status_code = 'I'; --- Added condn for Bug 2133056
4286:

Line 4369: delete from pa_transaction_interface_all

4365: set gms_phase = NULL
4366: where payroll_control_id = payroll_control_rec.payroll_control_id
4367: and gms_phase = 'Submitted_Import_Request';
4368:
4369: delete from pa_transaction_interface_all
4370: where batch_name = to_char(l_gms_batch_name)
4371: and transaction_source in ('GOLD', 'OLD');
4372:
4373: delete from gms_transaction_interface_all