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_UTILS2

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

200:
201: OPEN c_crdl_records;
202:
203: if p_archive_flag = 'Y' then
204: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
205: else
206: l_commit_size := pa_utils2.arpur_mrc_commit_size ;
207: end if;
208:

Line 206: l_commit_size := pa_utils2.arpur_mrc_commit_size ;

202:
203: if p_archive_flag = 'Y' then
204: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
205: else
206: l_commit_size := pa_utils2.arpur_mrc_commit_size ;
207: end if;
208:
209: LOOP
210:

Line 227: /* l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ; */

223: -- before being purged. The where condition is such that
224: -- only the it inserts half the no. of records specified
225: -- in the commit size.
226:
227: /* l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ; */
228:
229: pa_debug.debug( ' ->Before insert into PA_Revenue_Distribution_Lines_AR') ;
230: IF l_crdl_rowid_tab.LAST is not null THEN
231: IF p_archive_flag = 'Y' THEN

Line 463: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

459: ) ;
460:
461:
462: l_NoOfRecordsDel := SQL%ROWCOUNT ;
463: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
464:
465: pa_debug.debug( ' ->After delete from pa_cust_rev_dist_lines_all ') ;
466:
467:

Line 471: l_commit_size := pa_utils2.arpur_mrc_commit_size; */

467:
468: end if ;
469: else
470:
471: l_commit_size := pa_utils2.arpur_mrc_commit_size; */
472:
473: -- If the archive option is not selected then the delete will
474: -- be based on the commit size.
475:

Line 496: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

492: WHERE crdl.rowid = l_crdl_rowid_tab(l_crdl_ind);
493:
494: /*Code Changes for Bug No.2984871 start */
495: l_NoOfRecordsDel := SQL%ROWCOUNT ;
496: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
497: /*Code Changes for Bug No.2984871 end */
498:
499: pa_debug.debug( ' ->After delete from pa_cust_rev_dist_lines_all ') ;
500: /* end if ; */

Line 531: PA_UTILS2.mrc_row_count := 0;

527: p_MRC_NoOfRecordsIns => l_MC_NoOfRecordsIns,
528: p_MRC_NoOfRecordsDel => l_MC_NoOfRecordsDel
529: ) ;
530:
531: PA_UTILS2.mrc_row_count := 0;
532: END IF;
533: end if ;
534: IF ( l_fetch_complete) THEN
535: exit;

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

713: x_err_stack := x_err_stack || ' Entering PA_EventRevDistLines ' ;
714:
715: pa_debug.debug(x_err_stack);
716: IF p_archive_flag = 'Y' THEN
717: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
718: ELSE
719: l_commit_size := pa_utils2.arpur_mrc_commit_size ;
720: END IF;
721:

Line 719: l_commit_size := pa_utils2.arpur_mrc_commit_size ;

715: pa_debug.debug(x_err_stack);
716: IF p_archive_flag = 'Y' THEN
717: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
718: ELSE
719: l_commit_size := pa_utils2.arpur_mrc_commit_size ;
720: END IF;
721:
722: OPEN c_erdl_records;
723:

Line 743: /* l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ; */

739: -- before being purged. The where condition is such that
740: -- only the it inserts half the no. of records specified
741: -- in the commit size.
742:
743: /* l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ; */
744:
745: pa_debug.debug( ' ->Before insert into PA_Cust_Event_RDL_AR') ;
746: FORALL l_erdl_ind IN l_erdl_rowid_tab.FIRST .. l_erdl_rowid_tab.LAST
747: insert into PA_Cust_Event_RDL_AR

Line 958: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

954: DELETE FROM PA_CUST_EVENT_RDL_ALL ERDL
955: WHERE ERDL.rowid = l_erdl_rowid_tab(l_erdl_ind);
956:
957: l_NoOfRecordsDel := SQL%ROWCOUNT ;
958: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
959: /* end if ;
960: else
961:
962: l_commit_size := pa_utils2.arpur_mrc_commit_size;

Line 962: l_commit_size := pa_utils2.arpur_mrc_commit_size;

958: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
959: /* end if ;
960: else
961:
962: l_commit_size := pa_utils2.arpur_mrc_commit_size;
963:
964: -- If the archive option is not selected then the delete will
965: -- be based on the commit size.
966:

Line 984: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

980: delete from pa_cust_event_rdl_all erdl
981: where erdl.project_id = p_project_id
982: and rownum <= l_commit_size;
983: l_NoOfRecordsDel := SQL%ROWCOUNT ;
984: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
985: pa_debug.debug( ' ->After delete from pa_cust_event_rdl_all ') ;
986: end if ;
987:
988:

Line 1018: PA_UTILS2.mrc_row_count := 0;

1014: p_MRC_NoOfRecordsDel => l_MC_NoOfRecordsDel
1015: ) ;
1016:
1017: End If;
1018: PA_UTILS2.mrc_row_count := 0;
1019: end if ;
1020: IF (l_fetch_complete) THEN
1021: exit;
1022: END IF;

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

1188: -- before being purged. The where condition is such that
1189: -- only the it inserts half the no. of records specified
1190: -- in the commit size.
1191:
1192: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1193:
1194: pa_debug.debug( ' ->Before insert into PA_Events_AR') ;
1195:
1196: /* Funding MRC Changes : Added the column zero_revenue_amount_flag */

