APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 805: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;

801: lv_process_message VARCHAR2(1996);
802:
803: ln_vat_cnt NUMBER DEFAULT 0 ;
804: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
805: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
806: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
807:
808: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
809: IS

Line 806: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;

802:
803: ln_vat_cnt NUMBER DEFAULT 0 ;
804: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
805: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
806: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
807:
808: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
809: IS
810: SELECT 1

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

815: AND jtc.tax_id = jsptl.tax_id
816: AND jtc.tax_type = tax_types.tax_type
817: AND tax_types.regime_code = jai_constants.vat_regime;
818:
819: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
820: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE
821: )
822: IS
823: SELECT regime_id,

Line 820: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE

816: AND jtc.tax_type = tax_types.tax_type
817: AND tax_types.regime_code = jai_constants.vat_regime;
818:
819: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
820: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE
821: )
822: IS
823: SELECT regime_id,
824: attribute_value

Line 825: FROM JAI_RGM_ORG_REGNS_V orrg

821: )
822: IS
823: SELECT regime_id,
824: attribute_value
825: FROM JAI_RGM_ORG_REGNS_V orrg
826: WHERE orrg.organization_id = cp_organization_id
827: AND orrg.location_id = cp_location_id
828: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
829: AND attribute_code = jai_constants.attr_code_regn_no

Line 3839: FROM JAI_RGM_ORG_REGNS_V

3835: AND organization_id = cp_organization_id;
3836:
3837: CURSOR c_reg_num(cp_regime_id number,cp_organization_id wsh_delivery_details.ORGANIZATION_ID%TYPE , cp_location_id wsh_delivery_details.ship_to_location_id%TYPE ) IS
3838: SELECT attribute_Value
3839: FROM JAI_RGM_ORG_REGNS_V
3840: WHERE regime_id = cp_regime_id
3841: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
3842: AND attribute_code = jai_constants.attr_code_regn_no
3843: AND organization_id = cp_organization_id