APPS.JAI_AR_TAX_PROCESSING_PKG dependencies on JAI_AR_TRXS

Line 34: t_jai_ar_trx_rec JAI_AR_TRXS%ROWTYPE;

30: lb_jai_exists BOOLEAN;
31: lv_action VARCHAR2(20);
32: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;
33: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
34: t_jai_ar_trx_rec JAI_AR_TRXS%ROWTYPE;
35: t_jai_ar_trx_lines_rec JAI_AR_TRX_LINES%ROWTYPE;
36: lv_return_message VARCHAR2(2000);
37: lv_return_code VARCHAR2(100);
38: ln_trx_line_id NUMBER;

Line 52: SELECT * FROM JAI_AR_TRXS WHERE CUSTOMER_TRX_ID = p_customer_trx_id;

48: FROM RA_CUSTOMER_TRX_LINES_ALL
49: WHERE CUSTOMER_TRX_LINE_ID = p_customer_trx_line_id;
50:
51: CURSOR c_jai_ar_trx(p_customer_trx_id NUMBER) IS
52: SELECT * FROM JAI_AR_TRXS WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
53:
54: CURSOR c_jai_ar_trx_lines(p_customer_trx_line_id NUMBER) IS
55: SELECT *
56: FROM JAI_AR_TRX_LINES

Line 66: FROM jai_ar_trxs

62: WHERE ja.legal_entity_id = t_ra_customer_trx_rec.org_id
63: AND sysdate between ja.start_date and ja.end_date;
64: CURSOR organization_id_check(p_customer_trx_id number) IS
65: SELECT NVL(organization_id, -1) organization_id
66: FROM jai_ar_trxs
67: WHERE customer_trx_id = p_customer_trx_id;
68:
69: v_organization_id NUMBER;
70: lv_inclu_tax_flag VARCHAR2(3);

Line 73: lv_vat_inv_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;

69: v_organization_id NUMBER;
70: lv_inclu_tax_flag VARCHAR2(3);
71:
72: lv_excise_inv_no JAI_AR_TRX_LINES.excise_invoice_no%Type;
73: lv_vat_inv_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
74:
75: CURSOR get_excise_inv_no_cur(pn_customer_trx_id NUMBER) IS
76: SELECT l.excise_invoice_no
77: FROM JAI_AR_TRX_LINES L

Line 82: FROM JAI_AR_TRXS h

78: WHERE l.customer_trx_id = pn_customer_trx_id;
79:
80: CURSOR get_vat_inv_no_cur(pn_customer_trx_id NUMBER) IS
81: SELECT h.vat_invoice_no
82: FROM JAI_AR_TRXS h
83: WHERE h.customer_trx_id = pn_customer_trx_id;
84:
85: BEGIN
86: IF G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL THEN

Line 300: UPDATE jai_ar_trxs

296: END IF;
297: END IF;
298:
299: IF NVL(t_jai_ar_trx_rec.COMPLETE_FLAG, 'N') <> NVL(t_ra_customer_trx_rec.COMPLETE_FLAG, 'N') THEN
300: UPDATE jai_ar_trxs
301: SET complete_flag = t_ra_customer_trx_rec.complete_flag
302: WHERE customer_trx_id = p_transaction_rec.trx_id;
303: END IF;
304:

Line 315: JAI_AR_TRX_HEADERS_PKG.POPULATE_JAI_AR_TRXS(pr_new => t_ra_customer_trx_rec,

311: OPEN c_ra_customer_trx(p_event_class_rec.trx_id);
312: FETCH c_ra_customer_trx
313: INTO t_ra_customer_trx_rec;
314: CLOSE c_ra_customer_trx;
315: JAI_AR_TRX_HEADERS_PKG.POPULATE_JAI_AR_TRXS(pr_new => t_ra_customer_trx_rec,
316: pv_action => lv_action,
317: pv_return_code => lv_return_code,
318: pv_return_message => lv_return_message);
319: IF lv_return_code <> jai_constants.successful THEN