[Home] [Help]
146: l_org_id NUMBER := NULL;
147: l_payment_trxn_extension_id NUMBER := NULL;
148: X_new_trx_number ra_customer_trx.trx_number%TYPE := NULL;
149: X_new_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := NULL;
150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;
151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;
153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;
154: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE := NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;
507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;
508: l_show_closed_invoices VARCHAR2(1) DEFAULT 'N';
509: l_move_deferred_tax VARCHAR2(1) DEFAULT 'Y';
510: l_link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL;
511: app_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
1192: rl.customer_trx_line_id
1193: INTO x_out_rec.cm_trx_number,
1194: x_out_rec.cm_customer_trx_line_id
1195: FROM ra_customer_trx_all rx,
1196: ra_customer_trx_lines_all rl
1197: WHERE rx.customer_trx_id = x_cm_customer_trx_id
1198: AND rl.customer_trx_id = rx.customer_trx_id;
1199: END IF;
1200: x_out_rec.cm_customer_trx_id := x_cm_customer_trx_id;
5547: invalid_value VARCHAR2(240);
5548: concat_err_msg VARCHAR2(2000);
5549: l_return_status VARCHAR2(1);
5550: l_cust_trx_name ra_cust_trx_types.NAME%TYPE;
5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;
5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;
5641:
5642: BEGIN
5643: SELECT customer_trx_line_id
5644: INTO l_deposit_trx_line_id
5645: FROM ra_customer_trx_lines_all
5646: WHERE customer_trx_id = p_in_rec.deposit_trx_id
5647: AND org_id = p_in_rec.org_id
5648: AND ROWNUM =1;
5649: EXCEPTION
5652: RETURN;
5653: END;
5654:
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');
5867: SELECT rc.CUSTOMER_TRX_ID,
5868: rc.TRX_NUMBER
5869: INTO l_customer_trx_id,
5870: l_trx_number
5871: FROM ra_customer_trx_all rc, ra_customer_trx_lines_all rcl
5872: WHERE rc.CUSTOMER_TRX_ID = rcl.CUSTOMER_TRX_ID
5873: AND rcl.INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5874: AND rcl.INTERFACE_LINE_ATTRIBUTE7 = to_char(l_emd_transactions_info.emd_trx_group_id)
5875: AND rcl.INTERFACE_LINE_ATTRIBUTE8 = to_char(l_emd_transactions_info.emd_transaction_id)