[Home] [Help]
PACKAGE: APPS.CHV_SCH_HEADERS_PKG_S1
Source
1 PACKAGE CHV_SCH_HEADERS_PKG_S1 AUTHID CURRENT_USER as
2 /* $Header: CHVSHDRS.pls 115.0 99/07/17 01:31:08 porting ship $ */
3
4 /*===========================================================================
5 PROCEDURE NAME: Lock_row()
6
7 DESCRIPTION: Table Handler to Lock the CHV_SCHEDULE_HEADERS 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_Vendor_Id NUMBER,
29 X_Vendor_Site_Id NUMBER,
30 X_Schedule_Type VARCHAR2,
31 X_Schedule_Subtype VARCHAR2,
32 X_Schedule_Num VARCHAR2,
33 X_Schedule_Revision NUMBER,
34 X_Schedule_Horizon_Start DATE,
35 X_Schedule_Horizon_End DATE,
36 X_Bucket_Pattern_Id NUMBER,
37 X_Schedule_Owner_Id NUMBER,
38 X_Organization_Id NUMBER,
39 X_MPS_Schedule_Designator VARCHAR2,
40 X_MRP_Compile_Designator VARCHAR2,
41 X_DRP_Compile_Designator VARCHAR2,
42 X_Schedule_Status VARCHAR2,
43 X_Inquiry_Flag VARCHAR2,
44 X_Attribute_Category VARCHAR2,
45 X_Attribute1 VARCHAR2,
46 X_Attribute2 VARCHAR2,
47 X_Attribute3 VARCHAR2,
48 X_Attribute4 VARCHAR2,
49 X_Attribute5 VARCHAR2,
50 X_Attribute6 VARCHAR2,
51 X_Attribute7 VARCHAR2,
52 X_Attribute8 VARCHAR2,
53 X_Attribute9 VARCHAR2,
54 X_Attribute10 VARCHAR2,
55 X_Attribute11 VARCHAR2,
56 X_Attribute12 VARCHAR2,
57 X_Attribute13 VARCHAR2,
58 X_Attribute14 VARCHAR2,
59 X_Attribute15 VARCHAR2
60 );
61
62 /*===========================================================================
63 PROCEDURE NAME: Update_row()
64
65 DESCRIPTION: Table Handler to update the Supplier Scheduling
66 CHV_SCHEDULE_HEADERS table.
67
68 PARAMETERS: See Below
69
70 DESIGN REFERENCES:
71
72
73 ALGORITHM:
74
75 NOTES:
76
77 OPEN ISSUES:
78
79 CLOSED ISSUES:
80
81 CHANGE HISTORY: SRUMALLA 01/29/96 Created
82
83 ===========================================================================*/
84
85 PROCEDURE Update_Row(
86 X_Rowid VARCHAR2,
87 X_Schedule_Num VARCHAR2,
88 X_Schedule_Status VARCHAR2,
89 X_Last_Update_Date DATE,
90 X_Last_Updated_By NUMBER,
91 X_Last_Update_Login NUMBER,
92 X_Attribute_Category VARCHAR2,
93 X_Attribute1 VARCHAR2,
94 X_Attribute2 VARCHAR2,
95 X_Attribute3 VARCHAR2,
96 X_Attribute4 VARCHAR2,
97 X_Attribute5 VARCHAR2,
98 X_Attribute6 VARCHAR2,
99 X_Attribute7 VARCHAR2,
100 X_Attribute8 VARCHAR2,
101 X_Attribute9 VARCHAR2,
102 X_Attribute10 VARCHAR2,
103 X_Attribute11 VARCHAR2,
104 X_Attribute12 VARCHAR2,
105 X_Attribute13 VARCHAR2,
106 X_Attribute14 VARCHAR2,
107 X_Attribute15 VARCHAR2
108 );
109
110 /*==========================================================================
111 PROCEDURE NAME: Delete_Row()
112
113 DESCRIPTION: Contains the Table handler for Supplier Scheduling
114 to delete CHV_SCHEDULE_HEADERS table.
115
116 PARAMETERS: See Below
117
118 DESIGN REFERENCES:
119
120
121 ALGORITHM:
122
123 NOTES:
124
125 OPEN ISSUES:
126
127 CLOSED ISSUES:
128
129 CHANGE HISTORY: SRUMALLA 01/29/96 Created
130
131 ===========================================================================*/
132
133 PROCEDURE delete_row(X_RowId VARCHAR2,
134 X_Schedule_Id NUMBER
135 );
136 END CHV_SCH_HEADERS_PKG_S1;