[Home] [Help]
PACKAGE: APPS.BOM_INV_COMPS1_PKG
Source
1 PACKAGE BOM_INV_COMPS1_PKG AUTHID CURRENT_USER as
2 /* $Header: bompic1s.pls 120.0 2005/05/25 06:08:11 appldev noship $ */
3
4 PROCEDURE Check_Overlap(X_Rowid VARCHAR2,
5 X_Bill_Sequence_Id NUMBER,
6 X_Component_Item_Id NUMBER,
7 X_Operation_Seq_Num NUMBER,
8 X_Disable_Date DATE,
9 X_Effectivity_Date DATE);
10
11 PROCEDURE Check_Unit_Number_Overlap(X_Rowid VARCHAR2,
12 X_Bill_Sequence_Id NUMBER,
13 X_Component_Item_Id NUMBER,
14 X_Operation_Seq_Num NUMBER,
15 X_From_Unit_Number VARCHAR2,
16 X_To_Unit_Number VARCHAR2);
17
18 PROCEDURE Check_Commons(X_Bill_Sequence_Id NUMBER,
19 X_Organization_Id NUMBER,
20 X_Component_Item_Id NUMBER,
21 X_Bill_or_Eco NUMBER DEFAULT 2); -- bug1517975
22
23 PROCEDURE Check_ATP(X_Organization_Id NUMBER,
24 X_Component_Item_Id NUMBER,
25 X_ATP_Comps_Flag VARCHAR2,
26 X_WIP_Supply_Type NUMBER,
27 X_Replenish_To_Order_Flag VARCHAR2,
28 X_Pick_Components_Flag VARCHAR2);
29
30 PROCEDURE Check_Unique(X_Rowid VARCHAR2,
31 X_Bill_Sequence_Id NUMBER,
32 X_Component_Item_Id NUMBER,
33 X_Operation_Seq_Num NUMBER,
34 X_Effectivity_Date DATE,
35 X_bill_or_eco NUMBER);
36
37 PROCEDURE Check_Unique_From_Unit_Number(X_Rowid VARCHAR2,
38 X_Bill_Sequence_Id NUMBER,
39 X_Component_Item_Id NUMBER,
40 X_Operation_Seq_Num NUMBER,
41 X_From_Unit_Number VARCHAR2,
42 X_bill_or_eco NUMBER);
43
44 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
45 X_Operation_Seq_Num NUMBER,
46 X_Component_Item_Id NUMBER,
47 X_Last_Update_Date DATE,
48 X_Last_Updated_By NUMBER,
49 X_Creation_Date DATE,
50 X_Created_By NUMBER,
51 X_Last_Update_Login NUMBER,
52 X_Item_Num NUMBER,
53 X_Component_Quantity NUMBER,
54 X_Component_Yield_Factor NUMBER,
55 X_Component_Remarks VARCHAR2,
56 X_Effectivity_Date DATE,
57 X_Change_Notice VARCHAR2,
58 X_Implementation_Date DATE,
59 X_Disable_Date DATE,
60 X_Attribute_Category VARCHAR2,
61 X_Attribute1 VARCHAR2,
62 X_Attribute2 VARCHAR2,
63 X_Attribute3 VARCHAR2,
64 X_Attribute4 VARCHAR2,
65 X_Attribute5 VARCHAR2,
66 X_Attribute6 VARCHAR2,
67 X_Attribute7 VARCHAR2,
68 X_Attribute8 VARCHAR2,
69 X_Attribute9 VARCHAR2,
70 X_Attribute10 VARCHAR2,
71 X_Attribute11 VARCHAR2,
72 X_Attribute12 VARCHAR2,
73 X_Attribute13 VARCHAR2,
74 X_Attribute14 VARCHAR2,
75 X_Attribute15 VARCHAR2,
76 X_Planning_Factor NUMBER,
77 X_Quantity_Related NUMBER,
78 X_So_Basis NUMBER,
79 X_Optional NUMBER,
80 X_Mutually_Exclusive_Options NUMBER,
81 X_Include_In_Cost_Rollup NUMBER,
82 X_Check_Atp NUMBER,
83 X_Required_To_Ship NUMBER,
84 X_Required_For_Revenue NUMBER,
85 X_Include_On_Ship_Docs NUMBER,
86 X_Include_On_Bill_Docs NUMBER,
87 X_Low_Quantity NUMBER,
88 X_High_Quantity NUMBER,
89 X_Acd_Type NUMBER,
90 X_Old_Component_Sequence_Id NUMBER,
91 X_Component_Sequence_Id IN OUT NOCOPY NUMBER,
92 X_Bill_Sequence_Id NUMBER,
93 X_Wip_Supply_Type NUMBER,
94 X_Pick_Components NUMBER,
95 X_Supply_Subinventory VARCHAR2,
96 X_Supply_Locator_Id NUMBER,
97 X_Operation_Lead_Time_Percent NUMBER,
98 X_Revised_Item_Sequence_Id NUMBER,
99 X_Cost_Factor NUMBER,
100 X_Bom_Item_Type NUMBER,
101 X_From_Unit_Number VARCHAR2,
102 X_To_Unit_Number VARCHAR2,
103 X_Enforce_Int_Requirements NUMBER DEFAULT NULL,
104 X_Auto_Request_Material VARCHAR2 DEFAULT NULL
105 ,X_Suggested_Vendor_Name VARCHAR2 DEFAULT NULL
106 ,X_Vendor_Id NUMBER DEFAULT NULL
107 ,X_Unit_Price NUMBER DEFAULT NULL
108 ,X_basis_type NUMBER
109 );
110
111 END BOM_INV_COMPS1_PKG;