APPS.AR_PURGE dependencies on AR_ARCHIVE_CONTROL_DETAIL

Line 392: UPDATE ar_archive_control_detail

388: BEGIN
389:
390: FOR I IN 1..l_control_detail_array.last
391: LOOP
392: UPDATE ar_archive_control_detail
393: SET invoices_cnt = invoices_cnt +
394: l_control_detail_array(I).invoices_cnt ,
395: credit_memos_cnt = credit_memos_cnt +
396: l_control_detail_array(I).credit_memos_cnt,

Line 448: INSERT INTO ar_archive_control_detail

444: IF SQL%ROWCOUNT = 0
445: THEN
446: BEGIN
447:
448: INSERT INTO ar_archive_control_detail
449: ( archive_id,
450: period_name,
451: invoices_cnt,
452: credit_memos_cnt,

Line 511: print( 1, ' ...Failed while inserting into AR_ARCHIVE_CONTROL_DETAIL');

507: l_control_detail_array(I).deposits_cnt
508: ) ;
509: EXCEPTION
510: WHEN OTHERS THEN
511: print( 1, ' ...Failed while inserting into AR_ARCHIVE_CONTROL_DETAIL');
512: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
513: RAISE ;
514: END ;
515: END IF ;

Line 522: print( 1, ' ...Failed while ins/upd into AR_ARCHIVE_CONTROL_DETAIL');

518: RETURN(TRUE) ;
519:
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: print( 1, ' ...Failed while ins/upd into AR_ARCHIVE_CONTROL_DETAIL');
523: RETURN(FALSE);
524: WHEN OTHERS THEN
525: print( 1, ' ...Failed while ins/upd into AR_ARCHIVE_CONTROL_DETAIL');
526: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;

Line 525: print( 1, ' ...Failed while ins/upd into AR_ARCHIVE_CONTROL_DETAIL');

521: WHEN NO_DATA_FOUND THEN
522: print( 1, ' ...Failed while ins/upd into AR_ARCHIVE_CONTROL_DETAIL');
523: RETURN(FALSE);
524: WHEN OTHERS THEN
525: print( 1, ' ...Failed while ins/upd into AR_ARCHIVE_CONTROL_DETAIL');
526: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
527: RAISE ;
528: END ;
529: ---

Line 4326: -- To update ar_archive_control_detail with the

4322: --
4323: p_running_total := p_running_total - l_receipt_amount
4324: - l_discount_amount ;
4325:
4326: -- To update ar_archive_control_detail with the
4327: -- cash receipt amount. This rec. appln. record
4328: -- will not exist when archive procedure is
4329: -- called recursively.
4330: