APPS.CSP_PLANNING_PARAMETERS_PVT dependencies on CSP_SEC_INVENTORIES

Line 162: FROM CSP_SEC_INVENTORIES_V

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
163: WHERE organization_id = l_organization_id
164: AND secondary_inventory_name = l_secondary_inventory;
165:
166: l_node_icon varchar2(200);

Line 302: CSP_SEC_INVENTORIES_PKG.Insert_Row(

298: FETCH C3 INTO l_sec_inv_id;
299: CLOSE C3;
300:
301: If l_Sec_Inv_Id is NULL Then
302: CSP_SEC_INVENTORIES_PKG.Insert_Row(
303: L_SECONDARY_INVENTORY_ID
304: ,p_created_by
305: ,p_CREATION_DATE
306: ,P_LAST_UPDATED_BY

Line 339: UPDATE CSP_SEC_INVENTORIES SET CONDITION_TYPE = P_CONDITION_TYPE,

335: ,NULL
336: ,NULL
337: ,NULL);
338: ELSE
339: UPDATE CSP_SEC_INVENTORIES SET CONDITION_TYPE = P_CONDITION_TYPE,
340: AUTORECEIPT_FLAG = NVL(p_AUTORECEIPT_FLAG,'Y')
341: Where SECONDARY_INVENTORY_NAME = L_SECONDARY_INVENTORY
342: And ORGANIZATION_ID = l_organization_id
343: AND SECONDARY_INVENTORY_ID = l_sec_inv_id;

Line 980: csp_sec_inventories csi

976: FUNCTION VALIDATE_CONDITION_TYPE(p_org_id NUMBER,p_subinv VARCHAR2) RETURN VARCHAR2 IS
977: Cursor c_resource(p_org_id Number,p_subinv Varchar2) Is
978: Select csi.condition_type
979: From csp_inv_loc_assignments cila,
980: csp_sec_inventories csi
981: Where cila.organization_id = p_org_id
982: And cila.subinventory_code = p_subinv
983: --And nvl(cila.effective_date_end,sysdate) >= sysdate /* Forward port fix of 115.9 bug 4896449*/
984: And csi.secondary_inventory_name = cila.subinventory_code

Line 989: from csp_sec_inventories csi

985: And csi.organization_id = cila.organization_id;
986:
987: Cursor c_return_subinv(p_Org_Id Number,p_subinv Varchar2) Is
988: Select csi.condition_type
989: from csp_sec_inventories csi
990: Where csi.return_organization_id = p_org_id
991: And csi.return_subinventory_name = p_subinv
992: Group by csi.condition_type;
993: