APPS.JAI_AR_TRX_HEADERS_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 101: FROM RA_CUST_TRX_TYPES_ALL

97: WHERE trx_number = v_parent_trx_number;
98:
99: CURSOR transaction_type_cur IS
100: SELECT type
101: FROM RA_CUST_TRX_TYPES_ALL
102: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
103: AND NVL(org_id, 0) = NVL(pr_new.org_id, 0);
104:
105: CURSOR localization_header_info IS

Line 795: From RA_CUST_TRX_TYPES_ALL

791: v_ref_line_id varchar2(30);
792:
793: Cursor transaction_type_cur IS
794: Select type
795: From RA_CUST_TRX_TYPES_ALL
796: Where cust_trx_type_id = pr_new.cust_trx_type_id
797: And NVL(org_id, 0) = NVL(pr_new.org_id, 0);
798:
799: v_currency_code gl_sets_of_books.currency_code%type;

Line 994: From RA_CUST_TRX_TYPES_ALL a

990: v_trans_type Varchar2(30);
991:
992: Cursor transaction_type_cur IS
993: Select a.type
994: From RA_CUST_TRX_TYPES_ALL a
995: Where a.cust_trx_type_id = pr_new.cust_trx_type_id
996: And a.org_id = v_org_id;
997:
998: Cursor Ar_Line_Cur IS

Line 1403: FROM RA_CUST_TRX_TYPES_ALL

1399: and org_id = pr_new.org_id);
1400:
1401: CURSOR transaction_type_cur IS
1402: SELECT TYPE
1403: FROM RA_CUST_TRX_TYPES_ALL
1404: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
1405: AND NVL(org_id, 0) = NVL(pr_new.org_id, 0);
1406:
1407: Procedure Generate_Tax_Invoice_no(p_organization_id Number,

Line 1571: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;

1567: lv_api_name CONSTANT VARCHAR2(100) := 'VAT_ACCOUNTING_FOR_CM';
1568: lv_debug_info VARCHAR2(4000);
1569: v_organization_id NUMBER;
1570: v_loc_id NUMBER;
1571: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
1572: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1573: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1574: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1575: lv_process_flag VARCHAR2(10);

Line 1587: FROM ra_cust_trx_types_all

1583: WHERE customer_trx_id = pr_new.customer_trx_id;
1584:
1585: CURSOR transaction_type_cur IS
1586: SELECT type
1587: FROM ra_cust_trx_types_all
1588: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
1589: AND NVL(org_id, 0) = NVL(pr_new.org_id, 0);
1590:
1591: CURSOR cur_vat_taxes_exist IS

Line 1992: FROM RA_CUST_TRX_TYPES_ALL

1988: AND location_id = p_loc_id;
1989:
1990: CURSOR transaction_type_cur IS
1991: SELECT TYPE
1992: FROM RA_CUST_TRX_TYPES_ALL
1993: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
1994: AND (org_id = pr_new.org_id OR
1995: (org_id is null and pr_new.org_id is null));
1996: CURSOR Batch_Source_Name_Cur IS