eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OPEN_API_PKG dependencies on JAI_RGM_DEFINITIONS

Line 2113: FROM jai_rgm_definitions jrd

2109: FROM jai_rgm_registrations jrr
2110: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2111: AND jrr.regime_id IN
2112: (SELECT jrd.regime_id
2113: FROM jai_rgm_definitions jrd
2114: WHERE jrd.regime_code = jai_constants.customs_regime)));
2115:
2116: CURSOR chk_ar_tax_type_cur
2117: IS

Line 2137: FROM jai_rgm_definitions jrd

2133: FROM jai_rgm_registrations jrr
2134: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2135: AND jrr.regime_id IN
2136: (SELECT jrd.regime_id
2137: FROM jai_rgm_definitions jrd
2138: WHERE jrd.regime_code = jai_constants.customs_regime))
2139: --Added by zhiwei for Bug#12561573 begin
2140: -------------------------------------------------
2141: or

Line 2720: FROM jai_rgm_definitions jrd

2716: (SELECT jrr.attribute_code
2717: FROM jai_rgm_registrations jrr
2718: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2719: AND jrr.regime_id = (SELECT jrd.regime_id
2720: FROM jai_rgm_definitions jrd
2721: WHERE jrd.regime_code = jai_constants.vat_regime)));
2722:
2723: CURSOR get_excise_tax_exists_cur(cn_trx_id IN NUMBER) IS
2724: SELECT 'Y'

Line 2803: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

2799: lv_vat_no JAI_INTERFACE_LINES_ALL.VAT_INVOICE_NO%TYPE;
2800: lv_excise_no JAI_INTERFACE_LINES_ALL.EXCISE_INVOICE_NO%TYPE;
2801: ln_error_flag NUMBER;
2802: lv_error_type VARCHAR2(20);
2803: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
2804: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
2805: ln_vat_exist NUMBER;
2806: ln_excise_exist NUMBER;
2807: ln_complete_count NUMBER;--20110111

Line 2804: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

2800: lv_excise_no JAI_INTERFACE_LINES_ALL.EXCISE_INVOICE_NO%TYPE;
2801: ln_error_flag NUMBER;
2802: lv_error_type VARCHAR2(20);
2803: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
2804: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
2805: ln_vat_exist NUMBER;
2806: ln_excise_exist NUMBER;
2807: ln_complete_count NUMBER;--20110111
2808: lv_determine_flag VARCHAR2(20);--20110111

Line 2837: FROM jai_rgm_definitions jrd

2833: (SELECT upper(jrr.attribute_code)
2834: FROM jai_rgm_registrations jrr
2835: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2836: AND jrr.regime_id = (SELECT jrd.regime_id
2837: FROM jai_rgm_definitions jrd
2838: WHERE jrd.regime_code = jai_constants.service_regime)));
2839: ln_st_num_count NUMBER;
2840: lv_service_tax_exist VARCHAR2(1);
2841: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 End*/

Line 4480: FROM jai_rgm_definitions jrd

4476: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
4477: AND jrr.regime_id IN
4478: (
4479: SELECT jrd.regime_id
4480: FROM jai_rgm_definitions jrd
4481: WHERE jrd.regime_code = jai_constants.service_regime
4482: )
4483: )
4484: or

Line 4518: FROM jai_rgm_definitions jrd

4514: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
4515: AND jrr.regime_id IN
4516: (
4517: SELECT jrd.regime_id
4518: FROM jai_rgm_definitions jrd
4519: WHERE jrd.regime_code = jai_constants.service_regime
4520: )
4521: )
4522: or

Line 5419: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

5415:
5416:
5417: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
5418: select to_date(attribute_value, 'DD/MM/YYYY')
5419: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5420: where jrr.regime_id = jrd.regime_id
5421: AND jrd.regime_code = jai_constants.service_regime
5422: and jrr.organization_id = p_organization_id
5423: and jrr.location_id = p_location_id

Line 5429: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

