[Home] [Help]
PACKAGE: APPS.CSP_REQUIREMENT_LINES_PUB
Source
1 PACKAGE CSP_REQUIREMENT_LINES_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspprqls.pls 120.1 2010/12/03 23:27:19 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_Requirement_Lines_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:RQ_Rec_Type
16 -- -------------------------------------------------------
17 -- Required:
18 -- Defaults:
19 -- Note: This is automatic generated record definition, it includes all columns
20 -- defined in the table, developer must manually add or delete some of the attributes.
21 --
22 -- End of Comments
23
24 TYPE RQL_Rec_Type IS RECORD
25 (
26 ROW_ID ROWID := FND_API.G_MISS_CHAR,
27 REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
28 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29 CREATION_DATE DATE := FND_API.G_MISS_DATE,
30 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33 REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35 UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36 REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37 SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38 LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39 REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40 SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41 SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42 ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43 ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44 RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45 LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46 ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47 ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48 ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49 SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67 SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68 SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69 SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70 SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71 SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72 SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73 SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74 SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75 SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77 SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79 SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80 SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 SEGMENT20 VARCHAR2(240) := FND_API.G_MISS_CHAR
88 );
89
90 G_MISS_RQL_REC RQL_Rec_Type;
91 TYPE RQL_Tbl_Type IS TABLE OF RQL_Rec_Type
92 INDEX BY BINARY_INTEGER;
93 G_MISS_RQL_TBL RQL_Tbl_Type;
94
95 TYPE RQL_sort_rec_type IS RECORD
96 (
97 -- Please define your own sort by record here.
98 REQUIREMENT_LINE_ID NUMBER := NULL
99 );
100
101 -- *******************************************************
102 -- Start of Comments
103 -- *******************************************************
104 -- API Name: Create_requirement_lines
105 -- Type : Public
106 -- Pre-Req :
107 -- Parameters:
108 -- IN
109 -- p_api_version_number IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- P_RQL_Rec IN RQL_Rec_Type Required
113 --
114 -- OUT:
115 -- x_return_status OUT NOCOPY VARCHAR2
116 -- x_msg_count OUT NOCOPY NUMBER
117 -- x_msg_data OUT NOCOPY VARCHAR2
118 -- Version : Current version 2.0
119 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
120 -- and basic operation, developer must manually add parameters and business logic as necessary.
121 --
122 -- End of Comments
123 --
124 PROCEDURE Create_requirement_lines(
125 P_Api_Version_Number IN NUMBER,
126 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128 P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
129 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
130 X_REQUIREMENT_LINE_Tbl OUT NOCOPY RQL_Tbl_type,
131 X_Return_Status OUT NOCOPY VARCHAR2,
132 X_Msg_Count OUT NOCOPY NUMBER,
133 X_Msg_Data OUT NOCOPY VARCHAR2
134 );
135
136 -- *******************************************************
137 -- Start of Comments
138 -- *******************************************************
139 -- API Name: Update_requirement_lines
140 -- Type : Public
141 -- Pre-Req :
142 -- Parameters:
143 -- IN
144 -- p_api_version_number IN NUMBER Required
145 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147 -- P_RQL_Rec IN RQL_Rec_Type Required
148 --
149 -- OUT:
150 -- x_return_status OUT NOCOPY VARCHAR2
151 -- x_msg_count OUT NOCOPY NUMBER
152 -- x_msg_data OUT NOCOPY VARCHAR2
153 -- Version : Current version 2.0
154 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
155 -- and basic operation, developer must manually add parameters and business logic as necessary.
156 --
157 -- End of Comments
158 --
159 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
160 PROCEDURE Update_requirement_lines(
161 P_Api_Version_Number IN NUMBER,
162 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
163 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
164 P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
165 X_Return_Status OUT NOCOPY VARCHAR2,
166 X_Msg_Count OUT NOCOPY NUMBER,
167 X_Msg_Data OUT NOCOPY VARCHAR2
168 );
169
170 -- *******************************************************
171 -- Start of Comments
172 -- *******************************************************
173 -- API Name: Delete_requirement_lines
174 -- Type : Public
175 -- Pre-Req :
176 -- Parameters:
177 -- IN
178 -- p_api_version_number IN NUMBER Required
179 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181 -- P_RQL_Rec IN RQL_Rec_Type Required
182 --
183 -- OUT:
184 -- x_return_status OUT NOCOPY VARCHAR2
185 -- x_msg_count OUT NOCOPY NUMBER
186 -- x_msg_data OUT NOCOPY VARCHAR2
187 -- Version : Current version 2.0
188 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
189 -- and basic operation, developer must manually add parameters and business logic as necessary.
190 --
191 -- End of Comments
192 --
193 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
194 -- The Master delete procedure may not be needed depends on different business requirements.
195 PROCEDURE Delete_requirement_lines(
196 P_Api_Version_Number IN NUMBER,
197 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199 P_RQL_Tbl IN RQL_Tbl_Type,
200 X_Return_Status OUT NOCOPY VARCHAR2,
201 X_Msg_Count OUT NOCOPY NUMBER,
202 X_Msg_Data OUT NOCOPY VARCHAR2
203 );
204
205 END CSP_REQUIREMENT_LINES_PUB; -- Package spec
206