PACKAGE: APPS.OE_LINE_DETAILS_PKG

Source

1 PACKAGE OE_LINE_DETAILS_PKG AUTHID CURRENT_USER AS
2 /* $Header: oexdets.pls 115.0 99/07/16 08:28:56 porting ship $ */
3     PROCEDURE Manually_Insert_Detail
4          (      P_Line_Detail_Id			NUMBER,
5 		P_Creation_Date			IN OUT  DATE,
6                 P_Created_By				NUMBER,
7 		P_Last_Update_Date		IN OUT  DATE,
8                 P_Last_Updated_By			NUMBER,
9                 P_Last_Update_Login			NUMBER,
10                 P_Line_Id				NUMBER,
11                 P_Inventory_Item_Id			NUMBER,
12                 P_Component_Sequence_Id			NUMBER,
13                 P_Component_Code			VARCHAR2,
14                 P_Quantity				NUMBER,
15                 P_Schedule_Date				DATE,
16                 P_Lot_Number				VARCHAR2,
17                 P_Subinventory				VARCHAR2,
18                 P_Warehouse_Id				NUMBER,
19                 P_Revision				VARCHAR2,
20                 P_Customer_Requested_Lot_Flag		VARCHAR2,
21                 P_Schedule_Status_Code			VARCHAR2,
22                 P_Context				VARCHAR2,
23                 P_Attribute1				VARCHAR2,
24                 P_Attribute2				VARCHAR2,
25                 P_Attribute3				VARCHAR2,
26                 P_Attribute4				VARCHAR2,
27                 P_Attribute5				VARCHAR2,
28                 P_Attribute6				VARCHAR2,
29                 P_Attribute7				VARCHAR2,
30                 P_Attribute8				VARCHAR2,
31                 P_Attribute9				VARCHAR2,
32                 P_Attribute10				VARCHAR2,
33                 P_Attribute11				VARCHAR2,
34                 P_Attribute12				VARCHAR2,
35                 P_Attribute13				VARCHAR2,
36                 P_Attribute14				VARCHAR2,
37                 P_Attribute15				VARCHAR2,
38                 P_Included_Item_Flag    		VARCHAR2,
39                 P_Component_Ratio			NUMBER,
40                 P_Shippable_Flag			VARCHAR2,
41                 P_Transactable_Flag			VARCHAR2,
42                 P_Reservable_Flag			VARCHAR2,
43                 P_Released_Flag				VARCHAR2,
44                 P_Demand_Class_Code			VARCHAR2,
45                 P_Unit_Code				VARCHAR2,
46                 P_Required_For_Revenue_Flag IN OUT	VARCHAR2,
47                 P_Quantity_Svrid			NUMBER,
48                 P_Warehouse_Svrid			NUMBER,
49                 P_Demand_Class_Svrid			NUMBER,
50                 P_Date_Svrid				NUMBER,
51                 P_Customer_Requested_Svrid		NUMBER,
52                 P_Df_Svrid				NUMBER,
53                 P_Delivery				NUMBER,
54                 P_Update_Flag				VARCHAR2,
55                 P_Configuration_Item_Flag		VARCHAR2,
56 		P_Result			IN OUT  VARCHAR2,
57 		P_Dpw_Assigned_Flag			VARCHAR2 DEFAULT 'N'
58 		);
59 
60   PROCEDURE Validate_Scheduling_Attributes
61 	(
62 		P_DB_RECORD_FLAG		VARCHAR2,
63 		P_DB_QUANTITY			NUMBER,
64 		P_DB_WAREHOUSE_ID		NUMBER,
65 		P_DB_SCHEDULE_DATE		DATE,
66 		P_DB_SUBINVENTORY		VARCHAR2,
67 		P_DB_REVISION			VARCHAR2,
68 		P_DB_LOT_NUMBER			VARCHAR2,
69 		P_DB_DEMAND_CLASS_CODE		VARCHAR2,
70 		P_QUANTITY			NUMBER,
71 		P_WAREHOUSE_ID			NUMBER,
72 		P_SCHEDULE_DATE			DATE,
73 		P_SUBINVENTORY			VARCHAR2,
74 		P_REVISION			VARCHAR2,
75 		P_LOT_NUMBER			VARCHAR2,
76 		P_DEMAND_CLASS_CODE		VARCHAR2,
77 		P_REVISION_CONTROL_FLAG		VARCHAR2,
78 		P_LOT_CONTROL_FLAG		VARCHAR2,
79 		P_SCHEDULE_ACTION_CODE		VARCHAR2,
80 		P_SCHEDULE_STATUS_CODE		VARCHAR2,
81 		P_RESULT		IN OUT	VARCHAR2
82 	);
83 
84 
85 END OE_LINE_DETAILS_PKG;