APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 4276: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;

4272: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
4273:
4274: ln_vat_cnt NUMBER DEFAULT 0 ;
4275: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
4276: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
4277: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
4278:
4279: ln_vat_reversal_exists NUMBER ;
4280: lv_vat_reversal VARCHAR2(100);

Line 4277: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;

4273:
4274: ln_vat_cnt NUMBER DEFAULT 0 ;
4275: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
4276: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;
4277: lv_regns_num JAI_RGM_ORG_REGNS_V.ATTRIBUTE_VALUE%TYPE;
4278:
4279: ln_vat_reversal_exists NUMBER ;
4280: lv_vat_reversal VARCHAR2(100);
4281: lv_vat_invoice_no VARCHAR2(10);

Line 4390: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE

4386: WHERE jsptl.order_line_id = cp_order_line_id
4387: AND jtc.tax_id = jsptl.tax_id
4388: AND jtc.tax_type = cp_tax_type;
4389:
4390: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE
4391: , cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE)
4392: IS
4393: SELECT regime_id
4394: , attribute_value

Line 4391: , cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE)

4387: AND jtc.tax_id = jsptl.tax_id
4388: AND jtc.tax_type = cp_tax_type;
4389:
4390: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE
4391: , cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE)
4392: IS
4393: SELECT regime_id
4394: , attribute_value
4395: FROM JAI_RGM_ORG_REGNS_V orrg

Line 4395: FROM JAI_RGM_ORG_REGNS_V orrg

4391: , cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE)
4392: IS
4393: SELECT regime_id
4394: , attribute_value
4395: FROM JAI_RGM_ORG_REGNS_V orrg
4396: WHERE orrg.organization_id = cp_organization_id
4397: AND orrg.location_id = NVL(cp_location_id, cp_organization_id)
4398: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
4399: AND attribute_code = jai_constants.attr_code_regn_no

Line 4412: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)

4408:
4409: --Added by Bo Li for bug#10043656 Begin
4410: --------------------------------------------------
4411: /*CURSOR cur_chk_gst_exists (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE,
4412: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)
4413: IS
4414: SELECT 1
4415: FROM JAI_OM_WSH_LINE_TAXES jsptl
4416: , JAI_CMN_TAXES_ALL jtc