[Home] [Help]
PACKAGE: APPS.OKE_DELIVERABLE_PVT
Source
1 PACKAGE OKE_DELIVERABLE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVDELS.pls 115.22 2003/10/22 23:52:30 jxtang ship $ */
3
4 -- GLOBAL DATA STRUCTURES
5
6 TYPE del_rec_type IS RECORD(
7 DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
8 DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,
9 PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10 TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11 ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12 K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13 K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14 DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15 STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16 PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17 SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18 SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19 SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20 SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21 DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22 INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23 DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24 IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25 WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26 SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27 START_DATE DATE := OKE_API.G_MISS_DATE,
28 END_DATE DATE := OKE_API.G_MISS_DATE,
29 PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30 CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31 UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32 UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33 QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34 COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35 SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36 DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37 BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38 BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39 DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40 COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41 AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42 CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43 READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44 NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45 READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46 MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47 PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48 PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49 PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50 SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51 UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52 NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53 SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54 CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55 INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56 INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57 LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58 CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59 EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60 INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61 PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62 AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63 DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64 FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65 ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66 SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67 DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68 TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69 CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70 DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71 EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72 EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73 EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74 CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75 CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76 LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77 LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78 LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79 ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80 ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81 ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82 ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83 ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84 ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85 ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86 ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87 ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88 ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89 ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90 ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91 ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92 ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93 ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94 ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95 DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96 COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97 SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98 WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99 WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100 VOLUME NUMBER := OKE_API.G_MISS_NUM,
101 VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102 EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103 EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104 EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105 DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106 RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107 RATE_DATE DATE := OKE_API.G_MISS_DATE,
108 EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,
109 REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,
110 PO_CATEGORY_ID NUMBER := OKE_API.G_MISS_NUM);
111
112 TYPE del_tbl_type IS TABLE OF del_rec_type
113 INDEX BY BINARY_INTEGER;
114
115 -- GLOBAL MESSAGE CONSTANTS
116
117 G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
118
119 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
120 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
121
122 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
123
124 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
125 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
127 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
129 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
130 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_DELIVERABLE_PVT';
131 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
132 G_FALSE CONSTANT VARCHAR2(1) := 'F';
133
134 -- Procedures and functions
135
136 PROCEDURE insert_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_del_rec IN del_rec_type,
143 x_del_rec OUT NOCOPY del_rec_type);
144
145 PROCEDURE insert_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_del_tbl IN del_tbl_type,
152 x_del_tbl OUT NOCOPY del_tbl_type);
153
154 PROCEDURE update_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_del_rec IN del_rec_type,
161 x_del_rec OUT NOCOPY del_rec_type);
162
163 PROCEDURE update_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169
170 p_del_tbl IN del_tbl_type,
171 x_del_tbl OUT NOCOPY del_tbl_type);
172
173 PROCEDURE delete_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_del_rec IN del_rec_type);
180
181 PROCEDURE delete_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_del_tbl IN del_tbl_type);
188
189 PROCEDURE validate_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_del_rec IN del_rec_type);
196
197 PROCEDURE validate_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_del_tbl IN del_tbl_type);
204
205
206
207 PROCEDURE lock_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_del_rec IN del_rec_type);
214
215
216
217 PROCEDURE lock_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_del_tbl IN del_tbl_type);
224
225 PROCEDURE add_language;
226
227 FUNCTION check_dependency(p_deliverable_id Number) RETURN BOOLEAN;
228
229 END OKE_DELIVERABLE_PVT;
230