PACKAGE: APPS.INVICXRF

Source

1 PACKAGE INVICXRF AUTHID CURRENT_USER as
2 /* $Header: INVICXRS.pls 115.0 99/07/16 10:53:22 porting ship $ */
3 
4 PROCEDURE Insert_Row   (X_Rowid 			OUT VARCHAR2,
5 			X_Customer_Item_Id		NUMBER,
6 			X_Inventory_Item_Id		NUMBER,
7 			X_Master_Organization_Id	NUMBER,
8 			X_Rank 				NUMBER,
9 			X_Inactive_Flag			VARCHAR2,
10 			X_Last_Update_Date		DATE,
11 			X_Last_Updated_By		NUMBER,
12 			X_Creation_Date			DATE,
13 			X_Created_By			NUMBER,
14 			X_Last_Update_Login		NUMBER,
15 			X_Attribute_Category		VARCHAR2,
16 			X_Attribute1			VARCHAR2,
17 			X_Attribute2			VARCHAR2,
18 			X_Attribute3			VARCHAR2,
19 			X_Attribute4			VARCHAR2,
20 			X_Attribute5			VARCHAR2,
21 			X_Attribute6			VARCHAR2,
22 			X_Attribute7			VARCHAR2,
23 			X_Attribute8			VARCHAR2,
24 			X_Attribute9			VARCHAR2,
25 			X_Attribute10			VARCHAR2,
26 			X_Attribute11			VARCHAR2,
27 			X_Attribute12			VARCHAR2,
28 			X_Attribute13			VARCHAR2,
29 			X_Attribute14			VARCHAR2,
30 			X_Attribute15			VARCHAR2
31 			);
32 
33 
34 PROCEDURE Lock_Row     (X_Rowid				VARCHAR2,
35 			X_Customer_Item_Id		NUMBER,
36 			X_Inventory_Item_Id		NUMBER,
37 			X_Master_Organization_Id	NUMBER,
38 			X_Rank 				NUMBER,
39 			X_Inactive_Flag			VARCHAR2,
40 			X_Last_Update_Date		DATE,
41 			X_Last_Updated_By		NUMBER,
42 			X_Creation_Date			DATE,
43 			X_Created_By			NUMBER,
44 			X_Last_Update_Login		NUMBER,
45 			X_Attribute_Category		VARCHAR2,
46 			X_Attribute1			VARCHAR2,
47 			X_Attribute2			VARCHAR2,
48 			X_Attribute3			VARCHAR2,
49 			X_Attribute4			VARCHAR2,
50 			X_Attribute5			VARCHAR2,
51 			X_Attribute6			VARCHAR2,
52 			X_Attribute7			VARCHAR2,
53 			X_Attribute8			VARCHAR2,
54 			X_Attribute9			VARCHAR2,
55 			X_Attribute10			VARCHAR2,
56 			X_Attribute11			VARCHAR2,
57 			X_Attribute12			VARCHAR2,
58 			X_Attribute13			VARCHAR2,
59 			X_Attribute14			VARCHAR2,
60 			X_Attribute15			VARCHAR2
61 			);
62 
63 
64 PROCEDURE Update_Row   (X_Rowid				VARCHAR2,
65 			X_Customer_Item_Id		NUMBER,
66 			X_Inventory_Item_Id		NUMBER,
67 			X_Master_Organization_Id	NUMBER,
68 			X_Rank 				NUMBER,
69 			X_Inactive_Flag			VARCHAR2,
70 			X_Last_Update_Date		DATE,
71 			X_Last_Updated_By		NUMBER,
72 			X_Creation_Date			DATE,
73 			X_Created_By			NUMBER,
74 			X_Last_Update_Login		NUMBER,
75 			X_Attribute_Category		VARCHAR2,
76 			X_Attribute1			VARCHAR2,
77 			X_Attribute2			VARCHAR2,
78 			X_Attribute3			VARCHAR2,
79 			X_Attribute4			VARCHAR2,
80 			X_Attribute5			VARCHAR2,
81 			X_Attribute6			VARCHAR2,
82 			X_Attribute7			VARCHAR2,
83 			X_Attribute8			VARCHAR2,
84 			X_Attribute9			VARCHAR2,
85 			X_Attribute10			VARCHAR2,
86 			X_Attribute11			VARCHAR2,
87 			X_Attribute12			VARCHAR2,
88 			X_Attribute13			VARCHAR2,
89 			X_Attribute14			VARCHAR2,
90 			X_Attribute15			VARCHAR2
91 			);
92 
93 
94 PROCEDURE CHECK_UNIQUE (X_Rowid VARCHAR2,
95 			X_Customer_Item_Id NUMBER,
96 			X_Inventory_Item_Id NUMBER,
97 			X_Master_Organization_Id NUMBER);
98 
99 
100 PROCEDURE CHECK_UNIQUE_RANK (X_Rowid VARCHAR2,
101 			     X_Customer_Item_Id NUMBER,
102 			     X_Master_Organization_Id NUMBER,
103 			     X_Rank NUMBER);
104 
105 
106 END INVICXRF;