DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_LLCA_TRX_ERRORS_GT

Line 3133: select count(1) into l_count_err_gt from ar_llca_trx_errors_gt

3129: END IF;
3130: End Loop;
3131:
3132: -- Check for overapply
3133: select count(1) into l_count_err_gt from ar_llca_trx_errors_gt
3134: where customer_trx_id = p_customer_trx_id;
3135:
3136: IF l_count_err_gt <> 0 AND p_llca_type = 'L'
3137: THEN

Line 8396: delete from ar_llca_trx_errors_gt

8392: -- Clean the GT Table first.
8393: delete from ar_llca_trx_lines_gt
8394: where customer_trx_id = p_customer_trx_id;
8395:
8396: delete from ar_llca_trx_errors_gt
8397: where customer_trx_id = p_customer_trx_id;
8398:
8399: If p_llca_type = 'S'
8400: Then

Line 8534: Insert into ar_llca_trx_errors_gt

8530: IF PG_DEBUG in ('Y', 'C') THEN
8531: arp_util.debug('Populate_errors_gt ()+ ');
8532: END IF;
8533:
8534: Insert into ar_llca_trx_errors_gt
8535: ( customer_trx_id,
8536: customer_trx_line_id,
8537: error_message,
8538: invalid_value