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_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 319: FROM JAI_RGM_DEFINITIONS

315: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.get_reversal_account_name';
316:
317: CURSOR c_regime_code(cp_regime_id IN NUMBER) IS
318: SELECT regime_code
319: FROM JAI_RGM_DEFINITIONS
320: WHERE regime_id = cp_regime_id;
321:
322:
323: CURSOR c_orgn_tax_type_account

Line 341: FROM JAI_RGM_DEFINITIONS

337:
338:
339: CURSOR c_regime_id(cp_regime_code IN VARCHAR2) IS
340: SELECT regime_id
341: FROM JAI_RGM_DEFINITIONS
342: WHERE regime_code = cp_regime_code;
343:
344:
345: lv_reversal_account_name JAI_RGM_REGISTRATIONS.attribute_value%TYPE;

Line 350: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

346:
347: lv_organization_type VARCHAR2(2);
348: ln_organization_id NUMBER;
349:
350: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
351: lv_excise_cess JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
352: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE;
353:
354: BEGIN

Line 352: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE;

348: ln_organization_id NUMBER;
349:
350: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
351: lv_excise_cess JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
352: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE;
353:
354: BEGIN
355:
356: lv_excise_cess := 'EXCISE-CESS';

Line 615: FROM jai_rgm_definitions

611: WHERE customer_trx_id = pn_invoice_id;
612:
613: CURSOR get_regime_cur IS
614: SELECT regime_id
615: FROM jai_rgm_definitions
616: WHERE regime_code = jai_constants.service_regime;
617:
618: CURSOR c_ar_ref_records(cp_source_document_id NUMBER, cp_source_ar VARCHAR2) IS
619: SELECT *

Line 1565: ld_rgm_effective_from JAI_RGM_DEFINITIONS.effective_date_from%TYPE;

1561: AND attribute_value = cp_registration_num
1562: AND a.organization_id = nvl(cp_organization_id,a.organization_id) /*5694855*/;
1563:
1564:
1565: ld_rgm_effective_from JAI_RGM_DEFINITIONS.effective_date_from%TYPE;
1566: CURSOR c_rgm_effective_from_date(cp_regime_id IN NUMBER) IS
1567: SELECT trunc(creation_date) effective_date_from /* effective_date_from. Commneted this as part of VAT Impl. Vijay Shankar for Bug#425023(4245089) */
1568: FROM JAI_RGM_DEFINITIONS
1569: WHERE regime_id = cp_regime_id;

Line 1568: FROM JAI_RGM_DEFINITIONS

1564:
1565: ld_rgm_effective_from JAI_RGM_DEFINITIONS.effective_date_from%TYPE;
1566: CURSOR c_rgm_effective_from_date(cp_regime_id IN NUMBER) IS
1567: SELECT trunc(creation_date) effective_date_from /* effective_date_from. Commneted this as part of VAT Impl. Vijay Shankar for Bug#425023(4245089) */
1568: FROM JAI_RGM_DEFINITIONS
1569: WHERE regime_id = cp_regime_id;
1570: /*Bug 5879769 bduvarag start*/
1571: CURSOR cur_fetch_ou(cp_organization_id NUMBER)
1572: IS

Line 2311: FROM JAI_RGM_DEFINITIONS

2307: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
2308: select to_date(attribute_value, 'DD/MM/YYYY')
2309: from JAI_RGM_ORG_REGNS_V
2310: where regime_id = (SELECT regime_id
2311: FROM JAI_RGM_DEFINITIONS
2312: WHERE regime_code = jai_constants.service_regime)
2313: and organization_id = p_organization_id
2314: and location_id = p_location_id
2315: AND attribute_code = 'EFF_DATE_ST_PT'

Line 2380: FROM JAI_RGM_DEFINITIONS

2376:
2377: cursor get_regime_id
2378: is
2379: SELECT regime_id
2380: FROM JAI_RGM_DEFINITIONS
2381: WHERE regime_code = jai_constants.service_regime;
2382: ----------------------------------------------------------------------------------
2383: --Added by zhiwei for POT change bug#13435283 on 20111201 end
2384:

Line 2580: FROM JAI_RGM_DEFINITIONS

2576:
2577: /*
2578: SELECT regime_id
2579: into ln_regime_id
2580: FROM JAI_RGM_DEFINITIONS
2581: WHERE regime_code = jai_constants.service_regime;
2582: */--Commented by Zhiwei.Hou for Bug#13435283.
2583:
2584:

Line 3026: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,

3022:
3023: PROCEDURE process (
3024: retcode OUT NOCOPY VARCHAR2,
3025: errbuf OUT NOCOPY VARCHAR2,
3026: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,
3027: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
3028: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
3029: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
3030: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin

Line 3179: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

3175: lv_debug VARCHAR2(5); -- := jai_constants.no /* This should be either 'Y' or 'N' */ File.Sql.35 by Brathod
3176: ln_order_type_id JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID%TYPE;
3177: lv_inv_num_already_generated VARCHAR2(10); --:= jai_constants.value_false File.Sql.35 by Brathod
3178: ln_batch_id NUMBER;
3179: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
3180: ln_current_party_id NUMBER;
3181: ln_current_party_site_id NUMBER;
3182: lv_party_has_changed VARCHAR2(10);
3183: ln_conc_progam_id NUMBER;

Line 3213: FROM JAI_RGM_DEFINITIONS

3209: -- added by Allen Yang for bug 9709477 13-May-2010, end
3210:
3211: CURSOR c_regime_cur(cp_trx_Date DATE) IS
3212: SELECT regime_id
3213: FROM JAI_RGM_DEFINITIONS
3214: WHERE regime_code = jai_constants.vat_regime;
3215:
3216: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3217: CURSOR c_shipment_info(cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE

Line 4588: FROM JAI_RGM_DEFINITIONS

4584: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
4585: select to_date(attribute_value, 'DD/MM/YYYY')
4586: from JAI_RGM_ORG_REGNS_V
4587: where regime_id = (SELECT regime_id
4588: FROM JAI_RGM_DEFINITIONS
4589: WHERE regime_code = jai_constants.service_regime)
4590: and organization_id = p_organization_id
4591: and location_id = p_location_id
4592: AND attribute_code = 'EFF_DATE_ST_PT'