APPS.CSP_PLANNING_PARAMETERS_PVT dependencies on CSP_PLANNING_PARAMETERS

Line 1: package body csp_planning_parameters_pvt as

1: package body csp_planning_parameters_pvt as
2: /* $Header: cspvpprb.pls 120.0.12020000.4 2013/03/21 04:06:45 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name :csp_planning_parameters_pvt
5: -- Purpose :

Line 4: -- Package name :csp_planning_parameters_pvt

1: package body csp_planning_parameters_pvt as
2: /* $Header: cspvpprb.pls 120.0.12020000.4 2013/03/21 04:06:45 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name :csp_planning_parameters_pvt
5: -- Purpose :
6: -- History :
7: -- 01-Mar-13, sunarasi
8: --

Line 144: (Select secondary_inventory from csp_planning_parameters

140: from mtl_secondary_inventories
141: where organization_id = L_ORGANIZATION_ID
142: and nvl(Disable_date,Sysdate+1) > Sysdate
143: and secondary_inventory_name not in
144: (Select secondary_inventory from csp_planning_parameters
145: where organization_id = L_ORGANIZATION_ID)
146: and rownum =1;
147:
148: CURSOR C_SEC_INV2(L_ORGANIZATION_ID NUMBER,P_SECONDARY_INVENTORY Varchar2) IS

Line 155: (Select secondary_inventory from csp_planning_parameters

151: where organization_id = L_ORGANIZATION_ID
152: AND SECONDARY_INVENTORY_NAME <> P_SECONDARY_INVENTORY
153: and nvl(Disable_date,Sysdate+1) > Sysdate
154: and secondary_inventory_name not in
155: (Select secondary_inventory from csp_planning_parameters
156: where organization_id = L_ORGANIZATION_ID);
157:
158: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
159:

Line 158: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;

154: and secondary_inventory_name not in
155: (Select secondary_inventory from csp_planning_parameters
156: where organization_id = L_ORGANIZATION_ID);
157:
158: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
159:
160: CURSOR C3(l_secondary_inventory Varchar2,l_organization_id Number) IS
161: SELECT SECONDARY_INVENTORY_ID
162: FROM CSP_SEC_INVENTORIES_V

Line 171: Csp_Planning_Parameters_pkg.Insert_Row (

167: l_curr_node_type Varchar2(2000);
168:
169: BEGIN
170: /*
171: Csp_Planning_Parameters_pkg.Insert_Row (
172: px_PLANNING_PARAMETERS_ID => l_Planning_Parameters_Id,
173: p_FORECAST_RULE_ID => p_Forecast_Rule_Id,
174: p_ORGANIZATION_ID => p_Organization_Id,
175: p_SECONDARY_INVENTORY => p_secondary_inventory,

Line 696: From CSP_PLANNING_PARAMETERS

692: ,l_OVERRIDE_USAGE_WEIGHT2
693: ,l_OVERRIDE_USAGE_WEIGHT3
694: ,L_OVERRIDE_USAGE_WEIGHT4
695: ,l_node_name
696: From CSP_PLANNING_PARAMETERS
697: WHERE planning_parameters_id = l_planning_parameters_id;
698: Exception
699: When no_data_found then
700: Null;

Line 704: Csp_Planning_Parameters_pkg.Update_Row (

700: Null;
701: END;
702:
703: /*
704: Csp_Planning_Parameters_pkg.Update_Row (
705: p_PLANNING_PARAMETERS_ID => p_Planning_Parameters_Id,
706: p_FORECAST_RULE_ID => p_Forecast_Rule_Id,
707: p_ORGANIZATION_ID => p_Organization_Id,
708: p_SECONDARY_INVENTORY => p_secondary_inventory,

Line 864: UPDATE CSP_PLANNING_PARAMETERS SET

860: NVL(l_OVERRIDE_USAGE_WEIGHT2,'Y') <> p_OVERRIDE_USAGE_WEIGHT2 OR
861: NVL(L_OVERRIDE_USAGE_WEIGHT3,'Y') <> P_OVERRIDE_USAGE_WEIGHT3 OR
862: NVL(l_OVERRIDE_USAGE_WEIGHT4,'Y') <> p_OVERRIDE_USAGE_WEIGHT4 ) THEN
863: BEGIN
864: UPDATE CSP_PLANNING_PARAMETERS SET
865: PRODUCT_NORM_NODE_ID = Decode(DEFAULT_PRODUCT_NORM_NODE_ID,l_node_name,P_PRODUCT_NORM_NODE_ID,PRODUCT_NORM_NODE_ID)
866: ,DEFAULT_PRODUCT_NORM_NODE_ID = DECODE(DEFAULT_PRODUCT_NORM_NODE_ID,L_NODE_NAME,P_DEFAULT_PRODUCT_NORM_NODE_ID,DEFAULT_PRODUCT_NORM_NODE_ID)
867: ,FORECAST_RULE_ID = Decode(DEFAULT_FORECAST_RULE_ID,l_node_name,P_FORECAST_RULE_ID,FORECAST_RULE_ID)
868: ,DEFAULT_FORECAST_RULE_ID = Decode(DEFAULT_FORECAST_RULE_ID,l_node_name,P_DEFAULT_FORECAST_RULE_ID,DEFAULT_FORECAST_RULE_ID)

Line 929: Csp_Planning_Parameters_Pkg.Delete_Row (p_LEVEL_ID => p_level_id);

925: l_Planning_Parameters_Id Number;
926: l_node_value Varchar2(200);
927: Begin
928: IF L_LEVEL_ID IS NOT NULL THEN
929: Csp_Planning_Parameters_Pkg.Delete_Row (p_LEVEL_ID => p_level_id);
930: End if;
931:
932: /*
933: If l_node_type in (planner.pln_org_node) then