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_CUST_REV_DIST_LINES_ALL

Line 161: -- Function : Archive and Purge data for table PA_CUST_REV_DIST_LINES_ALL

157: -- Start of comments
158: -- API name : PA_CUSTREVDISTLINES
159: -- Type : Private
160: -- Pre-reqs : None
161: -- Function : Archive and Purge data for table PA_CUST_REV_DIST_LINES_ALL
162: -- Parameters : See common list above
163: -- End of comments
164: procedure PA_CUSTREVDISTLINES
165: ( p_purge_batch_id IN NUMBER,

Line 189: select crdl.rowid from pa_cust_rev_dist_lines_all crdl

185: l_fetch_complete BOOLEAN := FALSE;
186: l_crdl_ind NUMBER;
187:
188: cursor c_crdl_records is
189: select crdl.rowid from pa_cust_rev_dist_lines_all crdl
190: where crdl.project_id = p_project_id;
191:
192: begin
193:

Line 409: from pa_cust_rev_dist_lines_all crdl

405: RETN_DRAFT_INVOICE_LINE_NUM,
406: RETAINED_AMOUNT,
407: RETENTION_RULE_ID,
408: RATE_DISC_REASON_CODE
409: from pa_cust_rev_dist_lines_all crdl
410: where crdl.rowid = l_crdl_rowid_tab(l_crdl_ind);
411: /*where (
412: project_id = p_project_id
413: and rownum <= l_commit_size

Line 441: pa_debug.debug( ' ->Before delete from pa_cust_rev_dist_lines_all ') ;

437: x_err_stage => x_err_stage
438: ) ;
439:
440: end if;
441: pa_debug.debug( ' ->Before delete from pa_cust_rev_dist_lines_all ') ;
442: /* commented and modified as below for performance reasons. Archive Purge 11.5
443: delete from pa_cust_rev_dist_lines_all crdl
444: where (crdl.rowid) in
445: ( select crdl1.rowid

Line 443: delete from pa_cust_rev_dist_lines_all crdl

439:
440: end if;
441: pa_debug.debug( ' ->Before delete from pa_cust_rev_dist_lines_all ') ;
442: /* commented and modified as below for performance reasons. Archive Purge 11.5
443: delete from pa_cust_rev_dist_lines_all crdl
444: where (crdl.rowid) in
445: ( select crdl1.rowid
446: from pa_cust_rev_dist_lines_all crdl1,
447: PA_CUST_RDL_AR crdl2

Line 446: from pa_cust_rev_dist_lines_all crdl1,

442: /* commented and modified as below for performance reasons. Archive Purge 11.5
443: delete from pa_cust_rev_dist_lines_all crdl
444: where (crdl.rowid) in
445: ( select crdl1.rowid
446: from pa_cust_rev_dist_lines_all crdl1,
447: PA_CUST_RDL_AR crdl2
448: where crdl2.expenditure_item_id = crdl1.expenditure_item_id
449: and crdl2.line_num = crdl1.line_num
450: and crdl2.purge_project_id = p_project_id

Line 454: /* delete from pa_cust_rev_dist_lines_all crdl

450: and crdl2.purge_project_id = p_project_id
451: ) ;
452: */
453:
454: /* delete from pa_cust_rev_dist_lines_all crdl
455: where (crdl.expenditure_item_id, crdl.line_num) in
456: ( select crdl2.expenditure_item_id, crdl2.line_num
457: from PA_CUST_RDL_AR crdl2
458: where crdl2.purge_project_id = p_project_id

Line 465: pa_debug.debug( ' ->After delete from pa_cust_rev_dist_lines_all ') ;

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:
468: end if ;
469: else

Line 477: pa_debug.debug( ' ->Before delete from pa_cust_rev_dist_lines_all ') ;

473: -- If the archive option is not selected then the delete will
474: -- be based on the commit size.
475:
476:
477: pa_debug.debug( ' ->Before delete from pa_cust_rev_dist_lines_all ') ;
478: /* commented and modified as below for performance reasons. Archive Purge 11.5
479: delete from pa_cust_rev_dist_lines_all crdl
480: where (crdl.rowid) in
481: ( select crdl1.rowid

Line 479: delete from pa_cust_rev_dist_lines_all crdl

475:
476:
477: pa_debug.debug( ' ->Before delete from pa_cust_rev_dist_lines_all ') ;
478: /* commented and modified as below for performance reasons. Archive Purge 11.5
479: delete from pa_cust_rev_dist_lines_all crdl
480: where (crdl.rowid) in
481: ( select crdl1.rowid
482: from pa_cust_rev_dist_lines_all crdl1
483: where crdl1.project_id = p_project_id

Line 482: from pa_cust_rev_dist_lines_all crdl1

478: /* commented and modified as below for performance reasons. Archive Purge 11.5
479: delete from pa_cust_rev_dist_lines_all crdl
480: where (crdl.rowid) in
481: ( select crdl1.rowid
482: from pa_cust_rev_dist_lines_all crdl1
483: where crdl1.project_id = p_project_id
484: and rownum <= l_commit_size
485: ) ;
486: */

Line 487: /* delete from pa_cust_rev_dist_lines_all crdl

483: where crdl1.project_id = p_project_id
484: and rownum <= l_commit_size
485: ) ;
486: */
487: /* delete from pa_cust_rev_dist_lines_all crdl
488: where crdl.project_id = p_project_id
489: and rownum <= l_commit_size; */
490: FORALL l_crdl_ind IN l_crdl_rowid_tab.FIRST ..l_crdl_rowid_tab.LAST
491: DELETE FROM pa_cust_rev_dist_lines_all crdl

Line 491: DELETE FROM pa_cust_rev_dist_lines_all crdl

487: /* delete from pa_cust_rev_dist_lines_all crdl
488: where crdl.project_id = p_project_id
489: and rownum <= l_commit_size; */
490: FORALL l_crdl_ind IN l_crdl_rowid_tab.FIRST ..l_crdl_rowid_tab.LAST
491: DELETE FROM pa_cust_rev_dist_lines_all crdl
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 ;

Line 499: pa_debug.debug( ' ->After delete from pa_cust_rev_dist_lines_all ') ;

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 ; */
501:
502: /* if SQL%ROWCOUNT = 0 then
503: -- Once the SqlCount becomes 0, which means that there are

Line 520: p_table_name => 'PA_CUST_REV_DIST_LINES_ALL',

516: IF l_NoOfRecordsDel > 0 Then
517: pa_purge.CommitProcess
518: (p_purge_batch_id => p_purge_batch_id,
519: p_project_id => p_project_id,
520: p_table_name => 'PA_CUST_REV_DIST_LINES_ALL',
521: p_NoOfRecordsIns => l_NoOfRecordsIns,
522: p_NoOfRecordsDel => l_NoOfRecordsDel,
523: x_err_code => x_err_code,
524: x_err_stack => x_err_stack,