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 602: PA_UTILS2.mrc_row_count := 0;

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