[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Manually_Insert_Detail
( P_Line_Detail_Id NUMBER,
P_Creation_Date IN OUT DATE,
P_Created_By NUMBER,
P_Last_Update_Date IN OUT DATE,
P_Last_Updated_By NUMBER,
P_Last_Update_Login NUMBER,
P_Line_Id NUMBER,
P_Inventory_Item_Id NUMBER,
P_Component_Sequence_Id NUMBER,
P_Component_Code VARCHAR2,
P_Quantity NUMBER,
P_Schedule_Date DATE,
P_Lot_Number VARCHAR2,
P_Subinventory VARCHAR2,
P_Warehouse_Id NUMBER,
P_Revision VARCHAR2,
P_Customer_Requested_Lot_Flag VARCHAR2,
P_Schedule_Status_Code VARCHAR2,
P_Context VARCHAR2,
P_Attribute1 VARCHAR2,
P_Attribute2 VARCHAR2,
P_Attribute3 VARCHAR2,
P_Attribute4 VARCHAR2,
P_Attribute5 VARCHAR2,
P_Attribute6 VARCHAR2,
P_Attribute7 VARCHAR2,
P_Attribute8 VARCHAR2,
P_Attribute9 VARCHAR2,
P_Attribute10 VARCHAR2,
P_Attribute11 VARCHAR2,
P_Attribute12 VARCHAR2,
P_Attribute13 VARCHAR2,
P_Attribute14 VARCHAR2,
P_Attribute15 VARCHAR2,
P_Included_Item_Flag VARCHAR2,
P_Component_Ratio NUMBER,
P_Shippable_Flag VARCHAR2,
P_Transactable_Flag VARCHAR2,
P_Reservable_Flag VARCHAR2,
P_Released_Flag VARCHAR2,
P_Demand_Class_Code VARCHAR2,
P_Unit_Code VARCHAR2,
P_Required_For_Revenue_Flag IN OUT VARCHAR2,
P_Quantity_Svrid NUMBER,
P_Warehouse_Svrid NUMBER,
P_Demand_Class_Svrid NUMBER,
P_Date_Svrid NUMBER,
P_Customer_Requested_Svrid NUMBER,
P_Df_Svrid NUMBER,
P_Delivery NUMBER,
P_Update_Flag VARCHAR2,
P_Configuration_Item_Flag VARCHAR2,
P_Result IN OUT VARCHAR2,
P_Dpw_Assigned_Flag VARCHAR2 DEFAULT 'N'
) IS
temp_sysdate DATE;
SELECT 'Y'
FROM SO_LINES L, SO_LINE_DETAILS D
WHERE L.LINE_ID = D.LINE_ID
AND D.LINE_DETAIL_ID = P_Line_Detail_Id
AND L.OPTION_FLAG = 'Y';
SELECT SYSDATE
INTO temp_sysdate
FROM DUAL;
P_Last_Update_Date := temp_sysdate;
SELECT DECODE( REQUIRED_FOR_REVENUE, 1, 'Y', 'N' )
INTO P_Required_For_Revenue_Flag
FROM BOM_INVENTORY_COMPONENTS
WHERE COMPONENT_SEQUENCE_ID = P_Component_Sequence_Id;
INSERT INTO SO_LINE_DETAILS
( LINE_DETAIL_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LINE_ID,
INVENTORY_ITEM_ID,
COMPONENT_SEQUENCE_ID,
COMPONENT_CODE,
QUANTITY,
SCHEDULE_DATE,
LOT_NUMBER,
SUBINVENTORY,
WAREHOUSE_ID,
REVISION,
CUSTOMER_REQUESTED_LOT_FLAG,
SCHEDULE_STATUS_CODE,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
INCLUDED_ITEM_FLAG,
COMPONENT_RATIO,
SHIPPABLE_FLAG,
TRANSACTABLE_FLAG,
RESERVABLE_FLAG,
RELEASED_FLAG,
DEMAND_CLASS_CODE,
UNIT_CODE,
REQUIRED_FOR_REVENUE_FLAG,
QUANTITY_SVRID,
WAREHOUSE_SVRID,
DEMAND_CLASS_SVRID,
DATE_SVRID,
CUSTOMER_REQUESTED_SVRID,
DF_SVRID,
DELIVERY,
UPDATE_FLAG,
CONFIGURATION_ITEM_FLAG,
DPW_ASSIGNED_FLAG)
VALUES
( P_Line_Detail_Id,
P_Creation_Date,
P_Created_By,
P_Last_Update_Date,
P_Last_Updated_By,
P_Last_Update_Login,
P_Line_Id,
P_Inventory_Item_Id,
P_Component_Sequence_Id,
P_Component_Code,
P_Quantity,
P_Schedule_Date,
P_Lot_Number,
P_Subinventory,
P_Warehouse_Id,
P_Revision,
P_Customer_Requested_Lot_Flag,
P_Schedule_Status_Code,
P_Context,
P_Attribute1,
P_Attribute2,
P_Attribute3,
P_Attribute4,
P_Attribute5,
P_Attribute6,
P_Attribute7,
P_Attribute8,
P_Attribute9,
P_Attribute10,
P_Attribute11,
P_Attribute12,
P_Attribute13,
P_Attribute14,
P_Attribute15,
P_Included_Item_Flag,
P_Component_Ratio,
P_Shippable_Flag,
P_Transactable_Flag,
P_Reservable_Flag,
P_Released_Flag,
P_Demand_Class_Code,
P_Unit_Code,
P_Required_For_Revenue_Flag,
P_Quantity_Svrid,
P_Warehouse_Svrid,
P_Demand_Class_Svrid,
P_Date_Svrid,
P_Customer_Requested_Svrid,
P_Df_Svrid,
P_Delivery,
P_Update_Flag,
P_Configuration_Item_Flag,
P_Dpw_Assigned_Flag);
Raise_Exception ('OE_LINE_DETAILS_PKG.Insert_Manual_Detail',
'',
SQLERRM);
END Manually_Insert_Detail;