5425: AND jrr.attribute_type_code = 'OTHERS'
5426: AND jrr.registration_type = 'OTHERS'
5427: AND (NOT EXISTS
5428: (select '1'
5429: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5430: where jrr.regime_id = jrd.regime_id
5431: AND jrd.regime_code = jai_constants.service_regime
5432: and jrr.attribute_code IN 'INV_ORG_CLASSIFICATION'
5433: and jrr.attribute_value <> 'ORGANIZATION'

Line 5439: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

5435: and jrr.location_id = p_location_id)
5436: OR
5437: NOT EXISTS
5438: (select '1'
5439: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5440: where jrr.regime_id = jrd.regime_id
5441: AND jrd.regime_code = jai_constants.service_regime
5442: and jrr.attribute_code IN 'SERVICE TYPE'
5443: and jrr.attribute_value <> 'OTHER'

Line 5546: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

5542: v_trans_type VARCHAR2(30);
5543: v_line_tax_amount NUMBER := 0;
5544: l_tcs_line_num NUMBER := 0;
5545: l_tcs_sur_line_num NUMBER := 0;
5546: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
5547: l_org_id NUMBER;
5548: l_bill_to_customer_id NUMBER;
5549: l_bill_to_site_use_id NUMBER;
5550: ln_organization_id NUMBER;

Line 5560: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS

5556: ln_tax_amount NUMBER;
5557: l_tot_tax_lines NUMBER;
5558: l_max_tax_line_no NUMBER;
5559:
5560: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
5561: SELECT REGIME_ID
5562: FROM JAI_RGM_DEFINITIONS
5563: WHERE REGIME_CODE = CP_REGIME_CODE;
5564:

Line 5562: FROM JAI_RGM_DEFINITIONS

5558: l_max_tax_line_no NUMBER;
5559:
5560: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
5561: SELECT REGIME_ID
5562: FROM JAI_RGM_DEFINITIONS
5563: WHERE REGIME_CODE = CP_REGIME_CODE;
5564:
5565: Cursor transaction_type_cur IS
5566: Select a.type

Line 5662: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

5658: SELECT regime_id, regime_code
5659: FROM jai_regime_tax_types_v jrttv
5660: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);
5661:
5662: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
5663: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5664:
5665: -- Start of bug 4089440
5666: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

Line 5666: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

5662: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
5663: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5664:
5665: -- Start of bug 4089440
5666: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5667: lv_error_flag VARCHAR2(2);
5668: lv_error_message VARCHAR2(4000);
5669: -- End of bug 4089440
5670:

Line 8067: FROM jai_rgm_definitions jrd

8063: (SELECT jrr.attribute_code
8064: FROM jai_rgm_registrations jrr
8065: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8066: AND jrr.regime_id = (SELECT jrd.regime_id
8067: FROM jai_rgm_definitions jrd
8068: WHERE jrd.regime_code = jai_constants.vat_regime)));
8069:
8070: CURSOR get_excise_tax_exists_cur IS
8071: SELECT 'Y'

Line 8151: FROM jai_rgm_definitions jrd

8147: (SELECT upper(jrr.attribute_code)
8148: FROM jai_rgm_registrations jrr
8149: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8150: AND jrr.regime_id = (SELECT jrd.regime_id
8151: FROM jai_rgm_definitions jrd
8152: WHERE jrd.regime_code = jai_constants.service_regime)));
8153: CURSOR get_trx_st_no_cur
8154: IS
8155: SELECT

Line 10511: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS

10507: v_books_id NUMBER;
10508: v_salesrep_id NUMBER;
10509: v_trans_type VARCHAR2(30);
10510:
10511: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
10512: SELECT REGIME_ID
10513: FROM JAI_RGM_DEFINITIONS
10514: WHERE REGIME_CODE = CP_REGIME_CODE;
10515:

Line 10513: FROM JAI_RGM_DEFINITIONS

10509: v_trans_type VARCHAR2(30);
10510:
10511: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
10512: SELECT REGIME_ID
10513: FROM JAI_RGM_DEFINITIONS
10514: WHERE REGIME_CODE = CP_REGIME_CODE;
10515:
10516: CURSOR bind_cur(cn_customer_trx_id number)
10517: IS