APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 1768: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;

1764: -- Added by brathod for Bug#4215808
1765:
1766: ln_vat_cnt NUMBER DEFAULT 0 ;
1767: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
1768: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
1769: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
1770:
1771: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1772: IS

Line 1769: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;

1765:
1766: ln_vat_cnt NUMBER DEFAULT 0 ;
1767: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
1768: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
1769: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
1770:
1771: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1772: IS
1773: SELECT 1

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

1778: AND jtc.tax_id = jsptl.tax_id
1779: AND jtc.tax_type = tax_types.tax_type
1780: AND tax_types.regime_code = jai_constants.vat_regime;
1781:
1782: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1783: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE
1784: )
1785: IS
1786: SELECT regime_id,

Line 1783: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE

1779: AND jtc.tax_type = tax_types.tax_type
1780: AND tax_types.regime_code = jai_constants.vat_regime;
1781:
1782: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1783: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE
1784: )
1785: IS
1786: SELECT regime_id,
1787: attribute_value

Line 1788: FROM JAI_RGM_ORG_REGNS_V orrg

1784: )
1785: IS
1786: SELECT regime_id,
1787: attribute_value
1788: FROM JAI_RGM_ORG_REGNS_V orrg
1789: WHERE orrg.organization_id = cp_organization_id
1790: AND orrg.location_id = cp_location_id
1791: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1792: AND attribute_code = jai_constants.attr_code_regn_no