APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_RGM_DEFINITIONS

Line 431: JAI_RGM_DEFINITIONS rgms

427: )
428: IS
429: SELECT 1
430: FROM jai_rgm_parties rgmpt,
431: JAI_RGM_DEFINITIONS rgms
432: WHERE rgmpt.regime_id = rgms.regime_id
433: AND rgmpt.location_id = cp_location_id
434: AND rgmpt.organization_id = cp_organization_id
435: AND rgms.regime_code = jai_constants.vat_regime;

Line 1588: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

1584: /** Bgowrava for forward porting Bug#5631784 */
1585: ln_tcs_exists number;
1586: --lv_process_flag jai_constants.successful%type;
1587: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1588: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
1589: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
1590: ln_last_line_no number;
1591: ln_base_line_no number;
1592: lv_context varchar2(240);

Line 1595: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)

1591: ln_base_line_no number;
1592: lv_context varchar2(240);
1593: ln_reg_id number;
1594:
1595: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
1596: IS
1597: SELECT REGIME_ID
1598: FROM JAI_RGM_DEFINITIONS
1599: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 1598: FROM JAI_RGM_DEFINITIONS

1594:
1595: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
1596: IS
1597: SELECT REGIME_ID
1598: FROM JAI_RGM_DEFINITIONS
1599: WHERE REGIME_CODE = CP_REGIME_CODE;
1600:
1601: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
1602: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

Line 1602: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

1598: FROM JAI_RGM_DEFINITIONS
1599: WHERE REGIME_CODE = CP_REGIME_CODE;
1600:
1601: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
1602: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
1603: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE
1604: )
1605: IS
1606: SELECT COUNT(1)