Line 1491: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

1487: and ev.project_id = p_project_id; -- Perf Bug 2695202
1488:
1489: /*Code Changes for Bug No.2984871 start */
1490: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1491: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
1492: /*Code Changes for Bug No.2984871 end */
1493:
1494: pa_debug.debug( ' ->After delete from pa_events ') ;
1495:

Line 1500: l_commit_size := pa_utils2.arpur_mrc_commit_size;

1496:
1497: end if ;
1498: else
1499:
1500: l_commit_size := pa_utils2.arpur_mrc_commit_size;
1501:
1502: -- If the archive option is not selected then the delete will
1503: -- be based on the commit size.
1504:

Line 1521: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

1517: where ev.project_id = p_project_id
1518: and rownum <= l_commit_size;
1519: /*Code Changes for Bug No.2984871 start */
1520: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1521: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
1522: /*Code Changes for Bug No.2984871 end */
1523:
1524: pa_debug.debug( ' ->After delete from pa_events ') ;
1525:

Line 1558: PA_UTILS2.mrc_row_count := 0;

1554: p_MRC_NoOfRecordsIns => l_MC_NoOfRecordsIns,
1555: p_MRC_NoOfRecordsDel => l_MC_NoOfRecordsDel
1556: ) ;
1557:
1558: PA_UTILS2.mrc_row_count := 0;
1559:
1560: end if ;
1561: END LOOP ;
1562:

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

1620: -- before being purged. The where condition is such that
1621: -- only the it inserts half the no. of records specified
1622: -- in the commit size.
1623:
1624: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1625:
1626: pa_debug.debug( ' ->Before insert into PA_DRAFT_REV_ITEMS_AR') ;
1627: insert into PA_DRAFT_REV_ITEMS_AR (
1628: PURGE_BATCH_ID,

Line 1739: l_commit_size := pa_utils2.arpur_mrc_commit_size;

1735:
1736: end if ;
1737: else
1738:
1739: l_commit_size := pa_utils2.arpur_mrc_commit_size;
1740:
1741: -- If the archive option is not selected then the delete will
1742: -- be based on the commit size.
1743:

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

1952: -- before being purged. The where condition is such that
1953: -- only the it inserts half the no. of records specified
1954: -- in the commit size.
1955:
1956: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1957:
1958: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_ITEMS_AR') ;
1959: insert into PA_DRAFT_INV_ITEMS_AR (
1960: PURGE_BATCH_ID,

Line 2152: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

2148: ) ;
2149:
2150: /*Code Changes for Bug No.2984871 start */
2151: l_NoOfRecordsDel := SQL%ROWCOUNT ;
2152: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
2153: /*Code Changes for Bug No.2984871 end */
2154:
2155: pa_debug.debug( ' ->After delete from pa_draft_invoice_items ') ;
2156:

Line 2160: l_commit_size := pa_utils2.arpur_mrc_commit_size;

2156:
2157: end if ;
2158: else
2159:
2160: l_commit_size := pa_utils2.arpur_mrc_commit_size;
2161:
2162: -- If the archive option is not selected then the delete will
2163: -- be based on the commit size.
2164:

Line 2182: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

2178: where dii.project_id = p_project_id
2179: and rownum <= l_commit_size;
2180: /*Code Changes for Bug No.2984871 start */
2181: l_NoOfRecordsDel := SQL%ROWCOUNT ;
2182: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
2183: /*Code Changes for Bug No.2984871 end */
2184:
2185: pa_debug.debug( ' ->After delete from pa_draft_invoice_items ') ;
2186:

Line 2218: PA_UTILS2.mrc_row_count := 0;

2214: p_MRC_NoOfRecordsIns => l_MC_NoOfRecordsIns,
2215: p_MRC_NoOfRecordsDel => l_MC_NoOfRecordsDel
2216: ) ;
2217:
2218: PA_UTILS2.mrc_row_count := 0;
2219:
2220: end if ;
2221: END LOOP ;
2222:

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

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

Line 2530: l_commit_size := pa_utils2.arpur_mrc_commit_size;

2526:
2527: end if ;
2528: else
2529:
2530: l_commit_size := pa_utils2.arpur_mrc_commit_size;
2531:
2532: -- If the archive option is not selected then the delete will
2533: -- be based on the commit size.
2534:

