APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on JAI_CONSTANTS

Line 47: AND jrd.regime_code = jai_constants.cgst_regime

43: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
44: WHERE jrp.ORGANIZATION_ID = pn_organization_id
45: AND jrp.ORGANIZATION_TYPE = 'IO' --inventory organization
46: AND jrd.regime_id = jrp.regime_id
47: AND jrd.regime_code = jai_constants.cgst_regime
48: AND jrp.location_id = pn_location_id;
49:
50: CURSOR cur_sgst_state(pn_organization_id IN NUMBER) IS
51: SELECT jrp.state_code state_code

Line 56: AND jrd.regime_code = jai_constants.sgst_regime

52: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
53: WHERE jrp.ORGANIZATION_ID = pn_organization_id
54: AND jrp.ORGANIZATION_TYPE = 'IO' --inventory organization
55: AND jrd.regime_id = jrp.regime_id
56: AND jrd.regime_code = jai_constants.sgst_regime
57: AND jrp.location_id = pn_location_id;
58:
59: v_organization_id NUMBER;
60: v_state JAI_RGM_PARTIES.state_code%TYPE;

Line 123: AND jrd.regime_code = jai_constants.cgst_regime

119: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
120: WHERE jrp.ORGANIZATION_ID = pn_org_id
121: AND jrp.ORGANIZATION_TYPE = 'OU' --operating unit
122: AND jrd.regime_id = jrp.regime_id
123: AND jrd.regime_code = jai_constants.cgst_regime
124: AND jrp.state_code IS NOT NULL;
125:
126: CURSOR cur_sgst_state IS
127: SELECT jrp.state_code state_code

Line 132: AND jrd.regime_code = jai_constants.sgst_regime

128: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
129: WHERE jrp.ORGANIZATION_ID = pn_org_id
130: AND jrp.ORGANIZATION_TYPE = 'OU' --operating unit
131: AND jrd.regime_id = jrp.regime_id
132: AND jrd.regime_code = jai_constants.sgst_regime
133: AND jrp.state_code IS NOT NULL;
134:
135: v_state JAI_RGM_PARTIES.state_code%TYPE;
136: BEGIN

Line 724: WHERE a.attribute_code = jai_constants.tax_classification

720: --get tax_classification, if cgst not found, get from SGST
721: CURSOR tax_classification_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER) IS
722: SELECT a.attribute_value
723: FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r
724: WHERE a.attribute_code = jai_constants.tax_classification
725: AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
726: AND r.inventory_item_id = v_inventory_item_id
727: AND r.organization_id = v_org_id
728: AND r.regime_code = jai_constants.cgst_regime;

Line 728: AND r.regime_code = jai_constants.cgst_regime;

724: WHERE a.attribute_code = jai_constants.tax_classification
725: AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
726: AND r.inventory_item_id = v_inventory_item_id
727: AND r.organization_id = v_org_id
728: AND r.regime_code = jai_constants.cgst_regime;
729: CURSOR sgst_tax_classification_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER) IS
730: SELECT a.attribute_value
731: FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r
732: WHERE a.attribute_code = jai_constants.tax_classification

Line 732: WHERE a.attribute_code = jai_constants.tax_classification

728: AND r.regime_code = jai_constants.cgst_regime;
729: CURSOR sgst_tax_classification_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER) IS
730: SELECT a.attribute_value
731: FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r
732: WHERE a.attribute_code = jai_constants.tax_classification
733: AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
734: AND r.inventory_item_id = v_inventory_item_id
735: AND r.organization_id = v_org_id
736: AND r.regime_code = jai_constants.sgst_regime;

Line 736: AND r.regime_code = jai_constants.sgst_regime;

732: WHERE a.attribute_code = jai_constants.tax_classification
733: AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
734: AND r.inventory_item_id = v_inventory_item_id
735: AND r.organization_id = v_org_id
736: AND r.regime_code = jai_constants.sgst_regime;
737:
738: v_inter_flag VARCHAR2(1);
739: v_tax_classification VARCHAR2(240);
740: v_organization_id NUMBER;