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.PA_PURGE_BILLING dependencies on PA_RETN_INVOICE_DETAILS

Line 2358: -- Function : Archive and Purge data for table PA_RETN_INVOICE_DETAILS

2354: -- Start of comments
2355: -- API name : PA_RetnInvDetails
2356: -- Type : Private
2357: -- Pre-reqs : None
2358: -- Function : Archive and Purge data for table PA_RETN_INVOICE_DETAILS
2359: -- Parameters : See common list above
2360: -- End of comments
2361: procedure PA_RetnInvDetails
2362: ( p_purge_batch_id IN NUMBER,

Line 2383: x_err_stack := x_err_stack || ' ->Entering PA_RETN_INVOICE_DETAILS' ;

2379: begin
2380:
2381: l_old_err_stack := x_err_stack;
2382:
2383: x_err_stack := x_err_stack || ' ->Entering PA_RETN_INVOICE_DETAILS' ;
2384:
2385: pa_debug.debug(x_err_stack);
2386:
2387: LOOP

Line 2451: from PA_Retn_Invoice_Details

2447: CREATION_DATE,
2448: CREATED_BY,
2449: LAST_UPDATE_DATE,
2450: LAST_UPDATED_BY
2451: from PA_Retn_Invoice_Details
2452: where (
2453: project_id = p_project_id
2454: and rownum <= l_commit_size
2455: ) ;

Line 2482: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, starts here*/

2478: x_err_stack => x_err_stack,
2479: x_err_stage => x_err_stage
2480: ) ;
2481:
2482: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, starts here*/
2483: pa_debug.debug( ' ->Before delete from Pa_MC_Retn_Inv_Details ') ;
2484:
2485: /* Commented out for MRC migration to SLA delete from Pa_MC_Retn_Inv_Details rid
2486: where (rid.project_id, rid.draft_invoice_num) in

Line 2498: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here*/

