DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES_S

Line 4636: -- SELECT ra_customer_trx_lines_s.nextval INTO v_customer_trx_line_id FROM Dual;

4632:
4633: FOR rec in LINES_INFO_CUR(v_parent_header_id)
4634: LOOP
4635:
4636: -- SELECT ra_customer_trx_lines_s.nextval INTO v_customer_trx_line_id FROM Dual;
4637:
4638: INSERT INTO JAI_AR_TRX_LINES
4639: (customer_trx_line_id, line_number,
4640: customer_trx_id, description,

Line 4649: VALUES(ra_customer_trx_lines_s.nextval,

4645: creation_date, created_by,
4646: last_update_date,last_updated_by,
4647: last_update_login,
4648: service_type_code) --added by csahoo for Bug#5879769
4649: VALUES(ra_customer_trx_lines_s.nextval,
4650: --v_customer_trx_line_id, /* Commented by Ramananda as a part of removal of SQL LITERALs */
4651: rec.line_number,
4652: v_header_id,rec.description,
4653: rec.inventory_item_id, rec.unit_code,

Line 4676: VALUES( ra_customer_trx_lines_s.nextval, v_customer_trx_line_id, rec1.tax_line_no,

4672: tax_id, tax_rate, qty_rate, uom,
4673: tax_amount, base_tax_amount, func_tax_amount,
4674: creation_date, created_by, last_update_date,
4675: last_updated_by, last_update_login)
4676: VALUES( ra_customer_trx_lines_s.nextval, v_customer_trx_line_id, rec1.tax_line_no,
4677: rec1.precedence_1, rec1.precedence_2, rec1.precedence_3, rec1.precedence_4, rec1.precedence_5,
4678: rec1.precedence_6, rec1.precedence_7, rec1.precedence_8, rec1.precedence_9, rec1.precedence_10, -- Date 06/12/2006 Bug 5228046 added by SACSETHI
4679: rec1.tax_id, rec1.tax_rate, rec1.qty_rate, rec1.uom,
4680: rec1.tax_amount, rec1.base_tax_amount, rec1.func_tax_amount,