APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_INTERFACE_LINES_ALL

Line 5519: --Description : inserts the data into ra_interface_lines_all and

5515:
5516: -----------------------------------------------------------------------
5517: --Start of Comments
5518: --Name: insert_and_call_autoinvoice
5519: --Description : inserts the data into ra_interface_lines_all and
5520: -- submits auto invoice concurrent request
5521: --Pre-reqs:
5522: --Parameters:
5523: --IN: p_in_rec

Line 5659: --Inserting into ra_interface_lines_all before calling auto invoice program

5655: /* Bug 8784319 */
5656: SELECT ra_customer_trx_lines_s.NEXTVAL INTO l_interface_line_id FROM DUAL;
5657:
5658: print_log('l_interface_line_id'||l_interface_line_id);
5659: --Inserting into ra_interface_lines_all before calling auto invoice program
5660: print_log('Before inserting records into ra_interface_lines');
5661:
5662: /* Inserting
5663: ORIG_SYSTEM_BILL_CONTACT_ID,

Line 5675: INSERT INTO ra_interface_lines_all

5671: FROM ra_terms_vl rt
5672: WHERE rt.term_id = p_in_rec.payment_term_id;
5673:
5674: BEGIN
5675: INSERT INTO ra_interface_lines_all
5676: ( INTERFACE_LINE_ID,
5677: DESCRIPTION,
5678: BATCH_SOURCE_NAME,
5679: LINE_TYPE,

Line 5819: DELETE FROM ra_interface_lines_all

5815: FND_MSG_PUB.add;
5816: x_return_status := fnd_api.g_ret_sts_error;
5817:
5818: IF (p_in_rec.emd_trx_group_id IS NOT NULL) THEN
5819: DELETE FROM ra_interface_lines_all
5820: WHERE INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5821: AND INTERFACE_LINE_ATTRIBUTE7 = to_char(p_in_rec.emd_trx_group_id);
5822: COMMIT;
5823: END IF;

Line 5850: DELETE FROM ra_interface_lines_all

5846: FND_MESSAGE.set_token('REQUEST_ID',l_conc_req_id);
5847: FND_MSG_PUB.add;
5848: x_return_status := fnd_api.g_ret_sts_error;
5849: IF (p_in_rec.emd_trx_group_id IS NOT NULL) THEN
5850: DELETE FROM ra_interface_lines_all
5851: WHERE INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5852: AND INTERFACE_LINE_ATTRIBUTE7 = to_char(p_in_rec.emd_trx_group_id);
5853: END IF;
5854: COMMIT;

Line 5901: FROM ra_interface_lines_all ril

5897: BEGIN
5898: /* Forfeit Error Bug */
5899: SELECT ril.interface_line_id
5900: INTO l_interface_line_id
5901: FROM ra_interface_lines_all ril
5902: WHERE ril.INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5903: AND ril.INTERFACE_LINE_ATTRIBUTE7 = to_char(l_emd_transactions_info.emd_trx_group_id)
5904: AND ril.INTERFACE_LINE_ATTRIBUTE8 = to_char(l_emd_transactions_info.emd_transaction_id);
5905:

Line 5933: DELETE FROM ra_interface_lines_all

5929: WHERE emd_transaction_id = l_emd_transactions_info.emd_transaction_id
5930: AND emd_transaction_group_id = l_emd_transactions_info.emd_trx_group_id
5931: AND auction_header_id = l_emd_transactions_info.auction_header_id;
5932:
5933: DELETE FROM ra_interface_lines_all
5934: WHERE interface_line_id =l_interface_line_id;
5935:
5936: DELETE FROM ra_interface_errors_all
5937: WHERE interface_line_id =l_interface_line_id;

Line 5951: DELETE FROM ra_interface_lines_all

5947:
5948: END IF;
5949: ELSE
5950: IF (p_in_rec.emd_trx_group_id IS NOT NULL) THEN
5951: DELETE FROM ra_interface_lines_all
5952: WHERE INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5953: AND INTERFACE_LINE_ATTRIBUTE7 = to_char(p_in_rec.emd_trx_group_id);
5954: COMMIT;
5955: END IF;