[Home] [Help]
PACKAGE: APPS.CHV_SCHEDULE_ITEMS_PKG_S1
Source
1 PACKAGE CHV_SCHEDULE_ITEMS_PKG_S1 AUTHID CURRENT_USER as
2 /* $Header: CHVSITMS.pls 115.0 99/07/17 01:31:41 porting ship $ */
3
4 /*===========================================================================
5 PROCEDURE NAME: Lock_row()
6
7 DESCRIPTION: Table Handler to Lock the CHV_SCHEDULE_ITEMS table.
8
9 PARAMETERS: See Below
10
11 DESIGN REFERENCES:
12
13
14 ALGORITHM:
15
16 NOTES:
17
18 OPEN ISSUES:
19
20 CLOSED ISSUES:
21
22 CHANGE HISTORY: SRUMALLA 01/29/96 Created
23
24 ===========================================================================*/
25
26 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
27 X_Schedule_Id NUMBER,
28 X_Schedule_Item_Id NUMBER,
29 X_Organization_Id NUMBER,
30 X_Item_Id NUMBER,
31 X_Item_Planning_Method VARCHAR2,
32 X_PO_Header_Id NUMBER,
33 X_PO_Line_Id NUMBER,
34 X_Rebuild_Flag VARCHAR2,
35 X_Item_Confirm_Status VARCHAR2,
36 X_Starting_Cum_Quantity NUMBER,
37 X_Starting_Auth_Quantity NUMBER,
38 X_Starting_Cum_Qty_Primary NUMBER,
39 X_Starting_Auth_Qty_Primary NUMBER,
40 X_Last_Receipt_Transaction_Id NUMBER,
41 X_Purchasing_Unit_Of_Measure VARCHAR2,
42 X_Primary_Unit_Of_Measure VARCHAR2,
43 X_Attribute_CaTegory VARCHAR2,
44 X_Attribute1 VARCHAR2,
45 X_Attribute2 VARCHAR2,
46 X_Attribute3 VARCHAR2,
47 X_Attribute4 VARCHAR2,
48 X_Attribute5 VARCHAR2,
49 X_Attribute6 VARCHAR2,
50 X_Attribute7 VARCHAR2,
51 X_Attribute8 VARCHAR2,
52 X_Attribute9 VARCHAR2,
53 X_Attribute10 VARCHAR2,
54 X_Attribute11 VARCHAR2,
55 X_Attribute12 VARCHAR2,
56 X_Attribute13 VARCHAR2,
57 X_Attribute14 VARCHAR2,
58 X_Attribute15 VARCHAR2
59 );
60 /*===========================================================================
61 PROCEDURE NAME: Update_row()
62
63 DESCRIPTION: Table Handler to update the Supplier Scheduling
64 CHV_SCHEDULE_ITEMS table.
65
66 PARAMETERS: See Below
67
68 DESIGN REFERENCES:
69
70
71 ALGORITHM:
72
73 NOTES:
74
75 OPEN ISSUES:
76
77 CLOSED ISSUES:
78
79 CHANGE HISTORY: SRUMALLA 01/29/96 Created
80
81 ===========================================================================*/
82 PROCEDURE Update_Row(
83 X_Rowid VARCHAR2,
84 X_Item_Confirm_Status VARCHAR2,
85 X_Rebuild_Flag VARCHAR2,
86 X_Last_Update_Date DATE,
87 X_Last_Updated_By NUMBER,
88 X_Last_Update_Login NUMBER,
89 X_Attribute_Category VARCHAR2,
90 X_Attribute1 VARCHAR2,
91 X_Attribute2 VARCHAR2,
92 X_Attribute3 VARCHAR2,
93 X_Attribute4 VARCHAR2,
94 X_Attribute5 VARCHAR2,
95 X_Attribute6 VARCHAR2,
96 X_Attribute7 VARCHAR2,
97 X_Attribute8 VARCHAR2,
98 X_Attribute9 VARCHAR2,
99 X_Attribute10 VARCHAR2,
100 X_Attribute11 VARCHAR2,
101 X_Attribute12 VARCHAR2,
102 X_Attribute13 VARCHAR2,
103 X_Attribute14 VARCHAR2,
104 X_Attribute15 VARCHAR2
105 );
106
107 /*==========================================================================
108 PROCEDURE NAME: Delete_Row1()
109
110 DESCRIPTION: Contains the Table handler for Supplier Scheduling
111 to delete CHV_SCHEDULE_ITEMS table.
112
113 PARAMETERS: See Below
114
115 DESIGN REFERENCES:
116
117
118 ALGORITHM:
119
120 NOTES:
121
122 OPEN ISSUES:
123
124 CLOSED ISSUES:
125
126 CHANGE HISTORY: SRUMALLA 01/29/96 Created
127
128 ===========================================================================*/
129 PROCEDURE delete_row1(X_RowId VARCHAR2,
130 X_Schedule_Item_Id NUMBER,
131 X_Schedule_Id NUMBER
132 );
133
134 /*==========================================================================
135 PROCEDURE NAME: Delete_Row2()
136
137 DESCRIPTION: Contains the Table handler for Supplier Scheduling
138 to delete CHV_SCHEDULE_ITEMS table.
139
140 PARAMETERS: See Below
141
142 DESIGN REFERENCES:
143
144
145 ALGORITHM:
146
147 NOTES:
148
149 OPEN ISSUES:
150
151 CLOSED ISSUES:
152
153 CHANGE HISTORY: SRUMALLA 01/29/96 Created
154
155 ===========================================================================*/
156
157 PROCEDURE delete_row2(X_Schedule_Id NUMBER
158 );
159 END CHV_SCHEDULE_ITEMS_PKG_S1;