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_INV_DETAILS_AR

Line 2323: PA_RETN_INV_DETAILS_AR ar

2319: mc.CREATED_BY,
2320: mc.LAST_UPDATE_DATE,
2321: mc.LAST_UPDATED_BY
2322: from Pa_MC_Retn_Inv_Details mc,
2323: PA_RETN_INV_DETAILS_AR ar
2324: where ar.Purge_Project_Id = p_project_id
2325: and mc.Project_Id = ar.purge_Project_Id
2326: and mc.Draft_Invoice_Num = ar.Draft_Invoice_Num
2327: and mc.Line_Num = ar.Line_Num;

Line 2399: pa_debug.debug( ' ->Before insert into PA_RETN_INV_DETAILS_AR') ;

2395: -- in the commit size.
2396:
2397: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
2398:
2399: pa_debug.debug( ' ->Before insert into PA_RETN_INV_DETAILS_AR') ;
2400: insert into PA_RETN_INV_DETAILS_AR (
2401: PURGE_BATCH_ID,
2402: PURGE_RELEASE,
2403: PURGE_PROJECT_ID,

Line 2400: insert into PA_RETN_INV_DETAILS_AR (

2396:
2397: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
2398:
2399: pa_debug.debug( ' ->Before insert into PA_RETN_INV_DETAILS_AR') ;
2400: insert into PA_RETN_INV_DETAILS_AR (
2401: PURGE_BATCH_ID,
2402: PURGE_RELEASE,
2403: PURGE_PROJECT_ID,
2404: RETN_INVOICE_DETAIL_ID,

Line 2459: pa_debug.debug( ' ->After insert into PA_RETN_INV_DETAILS_AR') ;

2455: ) ;
2456:
2457: l_NoOfRecordsIns := SQL%ROWCOUNT ;
2458:
2459: pa_debug.debug( ' ->After insert into PA_RETN_INV_DETAILS_AR') ;
2460:
2461: /*Code Changes for Bug No.2984871 start */
2462: if l_NoOfRecordsIns > 0 then
2463: /*Code Changes for Bug No.2984871 end */

Line 2507: PA_RETN_INV_DETAILS_AR rid2

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
2511: and rid2.purge_project_id = p_project_id

Line 2517: from PA_RETN_INV_DETAILS_AR rid2

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
2519: and rid2.purge_project_id = p_project_id
2520: ) ;
2521: /*Code Changes for Bug No.2984871 start */