APPS.AR_PURGE dependencies on AR_ARCHIVE_DETAIL

Line 969: select /* index(aad ar_archive_details_n1) */ 'already purged'

965: and ra.applied_customer_trx_id = ct.customer_trx_id
966: and ra.cash_receipt_id = ra1.cash_Receipt_id /*bug 6058203*/
967: -- bug3567865 Don't insert duplicate cash record.
968: and not exists (
969: select /* index(aad ar_archive_details_n1) */ 'already purged'
970: from ar_archive_detail aad
971: where aad.transaction_id = cr.cash_receipt_id
972: and aad.transaction_class = 'CASH' )
973: AND cp_archive_level not in ('N','H');

Line 970: from ar_archive_detail aad

966: and ra.cash_receipt_id = ra1.cash_Receipt_id /*bug 6058203*/
967: -- bug3567865 Don't insert duplicate cash record.
968: and not exists (
969: select /* index(aad ar_archive_details_n1) */ 'already purged'
970: from ar_archive_detail aad
971: where aad.transaction_id = cr.cash_receipt_id
972: and aad.transaction_class = 'CASH' )
973: AND cp_archive_level not in ('N','H');
974:

Line 1295: INSERT INTO ar_archive_detail

1291: IF select_details.ccid4 > 0 THEN
1292: l_account_combination4 := get_ccid(select_details.ccid4) ;
1293: END IF ;
1294: --
1295: INSERT INTO ar_archive_detail
1296: ( archive_id,
1297: transaction_class,
1298: transaction_type,
1299: transaction_id,

Line 3084: from ar_archive_detail aad

3080: and ra.applied_customer_trx_id = cp_customer_trx_id
3081: -- bug3567865 Don't insert duplicate cash record.
3082: and not exists (
3083: select 'already purged'
3084: from ar_archive_detail aad
3085: where aad.transaction_id = cr.cash_receipt_id
3086: and aad.transaction_class = 'CASH' )
3087: UNION ALL /* Bug 5105156 - fix 5044763 */
3088: ---------------------------------------------------------------------

Line 3219: from ar_archive_detail aad

3215: AND ra1.cash_Receipt_id = ra.cash_receipt_id )
3216: -- bug3567865 Don't insert duplicate cash record.
3217: and not exists (
3218: select 'already purged'
3219: from ar_archive_detail aad
3220: where aad.transaction_id = cr.cash_receipt_id
3221: and aad.transaction_class = 'CASH' )
3222: UNION ALL /* Bug 5105156 - fix 5044763 */
3223: ---------------------------------------------------------------------

Line 3484: from ar_archive_detail aad

3480: cp_customer_trx_id
3481: AND ra1.cash_Receipt_id = ra.cash_receipt_id )
3482: and not exists (
3483: select 'already purged'
3484: from ar_archive_detail aad
3485: where aad.transaction_id = cr.cash_receipt_id
3486: and aad.transaction_class = 'CASH' );
3487:
3488: /* Bug 5105156 - fix 5073245 ends */

Line 3529: INSERT INTO ar_archive_detail

3525: IF select_detail.ccid4 > 0 THEN
3526: l_account_combination4 := get_ccid(select_detail.ccid4) ;
3527: END IF ;
3528: --
3529: INSERT INTO ar_archive_detail
3530: ( archive_id,
3531: transaction_class,
3532: transaction_type,
3533: transaction_id,

Line 3752: print( 1, ' ...Failed while inserting into AR_ARCHIVE_DETAIL');

3748: RETURN TRUE ;
3749:
3750: EXCEPTION
3751: WHEN OTHERS THEN
3752: print( 1, ' ...Failed while inserting into AR_ARCHIVE_DETAIL');
3753: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
3754: RAISE ;
3755: END;
3756: --

Line 3783: print( 0, ' ...Failed while inserting into AR_ARCHIVE_DETAIL ');

3779: IF archive_detail( p_customer_trx_id ,
3780: p_archive_level ,
3781: p_archive_id ) = FALSE
3782: THEN
3783: print( 0, ' ...Failed while inserting into AR_ARCHIVE_DETAIL ');
3784: p_archive_status := FALSE ;
3785: ELSE
3786: p_archive_status := TRUE ;
3787: END IF ;