APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 1528: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;

1524: -- Added by brathod for Bug#4215808
1525:
1526: ln_vat_cnt NUMBER DEFAULT 0 ;
1527: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
1528: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
1529: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
1530:
1531: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1532: IS

Line 1529: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;

1525:
1526: ln_vat_cnt NUMBER DEFAULT 0 ;
1527: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
1528: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
1529: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
1530:
1531: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1532: IS
1533: SELECT 1

Line 1542: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,

1538: AND jtc.tax_id = jsptl.tax_id
1539: AND jtc.tax_type = tax_types.tax_type
1540: AND tax_types.regime_code = jai_constants.vat_regime;
1541:
1542: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1543: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE
1544: )
1545: IS
1546: SELECT regime_id,

Line 1543: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE

1539: AND jtc.tax_type = tax_types.tax_type
1540: AND tax_types.regime_code = jai_constants.vat_regime;
1541:
1542: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1543: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE
1544: )
1545: IS
1546: SELECT regime_id,
1547: attribute_value

Line 1548: FROM JAI_RGM_ORG_REGNS_V orrg

1544: )
1545: IS
1546: SELECT regime_id,
1547: attribute_value
1548: FROM JAI_RGM_ORG_REGNS_V orrg
1549: WHERE orrg.organization_id = cp_organization_id
1550: AND orrg.location_id = cp_location_id
1551: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1552: AND attribute_code = jai_constants.attr_code_regn_no