APPS.PA_PURGE_ICIP dependencies on PA_DRAFT_INV_DETS_AR

Line 59: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_DETS_AR') ;

55: -- in the commit size.
56:
57: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
58:
59: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_DETS_AR') ;
60:
61: if p_txn_to_date IS NOT NULL then
62: insert into PA_DRAFT_INV_DETS_AR (
63: PURGE_BATCH_ID,

Line 62: insert into PA_DRAFT_INV_DETS_AR (

58:
59: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_DETS_AR') ;
60:
61: if p_txn_to_date IS NOT NULL then
62: insert into PA_DRAFT_INV_DETS_AR (
63: PURGE_BATCH_ID,
64: PURGE_RELEASE,
65: PURGE_PROJECT_ID,
66: DRAFT_INVOICE_DETAIL_ID,

Line 201: insert into PA_DRAFT_INV_DETS_AR (

197: and ei.task_id = t.task_id
198: and t.project_id = p_project_id )
199: and rownum <= l_commit_size;
200: else
201: insert into PA_DRAFT_INV_DETS_AR (
202: PURGE_BATCH_ID,
203: PURGE_RELEASE,
204: PURGE_PROJECT_ID,
205: DRAFT_INVOICE_DETAIL_ID,

Line 340: pa_debug.debug( ' ->After insert into PA_DRAFT_INV_DETS_AR') ;

336: and rownum <= l_commit_size;
337: end if;
338:
339: l_NoOfRecordsIns := SQL%ROWCOUNT ;
340: pa_debug.debug( ' ->After insert into PA_DRAFT_INV_DETS_AR') ;
341: /*Code Changes for Bug No.2984871 start */
342: if l_NoOfRecordsIns > 0 then
343: /*Code Changes for Bug No.2984871 end */
344: -- First call the MRC procedure to archive the MC table

Line 401: from pa_draft_inv_dets_ar did

397: update pa_draft_invoices_all di
398: set di.purge_flag = 'Y'
399: where ( di.project_id, di.draft_invoice_num ) in
400: ( select did.project_id, did.draft_invoice_num
401: from pa_draft_inv_dets_ar did
402: where did.cc_project_id = p_project_id
403: )
404: and rownum < l_commit_size;
405:

Line 412: from PA_DRAFT_INV_DETS_AR did2

408:
409: delete from pa_draft_invoice_details_all did
410: where (did.project_id, did.draft_invoice_detail_id) in
411: ( select did2.project_id, did2.draft_invoice_detail_id
412: from PA_DRAFT_INV_DETS_AR did2
413: where did2.purge_project_id = p_project_id
414: ) ;
415: /* Bug 2984871: Moved the below statement above the pa_debug.debug api call */
416: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 757: pa_draft_inv_dets_ar ar

753: mc.PROGRAM_APPLICATION_ID,
754: mc.PROGRAM_ID,
755: mc.PROGRAM_UPDATE_DATE
756: from pa_mc_draft_inv_details_all mc,
757: pa_draft_inv_dets_ar ar
758: where ar.purge_project_id = p_project_id
759: and mc.draft_invoice_detail_id = ar.draft_invoice_detail_id; */
760:
761: x_MRC_NoOfRecordsIns := nvl(SQL%ROWCOUNT,0) ;