[Home] [Help]
PACKAGE: APPS.OKE_CLE_PVT
Source
1 PACKAGE OKE_CLE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVCLES.pls 115.23 2002/11/20 20:39:38 who ship $ */
3
4 -- GLOBAL DATA STRUCTURES
5
6 TYPE cle_rec_type IS RECORD(
7
8 K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
9 PARENT_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
10 PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
11 TASK_ID NUMBER := OKE_API.G_MISS_NUM,
12 BILLING_METHOD_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
13 INVENTORY_ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
14 DELIVERY_ORDER_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
15 SPLITED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
16 PRIORITY_CODE OKE_K_LINES.PRIORITY_CODE%TYPE := OKE_API.G_MISS_CHAR,
17 CUSTOMER_ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
18 CUSTOMER_ITEM_NUMBER OKE_K_LINES.CUSTOMER_ITEM_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
19 LINE_QUANTITY OKE_K_LINES.LINE_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
20 DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
21 PROPOSAL_DUE_DATE VARCHAR2(80) := OKE_API.G_MISS_CHAR,
22 UNIT_PRICE OKE_K_LINES.UNIT_PRICE%TYPE := OKE_API.G_MISS_NUM,
23 UOM_CODE OKE_K_LINES.UOM_CODE%TYPE := OKE_API.G_MISS_CHAR,
24 LINE_VALUE NUMBER := OKE_API.G_MISS_NUM,
25 LINE_VALUE_TOTAL NUMBER := OKE_API.G_MISS_NUM,
26 UNDEF_UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
27 UNDEF_LINE_VALUE NUMBER := OKE_API.G_MISS_NUM,
28 UNDEF_LINE_VALUE_TOTAL NUMBER := OKE_API.G_MISS_NUM,
29 END_DATE DATE := OKE_API.G_MISS_DATE,
30 BILLABLE_FLAG OKE_K_LINES.BILLABLE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
31 SHIPPABLE_FLAG OKE_K_LINES.SHIPPABLE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
32 SUBCONTRACTED_FLAG OKE_K_LINES.SUBCONTRACTED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
33 COMPLETED_FLAG OKE_K_LINES.COMPLETED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
34 NSP_FLAG OKE_K_LINES.NSP_FLAG%TYPE := OKE_API.G_MISS_CHAR,
35 APP_CODE OKE_K_LINES.APP_CODE%TYPE := OKE_API.G_MISS_CHAR,
36 AS_OF_DATE OKE_K_LINES.AS_OF_DATE%TYPE := OKE_API.G_MISS_DATE,
37 AUTHORITY OKE_K_LINES.AUTHORITY%TYPE := OKE_API.G_MISS_CHAR,
38 COUNTRY_OF_ORIGIN_CODE OKE_K_LINES.COUNTRY_OF_ORIGIN_CODE%TYPE := OKE_API.G_MISS_CHAR,
39 DROP_SHIPPED_FLAG OKE_K_LINES.DROP_SHIPPED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
40 CUSTOMER_APPROVAL_REQ_FLAG OKE_K_LINES.CUSTOMER_APPROVAL_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
41 DATE_MATERIAL_REQ OKE_K_LINES.DATE_MATERIAL_REQ%TYPE := OKE_API.G_MISS_DATE,
42 INSPECTION_REQ_FLAG OKE_K_LINES.INSPECTION_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
43 INTERIM_RPT_REQ_FLAG OKE_K_LINES.INTERIM_RPT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
44 SUBJ_A133_FLAG OKE_K_LINES.SUBJ_A133_FLAG%TYPE := OKE_API.G_MISS_CHAR,
45 EXPORT_FLAG OKE_K_LINES.EXPORT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
46 CFE_REQ_FLAG OKE_K_LINES.CFE_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
47 COP_REQUIRED_FLAG OKE_K_LINES.COP_REQUIRED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
48 EXPORT_LICENSE_NUM OKE_K_LINES.EXPORT_LICENSE_NUM%TYPE := OKE_API.G_MISS_CHAR,
49 EXPORT_LICENSE_RES OKE_K_LINES.EXPORT_LICENSE_RES%TYPE := OKE_API.G_MISS_CHAR,
50 COPIES_REQUIRED OKE_K_LINES.COPIES_REQUIRED%TYPE := OKE_API.G_MISS_NUM,
51 CDRL_CATEGORY OKE_K_LINES.CDRL_CATEGORY%TYPE := OKE_API.G_MISS_CHAR,
52 DATA_ITEM_NAME OKE_K_LINES.DATA_ITEM_NAME%TYPE := OKE_API.G_MISS_CHAR,
53 DATA_ITEM_SUBTITLE OKE_K_LINES.DATA_ITEM_SUBTITLE%TYPE := OKE_API.G_MISS_CHAR,
54 DATE_OF_FIRST_SUBMISSION OKE_K_LINES.DATE_OF_FIRST_SUBMISSION%TYPE := OKE_API.G_MISS_DATE,
55 FREQUENCY OKE_K_LINES.FREQUENCY%TYPE := OKE_API.G_MISS_CHAR,
56 REQUIRING_OFFICE OKE_K_LINES.REQUIRING_OFFICE%TYPE := OKE_API.G_MISS_CHAR,
57 DCAA_AUDIT_REQ_FLAG OKE_K_LINES.DCAA_AUDIT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
58 DEFINITIZED_FLAG OKE_K_LINES.DEFINITIZED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
59 COST_OF_MONEY OKE_K_LINES.COST_OF_MONEY%TYPE := OKE_API.G_MISS_CHAR,
60 BILL_UNDEFINITIZED_FLAG OKE_K_LINES.BILL_UNDEFINITIZED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
61 NSN_NUMBER OKE_K_LINES.NSN_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
62 NTE_WARNING_FLAG OKE_K_LINES.NTE_WARNING_FLAG%TYPE := OKE_API.G_MISS_CHAR,
63 DISCOUNT_FOR_PAYMENT OKE_K_LINES.DISCOUNT_FOR_PAYMENT%TYPE := OKE_API.G_MISS_NUM,
64 FINANCIAL_CTRL_FLAG OKE_K_LINES.FINANCIAL_CTRL_FLAG%TYPE := OKE_API.G_MISS_CHAR,
65 C_SCS_FLAG OKE_K_LINES.C_SCS_FLAG%TYPE := OKE_API.G_MISS_CHAR,
66 C_SSR_FLAG OKE_K_LINES.C_SSR_FLAG%TYPE := OKE_API.G_MISS_CHAR,
67 PREPAYMENT_AMOUNT OKE_K_LINES.PREPAYMENT_AMOUNT%TYPE := OKE_API.G_MISS_NUM,
68 PREPAYMENT_PERCENTAGE OKE_K_LINES.PREPAYMENT_PERCENTAGE%TYPE := OKE_API.G_MISS_NUM,
69 PROGRESS_PAYMENT_FLAG OKE_K_LINES.PROGRESS_PAYMENT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
70 PROGRESS_PAYMENT_LIQ_RATE OKE_K_LINES.PROGRESS_PAYMENT_LIQ_RATE%TYPE := OKE_API.G_MISS_NUM,
71 PROGRESS_PAYMENT_RATE OKE_K_LINES.PROGRESS_PAYMENT_RATE%TYPE := OKE_API.G_MISS_NUM,
72 AWARD_FEE OKE_K_LINES.AWARD_FEE%TYPE := OKE_API.G_MISS_NUM,
73 AWARD_FEE_POOL_AMOUNT OKE_K_LINES.AWARD_FEE_POOL_AMOUNT%TYPE := OKE_API.G_MISS_NUM,
74 BASE_FEE OKE_K_LINES.BASE_FEE%TYPE := OKE_API.G_MISS_NUM,
75 CEILING_COST OKE_K_LINES.CEILING_COST%TYPE := OKE_API.G_MISS_NUM,
76 CEILING_PRICE OKE_K_LINES.CEILING_PRICE%TYPE := OKE_API.G_MISS_NUM,
77 LABOR_COST_INDEX OKE_K_LINES.LABOR_COST_INDEX%TYPE := OKE_API.G_MISS_CHAR,
78 MATERIAL_COST_INDEX OKE_K_LINES.MATERIAL_COST_INDEX%TYPE := OKE_API.G_MISS_CHAR,
79 CUSTOMERS_PERCENT_IN_ORDER OKE_K_LINES.CUSTOMERS_PERCENT_IN_ORDER%TYPE := OKE_API.G_MISS_NUM,
80 COST_OVERRUN_SHARE_RATIO OKE_K_LINES.COST_OVERRUN_SHARE_RATIO%TYPE := OKE_API.G_MISS_CHAR,
81 COST_UNDERRUN_SHARE_RATIO OKE_K_LINES.COST_UNDERRUN_SHARE_RATIO%TYPE := OKE_API.G_MISS_CHAR,
82 DATE_OF_PRICE_REDETERMIN OKE_K_LINES.DATE_OF_PRICE_REDETERMIN%TYPE := OKE_API.G_MISS_DATE,
83 ESTIMATED_TOTAL_QUANTITY OKE_K_LINES.ESTIMATED_TOTAL_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
84 FEE_AJT_FORMULA OKE_K_LINES.FEE_AJT_FORMULA%TYPE := OKE_API.G_MISS_CHAR,
85 FINAL_FEE OKE_K_LINES.FINAL_FEE%TYPE := OKE_API.G_MISS_NUM,
86 FINAL_PFT_AJT_FORMULA OKE_K_LINES.FINAL_PFT_AJT_FORMULA%TYPE := OKE_API.G_MISS_CHAR,
87 FIXED_FEE OKE_K_LINES.FIXED_FEE%TYPE := OKE_API.G_MISS_NUM,
88 FIXED_QUANTITY OKE_K_LINES.FIXED_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
89 INITIAL_FEE OKE_K_LINES.INITIAL_FEE%TYPE := OKE_API.G_MISS_NUM,
90 INITIAL_PRICE OKE_K_LINES.INITIAL_PRICE%TYPE := OKE_API.G_MISS_NUM,
91 LEVEL_OF_EFFORT_HOURS OKE_K_LINES.LEVEL_OF_EFFORT_HOURS%TYPE := OKE_API.G_MISS_NUM,
92 LINE_LIQUIDATION_RATE OKE_K_LINES.LINE_LIQUIDATION_RATE%TYPE := OKE_API.G_MISS_NUM,
93 MAXIMUM_FEE OKE_K_LINES.MAXIMUM_FEE%TYPE := OKE_API.G_MISS_NUM,
94 MAXIMUM_QUANTITY OKE_K_LINES.MAXIMUM_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
95 MINIMUM_FEE OKE_K_LINES.MINIMUM_FEE%TYPE := OKE_API.G_MISS_NUM,
96 MINIMUM_QUANTITY OKE_K_LINES.MINIMUM_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
97 NUMBER_OF_OPTIONS OKE_K_LINES.NUMBER_OF_OPTIONS%TYPE := OKE_API.G_MISS_NUM,
98 REVISED_PRICE OKE_K_LINES.REVISED_PRICE%TYPE := OKE_API.G_MISS_NUM,
99 TARGET_COST OKE_K_LINES.TARGET_COST%TYPE := OKE_API.G_MISS_NUM,
100 TARGET_DATE_DEFINITIZE OKE_K_LINES.TARGET_DATE_DEFINITIZE%TYPE := OKE_API.G_MISS_DATE,
101 TARGET_FEE OKE_K_LINES.TARGET_FEE%TYPE := OKE_API.G_MISS_NUM,
102 TARGET_PRICE OKE_K_LINES.TARGET_PRICE%TYPE := OKE_API.G_MISS_NUM,
103 TOTAL_ESTIMATED_COST OKE_K_LINES.TOTAL_ESTIMATED_COST%TYPE := OKE_API.G_MISS_NUM,
104 COST_OF_SALE_RATE OKE_K_LINES.COST_OF_SALE_RATE%TYPE := OKE_API.G_MISS_NUM,
105 CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
106 CREATION_DATE OKE_K_LINES.CREATION_DATE%TYPE := OKE_API.G_MISS_DATE,
107 LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
108 LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
109 LAST_UPDATE_DATE OKE_K_LINES.LAST_UPDATE_DATE%TYPE := OKE_API.G_MISS_DATE);
110
111 TYPE cle_tbl_type IS TABLE OF cle_rec_type
112 INDEX BY BINARY_INTEGER;
113
114 -- GLOBAL MESSAGE CONSTANTS
115
116 G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
117
118 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
119 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
120
121 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
122
123 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
124 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
125 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
126 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
127 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
128 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
129 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CLE_PVT';
130 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
131
132 -- Procedures and functions
133
134 PROCEDURE insert_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_cle_rec IN cle_rec_type,
141 x_cle_rec OUT NOCOPY cle_rec_type);
142
143 PROCEDURE insert_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_cle_tbl IN cle_tbl_type,
150 x_cle_tbl OUT NOCOPY cle_tbl_type);
151
152 PROCEDURE update_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_cle_rec IN cle_rec_type,
159 x_cle_rec OUT NOCOPY cle_rec_type);
160
161 PROCEDURE update_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167
168 p_cle_tbl IN cle_tbl_type,
169 x_cle_tbl OUT NOCOPY cle_tbl_type);
170
171 PROCEDURE delete_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_cle_rec IN cle_rec_type);
178
179 PROCEDURE delete_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_cle_tbl IN cle_tbl_type);
186
187 PROCEDURE validate_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_cle_rec IN cle_rec_type);
194
195 PROCEDURE validate_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_cle_tbl IN cle_tbl_type);
202
203 END OKE_CLE_PVT;
204