DBA Data[Home] [Help]

APPS.CSP_PLANNING_PARAMETERS_PVT dependencies on CSP_USAGE_HEADERS

Line 287: UPDATE CSP_USAGE_HEADERS

283: l_condition_type := p_condition_type;
284:
285: If l_node_type = 'SUBINVENTORY' Then
286: Begin
287: UPDATE CSP_USAGE_HEADERS
288: set planning_parameters_id = l_planning_parameters_id
289: WHERE HEADER_DATA_TYPE = 1
290: AND SECONDARY_INVENTORY = L_SECONDARY_INVENTORY
291: And Organization_Id = l_Organization_Id;

Line 347: UPDATE CSP_USAGE_HEADERS

343: AND SECONDARY_INVENTORY_ID = l_sec_inv_id;
344: End if;
345: ElsIf l_node_type = 'ORGANIZATION_WH' Then
346: Begin
347: UPDATE CSP_USAGE_HEADERS
348: set planning_parameters_id = l_planning_parameters_id
349: WHERE HEADER_DATA_TYPE IN (1,4)
350: And Organization_Id = l_Organization_Id
351: and Secondary_Inventory = '-';