2494: /*Code Changes for Bug No.2984871 end */
2495:
2496: pa_debug.debug( ' ->After delete from Pa_MC_Retn_Inv_Details ') ;
2497:
2498: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here*/
2499:
2500: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;
2501: /* commented and modified as below for performance reasons. Archive Purge 11.5
2502: delete from PA_Retn_Invoice_Details rid

Line 2500: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;

2496: pa_debug.debug( ' ->After delete from Pa_MC_Retn_Inv_Details ') ;
2497:
2498: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here*/
2499:
2500: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;
2501: /* commented and modified as below for performance reasons. Archive Purge 11.5
2502: delete from PA_Retn_Invoice_Details rid
2503: where (rid.rowid)
2504: in

Line 2502: delete from PA_Retn_Invoice_Details rid

2498: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here*/
2499:
2500: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;
2501: /* commented and modified as below for performance reasons. Archive Purge 11.5
2502: delete from PA_Retn_Invoice_Details rid
2503: where (rid.rowid)
2504: in
2505: ( select rid1.rowid
2506: from PA_Retn_Invoice_Details rid1,

Line 2506: from PA_Retn_Invoice_Details rid1,

2502: delete from PA_Retn_Invoice_Details rid
2503: where (rid.rowid)
2504: in
2505: ( select rid1.rowid
2506: from PA_Retn_Invoice_Details rid1,
2507: PA_RETN_INV_DETAILS_AR rid2
2508: where rid2.draft_invoice_num = rid1.draft_invoice_num
2509: and rid2.line_num = rid1.line_num
2510: and rid2.project_id = rid1.project_id

Line 2514: delete from PA_Retn_Invoice_Details rid

2510: and rid2.project_id = rid1.project_id
2511: and rid2.purge_project_id = p_project_id
2512: ) ;
2513: */
2514: delete from PA_Retn_Invoice_Details rid
2515: where (rid.project_id, rid.draft_invoice_num) in
2516: ( select rid2.project_id, rid2.draft_invoice_num
2517: from PA_RETN_INV_DETAILS_AR rid2
2518: where rid2.line_num = rid.line_num

Line 2525: pa_debug.debug( ' ->After delete from PA_Retn_Invoice_Details ') ;

2521: /*Code Changes for Bug No.2984871 start */
2522: l_NoOfRecordsDel := SQL%ROWCOUNT ;
2523: /*Code Changes for Bug No.2984871 end */
2524:
2525: pa_debug.debug( ' ->After delete from PA_Retn_Invoice_Details ') ;
2526:
2527: end if ;
2528: else
2529:

Line 2536: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, starts here */

2532: -- If the archive option is not selected then the delete will
2533: -- be based on the commit size.
2534:
2535:
2536: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, starts here */
2537: pa_debug.debug( ' ->Before delete from Pa_MC_Retn_Inv_Details ') ;
2538:
2539: /* Commented out for MRC migration to SLA delete from Pa_MC_Retn_Inv_Details rid
2540: where rid.project_id = p_project_id

Line 2548: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here */

2544: -- Code Changes for Bug No.2984871 end
2545:
2546: pa_debug.debug( ' ->After delete from Pa_MC_Retn_Inv_Details ') ;
2547:
2548: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here */
2549:
2550: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;
2551: /* commented and modified as below for performance reasons. Archive Purge 11.5
2552: delete from PA_Retn_Invoice_Details rid

Line 2550: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;

2546: pa_debug.debug( ' ->After delete from Pa_MC_Retn_Inv_Details ') ;
2547:
2548: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here */
2549:
2550: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;
2551: /* commented and modified as below for performance reasons. Archive Purge 11.5
2552: delete from PA_Retn_Invoice_Details rid
2553: where (rid.rowid)
2554: in

Line 2552: delete from PA_Retn_Invoice_Details rid

2548: /* Added the code to delete the records from the MC table of Pa_Retn_Invoice_Details for bug#2272487, ends here */
2549:
2550: pa_debug.debug( ' ->Before delete from PA_Retn_Invoice_Details ') ;
2551: /* commented and modified as below for performance reasons. Archive Purge 11.5
2552: delete from PA_Retn_Invoice_Details rid
2553: where (rid.rowid)
2554: in
2555: ( select rid1.rowid
2556: from PA_Retn_Invoice_Details rid1

Line 2556: from PA_Retn_Invoice_Details rid1

2552: delete from PA_Retn_Invoice_Details rid
2553: where (rid.rowid)
2554: in
2555: ( select rid1.rowid
2556: from PA_Retn_Invoice_Details rid1
2557: where rid1.project_id = p_project_id
2558: and rownum <= l_commit_size
2559: ) ;
2560: */

Line 2561: delete from PA_Retn_Invoice_Details rid

2557: where rid1.project_id = p_project_id
2558: and rownum <= l_commit_size
2559: ) ;
2560: */
2561: delete from PA_Retn_Invoice_Details rid
2562: where rid.project_id = p_project_id
2563: and rownum <= l_commit_size;
2564: /*Code Changes for Bug No.2984871 start */
2565: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 2568: pa_debug.debug( ' ->After delete from PA_Retn_Invoice_Details ') ;

2564: /*Code Changes for Bug No.2984871 start */
2565: l_NoOfRecordsDel := SQL%ROWCOUNT ;
2566: /*Code Changes for Bug No.2984871 end */
2567:
2568: pa_debug.debug( ' ->After delete from PA_Retn_Invoice_Details ') ;
2569:
2570: end if ;
2571:
2572: if l_NoOfRecordsDel = 0 then

Line 2588: p_table_name => 'PA_RETN_INVOICE_DETAILS',

2584: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
2585: pa_purge.CommitProcess
2586: (p_purge_batch_id => p_purge_batch_id,
2587: p_project_id => p_project_id,
2588: p_table_name => 'PA_RETN_INVOICE_DETAILS',
2589: p_NoOfRecordsIns => l_NoOfRecordsIns,
2590: p_NoOfRecordsDel => l_NoOfRecordsDel,
2591: x_err_code => x_err_code,
2592: x_err_stack => x_err_stack,