APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 11: ra_customer_trx_lines_all trxl

7: PRAGMA AUTONOMOUS_TRANSACTION;
8: CURSOR check_trx_type IS
9: SELECT trx_types.type
10: FROM
11: ra_customer_trx_lines_all trxl
12: , ra_customer_trx_all trx
13: , ra_cust_trx_types_all trx_types
14: WHERE trxl.customer_trx_id = trx.customer_trx_id
15: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id

Line 45: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

41: v_salesrep_id NUMBER;
42: v_line_type VARCHAR2(30);
43: v_vat_tax NUMBER;
44: v_ccid NUMBER;
45: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
46: /* commented by rallamse bug#4479131 PADDR Elimination
47: v_paddr v$session.paddr%TYPE;
48: */
49: v_customer_trx_line_id NUMBER; -- := pr_new.customer_trx_line_id; --Ramananda for File.Sql.35

Line 410: To populate Tax_rate column in RA_CUSTOMER_TRX_LINES_ALL

406: FILENAME: JA_IN_APPS_AR_LINES_INSERT_TRG.sql
407: CHANGE HISTORY:
408: S.No Date Author and Details
409: 1. 10-Jun-01 Jagdish / Subbu
410: To populate Tax_rate column in RA_CUSTOMER_TRX_LINES_ALL
411: table as receipts with discounts doesn't get saved.
412: 2. 2001/06/22 Anuradha Parthasarathy
413: Commented and Added code for better performance.
414:

Line 1286: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

1282: v_salesrep_id NUMBER;
1283: v_line_type VARCHAR2(30);
1284: v_vat_tax NUMBER;
1285: v_ccid NUMBER;
1286: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
1287: -- v_paddr v$session.paddr%TYPE;
1288: -- bug#6842749
1289: v_counter NUMBER;
1290: v_customer_trx_id NUMBER; -- := pr_old.customer_trx_id; --rpokkula for File.Sql.35

Line 1431: from ra_customer_trx_lines_all

1427: /*commented the cursor c_get_hdr_ctx for bug#8310220
1428: cursor c_get_hdr_ctx
1429: is
1430: select distinct interface_line_context
1431: from ra_customer_trx_lines_all
1432: where customer_trx_id = pr_new.customer_trx_id
1433: and customer_trx_line_id = pr_new.customer_trx_line_id --added for bug#5597146
1434: and interface_line_context is not null
1435: and rownum = 1;*/

Line 1628: from ra_customer_trx_lines_all

1624: PRAGMA AUTONOMOUS_TRANSACTION;
1625: cursor c_get_hdr_ctx
1626: is
1627: select distinct interface_line_context
1628: from ra_customer_trx_lines_all
1629: where customer_trx_id = p_customer_trx_id
1630: and customer_trx_line_id = p_customer_trx_line_id --added for bug#5597146
1631: and interface_line_context is not null
1632: and rownum = 1;

Line 1633: lv_hdr_ctx ra_customer_trx_lines_all.INTERFACE_LINE_CONTEXT%type;

1629: where customer_trx_id = p_customer_trx_id
1630: and customer_trx_line_id = p_customer_trx_line_id --added for bug#5597146
1631: and interface_line_context is not null
1632: and rownum = 1;
1633: lv_hdr_ctx ra_customer_trx_lines_all.INTERFACE_LINE_CONTEXT%type;
1634: BEGIN
1635: OPEN c_get_hdr_ctx;
1636: FETCH c_get_hdr_ctx into lv_hdr_ctx;
1637: CLOSE c_get_hdr_ctx;