APPS.JAI_TAX_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 753: cursor c_get_ledger_id_ar(cp_trx_id ra_customer_trx_all.customer_trx_id%TYPE) is

749: select set_of_books_id
750: from ap_invoices_all
751: where invoice_id = cp_trx_id;
752:
753: cursor c_get_ledger_id_ar(cp_trx_id ra_customer_trx_all.customer_trx_id%TYPE) is
754: select set_of_books_id
755: from ra_customer_trx_all
756: where customer_trx_id = cp_trx_id;
757:

Line 755: from ra_customer_trx_all

751: where invoice_id = cp_trx_id;
752:
753: cursor c_get_ledger_id_ar(cp_trx_id ra_customer_trx_all.customer_trx_id%TYPE) is
754: select set_of_books_id
755: from ra_customer_trx_all
756: where customer_trx_id = cp_trx_id;
757:
758: --added by zhiwei.xin for OM begin
759: cursor c_get_om_org_id(cp_trx_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)

Line 883: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;

879: )
880: is
881: lb_jai_exists BOOLEAN;
882: lv_action VARCHAR2(20);
883: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;
884: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
885: lv_return_message VARCHAR2(2000);
886: lv_return_code VARCHAR2(100);
887: ln_trx_line_id NUMBER;

Line 894: FROM RA_CUSTOMER_TRX_ALL

890: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_DOCUMENT_WITH_TAX()';
891: CURSOR c_ra_customer_trx(p_customer_trx_id NUMBER)
892: IS
893: SELECT *
894: FROM RA_CUSTOMER_TRX_ALL
895: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
896:
897: CURSOR c_ra_customer_trx_lines(p_customer_trx_line_id NUMBER)
898: IS

Line 1129: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;

1125: IS
1126: lb_jai_exists BOOLEAN;
1127: lv_action VARCHAR2(20);
1128: t_jai_ar_trx_rec JAI_AR_TRXS%ROWTYPE;
1129: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;
1130: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
1131: lv_return_message VARCHAR2(2000);
1132: lv_return_code VARCHAR2(100);
1133: ln_trx_line_id NUMBER;

Line 1141: FROM RA_CUSTOMER_TRX_ALL

1137:
1138: CURSOR c_ra_customer_trx(p_customer_trx_id NUMBER)
1139: IS
1140: SELECT *
1141: FROM RA_CUSTOMER_TRX_ALL
1142: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
1143:
1144: CURSOR c_jai_ar_trx(p_customer_trx_id NUMBER)
1145: IS