APPS.JAI_AR_TAX_LINES_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 51: , ra_customer_trx_all trx

47: CURSOR check_trx_type IS
48: SELECT trx_types.type
49: FROM
50: ra_customer_trx_lines_all trxl
51: , ra_customer_trx_all trx
52: , ra_cust_trx_types_all trx_types
53: WHERE trxl.customer_trx_id = trx.customer_trx_id
54: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
55: AND trxl.customer_trx_line_id = pn_customer_trx_line_id;

Line 96: v_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE;

92: v_vat_tax NUMBER;
93: v_ccid NUMBER;
94: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
95: v_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
96: v_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE;
97:
98: v_created_from VARCHAR2(30);
99: c_from_currency_code VARCHAR2(15);
100: c_conversion_type VARCHAR2(30);

Line 111: v_order_type ra_customer_trx_all.interface_header_attribute2%type;

107: v_location_id NUMBER;
108: v_batch_source_id NUMBER;
109: v_register_code VARCHAR2(50);
110: v_order_number VARCHAR2(30);
111: v_order_type ra_customer_trx_all.interface_header_attribute2%type;
112: v_org_id NUMBER(15);
113: v_tax_exists NUMBER := 0;
114:
115: ln_inv_curr_precision NUMBER;

Line 116: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type;

112: v_org_id NUMBER(15);
113: v_tax_exists NUMBER := 0;
114:
115: ln_inv_curr_precision NUMBER;
116: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type;
117:
118: ld_st_accrual_date DATE;
119: ld_trx_date DATE;
120:

Line 127: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

123: b.org_id,
124: b.bill_to_customer_id,
125: NVL(b.bill_to_site_use_id, 0),
126: b.trx_date
127: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
128: Where a.cust_trx_type_id = b.cust_trx_type_id
129: And b.customer_trx_id = v_customer_trx_id
130: And NVL(a.org_id, 0) = NVL(b.org_id, 0);
131:

Line 167: FROM RA_CUSTOMER_TRX_ALL

163: exchange_rate_type,
164: exchange_date,
165: exchange_rate,
166: interface_header_context
167: FROM RA_CUSTOMER_TRX_ALL
168: WHERE customer_trx_id = v_customer_trx_id;
169:
170: CURSOR ORG_CUR IS
171: SELECT ORG_ID

Line 172: FROM RA_CUSTOMER_TRX_ALL

168: WHERE customer_trx_id = v_customer_trx_id;
169:
170: CURSOR ORG_CUR IS
171: SELECT ORG_ID
172: FROM RA_CUSTOMER_TRX_ALL
173: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;
174:
175: lv_tax_regime_code zx_rates_b.tax_regime_code%type;
176: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;

Line 188: FROM ra_customer_trx_all

184: CURSOR CREATED_FROM_CUR IS
185: SELECT created_from,
186: interface_header_attribute1,
187: interface_header_attribute2
188: FROM ra_customer_trx_all
189: WHERE customer_trx_id = v_customer_trx_id;
190:
191: CURSOR SO_AR_HDR_INFO IS
192: SELECT organization_id, location_id, batch_source_id

Line 255: FROM ra_customer_trx_all

251: AND ott.NAME = p_order_type;
252:
253: CURSOR trx_num(v_cust_trx_id NUMBER) IS
254: SELECT trx_number
255: FROM ra_customer_trx_all
256: WHERE customer_trx_id = v_cust_trx_id;
257:
258: CURSOR cur_chk_rgm(cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
259: SELECT regime_id, regime_code

Line 271: v_trx_num ra_customer_trx_all.trx_number%TYPE;

267: lv_error_flag VARCHAR2(2);
268: lv_error_message VARCHAR2(4000);
269:
270: v_err_mesg VARCHAR2(250);
271: v_trx_num ra_customer_trx_all.trx_number%TYPE;
272:
273: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
274:
275: CURSOR check_rma_credit_cur(pn_order_number NUMBER,

Line 823: FROM ra_customer_trx_all

819: if (pr_new.tax_category_id is NULL and l_tcs_sur_line_num = 0) then
820: if (c_conversion_date is NULL) then
821: SELECT trx_date
822: INTO c_conversion_date
823: FROM ra_customer_trx_all
824: WHERE customer_trx_id = v_customer_trx_id;
825: end if;
826:
827: OPEN transaction_type_cur;

Line 978: FROM ra_customer_trx_all

974: lv_debug_info VARCHAR2(4000);
975:
976: CURSOR CREATED_FROM_CUR IS
977: SELECT created_from
978: FROM ra_customer_trx_all
979: WHERE customer_trx_id = ln_customer_trx_id;
980:
981: lv_created_from VARCHAR2(30);
982: ln_tax_exists NUMBER;