DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES_S

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

3463:
3464: FOR rec in LINES_INFO_CUR(v_parent_header_id)
3465: LOOP
3466:
3467: -- SELECT ra_customer_trx_lines_s.nextval INTO v_customer_trx_line_id FROM Dual;
3468:
3469: INSERT INTO JAI_AR_TRX_LINES
3470: (customer_trx_line_id, line_number,
3471: customer_trx_id, description,

Line 3480: VALUES(ra_customer_trx_lines_s.nextval,

3476: creation_date, created_by,
3477: last_update_date,last_updated_by,
3478: last_update_login,
3479: service_type_code) --added by csahoo for Bug#5879769
3480: VALUES(ra_customer_trx_lines_s.nextval,
3481: --v_customer_trx_line_id, /* Commented by Ramananda as a part of removal of SQL LITERALs */
3482: rec.line_number,
3483: v_header_id,rec.description,
3484: rec.inventory_item_id, rec.unit_code,

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

3503: tax_id, tax_rate, qty_rate, uom,
3504: tax_amount, base_tax_amount, func_tax_amount,
3505: creation_date, created_by, last_update_date,
3506: last_updated_by, last_update_login)
3507: VALUES( ra_customer_trx_lines_s.nextval, v_customer_trx_line_id, rec1.tax_line_no,
3508: rec1.precedence_1, rec1.precedence_2, rec1.precedence_3, rec1.precedence_4, rec1.precedence_5,
3509: rec1.precedence_6, rec1.precedence_7, rec1.precedence_8, rec1.precedence_9, rec1.precedence_10, -- Date 06/12/2006 Bug 5228046 added by SACSETHI
3510: rec1.tax_id, rec1.tax_rate, rec1.qty_rate, rec1.uom,
3511: rec1.tax_amount, rec1.base_tax_amount, rec1.func_tax_amount,