Line 2599: PA_UTILS2.mrc_row_count := 0;

2595: p_MRC_NoOfRecordsIns => l_MC_NoOfRecordsIns,
2596: p_MRC_NoOfRecordsDel => l_MC_NoOfRecordsDel
2597: ) ;
2598:
2599: PA_UTILS2.mrc_row_count := 0;
2600:
2601: end if ;
2602: END LOOP ;
2603:

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

2778: -- before being purged. The where condition is such that
2779: -- only the it inserts half the no. of records specified
2780: -- in the commit size.
2781:
2782: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
2783:
2784: pa_debug.debug( ' ->Before insert into PA_Draft_Revenues_AR') ;
2785: insert into PA_Draft_Revenues_AR (
2786: PURGE_BATCH_ID,

Line 2931: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

2927: ) ;
2928:
2929: /*Code Changes for Bug No.2984871 start */
2930: l_NoOfRecordsDel := SQL%ROWCOUNT ;
2931: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
2932: /*Code Changes for Bug No.2984871 end */
2933: pa_debug.debug( ' ->After delete from pa_draft_revenues_all ') ;
2934:
2935: end if ;

Line 2938: l_commit_size := pa_utils2.arpur_mrc_commit_size;

2934:
2935: end if ;
2936: else
2937:
2938: l_commit_size := pa_utils2.arpur_mrc_commit_size;
2939:
2940: -- If the archive option is not selected then the delete will
2941: -- be based on the commit size.
2942:

Line 2961: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

2957: and rownum <= l_commit_size;
2958:
2959: /*Code Changes for Bug No.2984871 start */
2960: l_NoOfRecordsDel := SQL%ROWCOUNT ;
2961: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
2962: /*Code Changes for Bug No.2984871 end */
2963: pa_debug.debug( ' ->After delete from pa_draft_revenues_all ') ;
2964: end if ;
2965:

Line 2993: PA_UTILS2.mrc_row_count := 0;

2989: p_MRC_NoOfRecordsIns => l_MC_NoOfRecordsIns,
2990: p_MRC_NoOfRecordsDel => l_MC_NoOfRecordsDel
2991: ) ;
2992:
2993: PA_UTILS2.mrc_row_count := 0;
2994:
2995: end if ;
2996: END LOOP ;
2997:

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

3056: -- before being purged. The where condition is such that
3057: -- only the it inserts half the no. of records specified
3058: -- in the commit size.
3059:
3060: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3061:
3062: pa_debug.debug( ' ->Before insert into PA_Draft_Invoices_AR') ;
3063: insert into PA_Draft_Invoices_AR (
3064: PURGE_BATCH_ID,

Line 3280: l_commit_size := pa_utils2.arpur_mrc_commit_size;

3276: l_NoOfRecordsDel := SQL%ROWCOUNT ;
3277: end if ;
3278: else
3279:
3280: l_commit_size := pa_utils2.arpur_mrc_commit_size;
3281:
3282: -- If the archive option is not selected then the delete will
3283: -- be based on the commit size.
3284:

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

3390: -- before being purged. The where condition is such that
3391: -- only the it inserts half the no. of records specified
3392: -- in the commit size.
3393:
3394: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3395:
3396: pa_debug.debug( ' ->Before insert into PA_DIST_WARNINGS_AR') ;
3397: insert into PA_DIST_WARNINGS_AR (
3398: PURGE_BATCH_ID,

Line 3492: l_commit_size := pa_utils2.arpur_mrc_commit_size;

3488:
3489: end if ;
3490: else
3491:
3492: l_commit_size := pa_utils2.arpur_mrc_commit_size;
3493:
3494: -- If the archive option is not selected then the delete will
3495: -- be based on the commit size.
3496:

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

3603: -- before being purged. The where condition is such that
3604: -- only the it inserts half the no. of records specified
3605: -- in the commit size.
3606:
3607: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3608:
3609: pa_debug.debug( ' ->Before insert into PA_Billing_Messages_AR') ;
3610: insert into PA_Billing_Messages_AR (
3611: PURGE_BATCH_ID,

Line 3731: l_commit_size := pa_utils2.arpur_mrc_commit_size;

3727:
3728: end if ;
3729: else
3730:
3731: l_commit_size := pa_utils2.arpur_mrc_commit_size;
3732:
3733: -- If the archive option is not selected then the delete will
3734: -- be based on the commit size.
3735:

Line 3845: PA_UTILS2.mrc_row_count := 0;

3841: l_old_err_stack VARCHAR2(2000);
3842:
3843: BEGIN
3844: l_old_err_stack := x_err_stack;
3845: PA_UTILS2.mrc_row_count := 0;
3846:
3847: x_err_stack := x_err_stack || ' ->Before call to purge the data ';
3848:
3849: -- Call the procedures to archive/purge data for each billing table