APPS.PA_PURGE_ICIP dependencies on PA_UTILS2

Line 57: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;

53: -- before being purged. The where condition is such that
54: -- only the it inserts half the no. of records specified
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

Line 369: pa_utils2.MRC_row_count := 0;

365: * counter tracking the number of records that deleted from
366: * the mrc table.
367: */
368: IF (l_mrc_flag = 'Y') THEN
369: pa_utils2.MRC_row_count := 0;
370: END IF;
371:
372: x_err_stage := 'Before deleting records from PA_MC_DRAFT_INV_DETAILS_ALL';
373: /*delete from pa_mc_draft_inv_details_all mdi

Line 424: l_commit_size := pa_utils2.arpur_mrc_commit_size;

420:
421: end if ;
422: else
423:
424: l_commit_size := pa_utils2.arpur_mrc_commit_size;
425: l_pmy_commit_size := pa_utils2.arpur_commit_size;
426:
427: /* Each time thru the loop need to make sure that reset the
428: * counter tracking the number of records that deleted from

Line 425: l_pmy_commit_size := pa_utils2.arpur_commit_size;

421: end if ;
422: else
423:
424: l_commit_size := pa_utils2.arpur_mrc_commit_size;
425: l_pmy_commit_size := pa_utils2.arpur_commit_size;
426:
427: /* Each time thru the loop need to make sure that reset the
428: * counter tracking the number of records that deleted from
429: * the mrc table.

Line 432: pa_utils2.MRC_row_count := 0;

428: * counter tracking the number of records that deleted from
429: * the mrc table.
430: */
431: IF (l_mrc_flag = 'Y') THEN
432: pa_utils2.MRC_row_count := 0;
433: END IF;
434:
435: -- If the archive option is not selected then the delete will
436: -- be based on the commit size.

Line 605: PA_UTILS2.mrc_row_count := 0;

601: p_MRC_NoOfRecordsIns => l_MRC_NoOfRecordsIns,
602: p_MRC_NoOfRecordsDel => l_MRC_NoOfRecordsDel
603: ) ;
604:
605: PA_UTILS2.mrc_row_count := 0;
606:
607: end if ;
608: END LOOP ;
609:

Line 616: l_commit_size := pa_utils2.arpur_mrc_commit_size;

612: --Fix for bug#7701114 , creating a separate loop to delete records from pa_draft_invoice_details_all
613: LOOP
614: IF p_archive_flag <> 'Y' THEN
615:
616: l_commit_size := pa_utils2.arpur_mrc_commit_size;
617:
618: IF p_txn_to_date is NOT NULL THEN
619: delete from pa_draft_invoice_details_all did
620: where (did.expenditure_item_id ) in