[Home] [Help]
PACKAGE: APPS.OKE_IMPORT_CONTRACT_PUB
Source
1 PACKAGE OKE_IMPORT_CONTRACT_PUB AS
2 /* $Header: OKEPIMPS.pls 120.2 2006/03/27 15:51:15 ifilimon noship $ */
3 /*#
4 * This is the public interface to import project contracts.
5 * @rep:metalink 234864.1 See OracleMetaLink bulletin 234864.1
6 * @rep:scope public
7 * @rep:product OKE
8 * @rep:displayname Create Project Contract
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY OKE_CONTRACT
11 */
12
13 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_IMPORT_CONTRACT_PUB';
14 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
15
16
17
18 SUBTYPE del_rec_type IS OKE_CONTRACT_PUB.del_rec_type;
19
20
21 TYPE chr_rec_type IS RECORD(
22 k_header_id NUMBER := OKE_API.G_MISS_NUM,
23 program_id NUMBER := OKE_API.G_MISS_NUM,
24 project_id NUMBER := OKE_API.G_MISS_NUM,
25 boa_id NUMBER := OKE_API.G_MISS_NUM,
26 k_type_code OKE_K_HEADERS.K_TYPE_CODE%TYPE := OKE_API.G_MISS_CHAR,
27 priority_code OKE_K_HEADERS.PRIORITY_CODE%TYPE := OKE_API.G_MISS_CHAR,
28 prime_k_alias OKE_K_HEADERS.PRIME_K_ALIAS%TYPE := OKE_API.G_MISS_CHAR,
29 prime_k_number OKE_K_HEADERS.PRIME_K_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
30 authorize_date OKE_K_HEADERS.AUTHORIZE_DATE%TYPE := OKE_API.G_MISS_DATE,
31 authorizing_reason OKE_K_HEADERS.AUTHORIZING_REASON%TYPE := OKE_API.G_MISS_CHAR,
32 award_cancel_date OKE_K_HEADERS.AWARD_CANCEL_DATE%TYPE := OKE_API.G_MISS_DATE,
33 award_date OKE_K_HEADERS.AWARD_DATE%TYPE := OKE_API.G_MISS_DATE,
34 date_definitized OKE_K_HEADERS.DATE_DEFINITIZED%TYPE := OKE_API.G_MISS_DATE,
35 date_issued OKE_K_HEADERS.DATE_ISSUED%TYPE := OKE_API.G_MISS_DATE,
36 date_negotiated OKE_K_HEADERS.DATE_NEGOTIATED%TYPE := OKE_API.G_MISS_DATE,
37 date_received OKE_K_HEADERS.DATE_RECEIVED%TYPE := OKE_API.G_MISS_DATE,
38 date_sign_by_contractor OKE_K_HEADERS.DATE_SIGN_BY_CONTRACTOR%TYPE := OKE_API.G_MISS_DATE,
39 date_sign_by_customer OKE_K_HEADERS.DATE_SIGN_BY_CUSTOMER%TYPE := OKE_API.G_MISS_DATE,
40 faa_approve_date OKE_K_HEADERS.FAA_APPROVE_DATE%TYPE := OKE_API.G_MISS_DATE,
41 faa_reject_date OKE_K_HEADERS.FAA_REJECT_DATE%TYPE := OKE_API.G_MISS_DATE,
42 booked_flag OKE_K_HEADERS.BOOKED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
43 open_flag OKE_K_HEADERS.OPEN_FLAG%TYPE := OKE_API.G_MISS_CHAR,
44 cfe_flag OKE_K_HEADERS.CFE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
45 vat_code OKE_K_HEADERS.VAT_CODE%TYPE := OKE_API.G_MISS_CHAR,
46 country_of_origin_code OKE_K_HEADERS.COUNTRY_OF_ORIGIN_CODE%TYPE := OKE_API.G_MISS_CHAR,
47 export_flag OKE_K_HEADERS.EXPORT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
48 human_subject_flag OKE_K_HEADERS.HUMAN_SUBJECT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
49 cqa_flag OKE_K_HEADERS.CQA_FLAG%TYPE := OKE_API.G_MISS_CHAR,
50 interim_rpt_req_flag OKE_K_HEADERS.INTERIM_RPT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
51 no_competition_authorize OKE_K_HEADERS.NO_COMPETITION_AUTHORIZE%TYPE := OKE_API.G_MISS_CHAR,
52 penalty_clause_flag OKE_K_HEADERS.PENALTY_CLAUSE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
53 product_line_code OKE_K_HEADERS.PRODUCT_LINE_CODE%TYPE := OKE_API.G_MISS_CHAR,
54 reporting_flag OKE_K_HEADERS.REPORTING_FLAG%TYPE := OKE_API.G_MISS_CHAR,
55 sb_plan_req_flag OKE_K_HEADERS.SB_PLAN_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
56 sb_report_flag OKE_K_HEADERS.SB_REPORT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
57 nte_amount OKE_K_HEADERS.NTE_AMOUNT%TYPE := OKE_API.G_MISS_NUM,
58 nte_warning_flag OKE_K_HEADERS.NTE_WARNING_FLAG%TYPE := OKE_API.G_MISS_CHAR,
59 bill_without_def_flag OKE_K_HEADERS.BILL_WITHOUT_DEF_FLAG%TYPE := OKE_API.G_MISS_CHAR,
60 cas_flag OKE_K_HEADERS.CAS_FLAG%TYPE := OKE_API.G_MISS_CHAR,
61 classified_flag OKE_K_HEADERS.CLASSIFIED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
62 client_approve_req_flag OKE_K_HEADERS.CLIENT_APPROVE_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
63 cost_of_money OKE_K_HEADERS.COST_OF_MONEY%TYPE := OKE_API.G_MISS_CHAR,
64 dcaa_audit_req_flag OKE_K_HEADERS.DCAA_AUDIT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
65 cost_share_flag OKE_K_HEADERS.COST_SHARE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
66 oh_rates_final_flag OKE_K_HEADERS.OH_RATES_FINAL_FLAG%TYPE := OKE_API.G_MISS_CHAR,
67 prop_delivery_location OKE_K_HEADERS.PROP_DELIVERY_LOCATION%TYPE := OKE_API.G_MISS_CHAR,
68 prop_due_date_time OKE_K_HEADERS.PROP_DUE_DATE_TIME%TYPE := OKE_API.G_MISS_DATE,
69 prop_expire_date OKE_K_HEADERS.PROP_EXPIRE_DATE%TYPE := OKE_API.G_MISS_DATE,
70 copies_required OKE_K_HEADERS.COPIES_REQUIRED%TYPE := OKE_API.G_MISS_NUM,
71 sic_code OKE_K_HEADERS.SIC_CODE%TYPE := OKE_API.G_MISS_CHAR,
72 tech_data_wh_rate OKE_K_HEADERS.TECH_DATA_WH_RATE%TYPE := OKE_API.G_MISS_NUM,
73 progress_payment_flag OKE_K_HEADERS.PROGRESS_PAYMENT_FLAG%TYPE :=OKE_API.G_MISS_CHAR,
74 progress_payment_liq_rate NUMBER := OKE_API.G_MISS_NUM,
75 progress_payment_rate NUMBER :=OKE_API.G_MISS_NUM,
76 alternate_liquidation_rate NUMBER :=OKE_API.G_MISS_NUM,
77 prop_due_time OKE_K_HEADERS.prop_due_time%TYPE :=OKE_API.G_MISS_CHAR,
78 definitized_flag OKE_K_HEADERS.DEFINITIZED_FLAG%TYPE :=OKE_API.G_MISS_CHAR,
79 financial_ctrl_verified_flag OKE_K_HEADERS.FINANCIAL_CTRL_VERIFIED_FLAG%TYPE :=OKE_API.G_MISS_CHAR,
80 cost_of_sale_rate NUMBER :=OKE_API.G_MISS_NUM,
81 line_value_total NUMBER :=OKE_API.G_MISS_NUM,
82 undef_line_value_total NUMBER:=OKE_API.G_MISS_NUM,
83 owning_organization_id NUMBER := OKE_API.G_MISS_NUM,
84
85 -- this one is same as k_header_id
86 -- id NUMBER := OKE_API.G_MISS_NUM,
87
88 object_version_number NUMBER := OKE_API.G_MISS_NUM,
89 sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
90 chr_id_response NUMBER := OKE_API.G_MISS_NUM,
91 chr_id_award NUMBER := OKE_API.G_MISS_NUM,
92 chr_id_renewed NUMBER := OKE_API.G_MISS_NUM,
93 INV_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
94 sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKE_API.G_MISS_CHAR,
95 qcl_id NUMBER := OKE_API.G_MISS_NUM,
96 scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKE_API.G_MISS_CHAR,
97 contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
98 currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKE_API.G_MISS_CHAR,
99 contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKE_API.G_MISS_CHAR,
100 archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKE_API.G_MISS_CHAR,
101 deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKE_API.G_MISS_CHAR,
102 cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKE_API.G_MISS_CHAR,
103 pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKE_API.G_MISS_CHAR,
104 cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
105 short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKE_API.G_MISS_CHAR,
106 comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKE_API.G_MISS_CHAR,
107 description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKE_API.G_MISS_CHAR,
108 dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKE_API.G_MISS_CHAR,
109 cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKE_API.G_MISS_CHAR,
110 template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKE_API.G_MISS_CHAR,
111 template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKE_API.G_MISS_CHAR,
112 date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKE_API.G_MISS_DATE,
113 datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKE_API.G_MISS_DATE,
114 auto_renew_days NUMBER := OKE_API.G_MISS_NUM,
115 -- duplicated
116 -- date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKE_API.G_MISS_DATE,
117 datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKE_API.G_MISS_DATE,
118 non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKE_API.G_MISS_CHAR,
119 non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKE_API.G_MISS_CHAR,
120 rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKE_API.G_MISS_CHAR,
121 chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKE_API.G_MISS_CHAR,
122 keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKE_API.G_MISS_CHAR,
123 set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKE_API.G_MISS_CHAR,
124 set_aside_percent NUMBER := OKE_API.G_MISS_NUM,
125 response_copies_req NUMBER := OKE_API.G_MISS_NUM,
126 date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKE_API.G_MISS_DATE,
127 datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKE_API.G_MISS_DATE,
128 date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKE_API.G_MISS_DATE,
129 date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKE_API.G_MISS_DATE,
130 date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKE_API.G_MISS_DATE,
131 trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKE_API.G_MISS_CHAR,
132 start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKE_API.G_MISS_DATE,
133 end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKE_API.G_MISS_DATE,
134 authoring_org_id NUMBER := OKE_API.G_MISS_NUM,
135 buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKE_API.G_MISS_CHAR,
136 issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKE_API.G_MISS_CHAR,
137 estimated_amount NUMBER := OKE_API.G_MISS_NUM,
138 chr_id_renewed_to NUMBER := OKE_API.G_MISS_NUM,
139 estimated_amount_renewed NUMBER := OKE_API.G_MISS_NUM,
140 currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKE_API.G_MISS_CHAR,
141 upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKE_API.G_MISS_CHAR,
142 upg_orig_system_ref_id NUMBER := OKE_API.G_MISS_NUM,
143 attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKE_API.G_MISS_CHAR,
144 attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKE_API.G_MISS_CHAR,
145 attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKE_API.G_MISS_CHAR,
146 attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKE_API.G_MISS_CHAR,
147 attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKE_API.G_MISS_CHAR,
148 attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKE_API.G_MISS_CHAR,
149 attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKE_API.G_MISS_CHAR,
150 attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKE_API.G_MISS_CHAR,
151 attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKE_API.G_MISS_CHAR,
152 attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKE_API.G_MISS_CHAR,
153 attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKE_API.G_MISS_CHAR,
154 attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKE_API.G_MISS_CHAR,
155 attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKE_API.G_MISS_CHAR,
156 attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKE_API.G_MISS_CHAR,
157 attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKE_API.G_MISS_CHAR,
158 attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKE_API.G_MISS_CHAR,
159
160 created_by NUMBER := OKE_API.G_MISS_NUM,
161 creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKE_API.G_MISS_DATE,
162 last_updated_by NUMBER := OKE_API.G_MISS_NUM,
163 last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKE_API.G_MISS_DATE,
164 last_update_login NUMBER := OKE_API.G_MISS_NUM
165
166 );
167
168
169 TYPE cle_rec_type IS RECORD (
170
171 k_line_id NUMBER := OKE_API.G_MISS_NUM,
172 parent_line_id NUMBER := OKE_API.G_MISS_NUM,
173 project_id NUMBER := OKE_API.G_MISS_NUM,
174 task_id NUMBER := OKE_API.G_MISS_NUM,
175 billing_method_code OKE_K_LINES.BILLING_METHOD_CODE%TYPE := OKE_API.G_MISS_CHAR,
176 inventory_item_id NUMBER := OKE_API.G_MISS_NUM,
177 delivery_order_flag VARCHAR2(1) := OKE_API.G_MISS_CHAR,
178 splited_flag VARCHAR2(1) := OKE_API.G_MISS_CHAR,
179 priority_code OKE_K_LINES.PRIORITY_CODE%TYPE := OKE_API.G_MISS_CHAR,
180 customer_item_id NUMBER := OKE_API.G_MISS_NUM,
181 customer_item_number OKE_K_LINES.CUSTOMER_ITEM_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
182 line_quantity OKE_K_LINES.LINE_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
183 delivery_date DATE := OKE_API.G_MISS_DATE,
184 unit_price OKE_K_LINES.UNIT_PRICE%TYPE := OKE_API.G_MISS_NUM,
185 uom_code OKE_K_LINES.UOM_CODE%TYPE := OKE_API.G_MISS_CHAR,
186 billable_flag OKE_K_LINES.BILLABLE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
187 shippable_flag OKE_K_LINES.SHIPPABLE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
188 subcontracted_flag OKE_K_LINES.SUBCONTRACTED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
189 completed_flag OKE_K_LINES.COMPLETED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
190 nsp_flag OKE_K_LINES.NSP_FLAG%TYPE := OKE_API.G_MISS_CHAR,
191 app_code OKE_K_LINES.APP_CODE%TYPE := OKE_API.G_MISS_CHAR,
192 as_of_date OKE_K_LINES.AS_OF_DATE%TYPE := OKE_API.G_MISS_DATE,
193 authority OKE_K_LINES.AUTHORITY%TYPE := OKE_API.G_MISS_CHAR,
194 country_of_origin_code OKE_K_LINES.COUNTRY_OF_ORIGIN_CODE%TYPE := OKE_API.G_MISS_CHAR,
195 drop_shipped_flag OKE_K_LINES.DROP_SHIPPED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
196 customer_approval_req_flag OKE_K_LINES.CUSTOMER_APPROVAL_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
197 date_material_req OKE_K_LINES.DATE_MATERIAL_REQ%TYPE := OKE_API.G_MISS_DATE,
198 inspection_req_flag OKE_K_LINES.INSPECTION_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
199 interim_rpt_req_flag OKE_K_LINES.INTERIM_RPT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
200 subj_a133_flag OKE_K_LINES.SUBJ_A133_FLAG%TYPE := OKE_API.G_MISS_CHAR,
201 export_flag OKE_K_LINES.EXPORT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
202 cfe_req_flag OKE_K_LINES.CFE_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
203 cop_required_flag OKE_K_LINES.COP_REQUIRED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
204 export_license_num OKE_K_LINES.EXPORT_LICENSE_NUM%TYPE := OKE_API.G_MISS_CHAR,
205 export_license_res OKE_K_LINES.EXPORT_LICENSE_RES%TYPE := OKE_API.G_MISS_CHAR,
206
207 copies_required OKE_K_LINES.COPIES_REQUIRED%TYPE := OKE_API.G_MISS_NUM,
208 cdrl_category OKE_K_LINES.CDRL_CATEGORY%TYPE := OKE_API.G_MISS_CHAR,
209 data_item_name OKE_K_LINES.DATA_ITEM_NAME%TYPE := OKE_API.G_MISS_CHAR,
210 data_item_subtitle OKE_K_LINES.DATA_ITEM_SUBTITLE%TYPE := OKE_API.G_MISS_CHAR,
211 date_of_first_submission OKE_K_LINES.DATE_OF_FIRST_SUBMISSION%TYPE := OKE_API.G_MISS_DATE,
212 frequency OKE_K_LINES.FREQUENCY%TYPE := OKE_API.G_MISS_CHAR,
213 requiring_office OKE_K_LINES.REQUIRING_OFFICE%TYPE := OKE_API.G_MISS_CHAR,
214 dcaa_audit_req_flag OKE_K_LINES.DCAA_AUDIT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
215 definitized_flag OKE_K_LINES.DEFINITIZED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
216 cost_of_money OKE_K_LINES.COST_OF_MONEY%TYPE := OKE_API.G_MISS_CHAR,
217 bill_undefinitized_flag OKE_K_LINES.BILL_UNDEFINITIZED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
218 nsn_number OKE_K_LINES.NSN_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
219 nte_warning_flag OKE_K_LINES.NTE_WARNING_FLAG%TYPE := OKE_API.G_MISS_CHAR,
220 discount_for_payment OKE_K_LINES.DISCOUNT_FOR_PAYMENT%TYPE := OKE_API.G_MISS_NUM,
221 financial_ctrl_flag OKE_K_LINES.FINANCIAL_CTRL_FLAG%TYPE := OKE_API.G_MISS_CHAR,
222 c_scs_flag OKE_K_LINES.C_SCS_FLAG%TYPE := OKE_API.G_MISS_CHAR,
223 c_ssr_flag OKE_K_LINES.C_SSR_FLAG%TYPE := OKE_API.G_MISS_CHAR,
224 prepayment_amount OKE_K_LINES.PREPAYMENT_AMOUNT%TYPE := OKE_API.G_MISS_NUM,
225 prepayment_percentage OKE_K_LINES.PREPAYMENT_PERCENTAGE%TYPE := OKE_API.G_MISS_NUM,
226 progress_payment_flag OKE_K_LINES.PROGRESS_PAYMENT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
227 progress_payment_liq_rate OKE_K_LINES.PROGRESS_PAYMENT_LIQ_RATE%TYPE := OKE_API.G_MISS_NUM,
228 progress_payment_rate OKE_K_LINES.PROGRESS_PAYMENT_RATE%TYPE := OKE_API.G_MISS_NUM,
229 award_fee OKE_K_LINES.AWARD_FEE%TYPE := OKE_API.G_MISS_NUM,
230 award_fee_pool_amount OKE_K_LINES.AWARD_FEE_POOL_AMOUNT%TYPE := OKE_API.G_MISS_NUM,
231 base_fee OKE_K_LINES.BASE_FEE%TYPE := OKE_API.G_MISS_NUM,
232 ceiling_cost OKE_K_LINES.CEILING_COST%TYPE := OKE_API.G_MISS_NUM,
233 ceiling_price OKE_K_LINES.CEILING_PRICE%TYPE := OKE_API.G_MISS_NUM,
234 labor_cost_index OKE_K_LINES.LABOR_COST_INDEX%TYPE := OKE_API.G_MISS_CHAR,
235 material_cost_index OKE_K_LINES.MATERIAL_COST_INDEX%TYPE := OKE_API.G_MISS_CHAR,
236 customers_percent_in_order OKE_K_LINES.CUSTOMERS_PERCENT_IN_ORDER%TYPE := OKE_API.G_MISS_NUM,
237 cost_overrun_share_ratio OKE_K_LINES.COST_OVERRUN_SHARE_RATIO%TYPE := OKE_API.G_MISS_CHAR,
238 cost_underrun_share_ratio OKE_K_LINES.COST_UNDERRUN_SHARE_RATIO%TYPE := OKE_API.G_MISS_CHAR,
239 date_of_price_redetermin OKE_K_LINES.DATE_OF_PRICE_REDETERMIN%TYPE := OKE_API.G_MISS_DATE,
240 estimated_total_quantity OKE_K_LINES.ESTIMATED_TOTAL_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
241 fee_ajt_formula OKE_K_LINES.FEE_AJT_FORMULA%TYPE := OKE_API.G_MISS_CHAR,
242 final_fee OKE_K_LINES.FINAL_FEE%TYPE := OKE_API.G_MISS_NUM,
243 final_pft_ajt_formula OKE_K_LINES.FINAL_PFT_AJT_FORMULA%TYPE := OKE_API.G_MISS_CHAR,
244 fixed_fee OKE_K_LINES.FIXED_FEE%TYPE := OKE_API.G_MISS_NUM,
245 fixed_quantity OKE_K_LINES.FIXED_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
246 initial_fee OKE_K_LINES.INITIAL_FEE%TYPE := OKE_API.G_MISS_NUM,
247 initial_price OKE_K_LINES.INITIAL_PRICE%TYPE := OKE_API.G_MISS_NUM,
248 level_of_effort_hours OKE_K_LINES.LEVEL_OF_EFFORT_HOURS%TYPE := OKE_API.G_MISS_NUM,
249 line_liquidation_rate OKE_K_LINES.LINE_LIQUIDATION_RATE%TYPE := OKE_API.G_MISS_NUM,
250 maximum_fee OKE_K_LINES.MAXIMUM_FEE%TYPE := OKE_API.G_MISS_NUM,
251 maximum_quantity OKE_K_LINES.MAXIMUM_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
252 minimum_fee OKE_K_LINES.MINIMUM_FEE%TYPE := OKE_API.G_MISS_NUM,
253 minimum_quantity OKE_K_LINES.MINIMUM_QUANTITY%TYPE := OKE_API.G_MISS_NUM,
254 number_of_options OKE_K_LINES.NUMBER_OF_OPTIONS%TYPE := OKE_API.G_MISS_NUM,
255 revised_price OKE_K_LINES.REVISED_PRICE%TYPE := OKE_API.G_MISS_NUM,
256 target_cost OKE_K_LINES.TARGET_COST%TYPE := OKE_API.G_MISS_NUM,
257 target_date_definitize OKE_K_LINES.TARGET_DATE_DEFINITIZE%TYPE := OKE_API.G_MISS_DATE,
258 target_fee OKE_K_LINES.TARGET_FEE%TYPE := OKE_API.G_MISS_NUM,
259 target_price OKE_K_LINES.TARGET_PRICE%TYPE := OKE_API.G_MISS_NUM,
260 total_estimated_cost OKE_K_LINES.TOTAL_ESTIMATED_COST%TYPE := OKE_API.G_MISS_NUM,
261 proposal_due_date OKE_K_LINES.PROPOSAL_DUE_DATE%TYPE := OKE_API.G_MISS_CHAR,
262 cost_of_sale_rate NUMBER:=OKE_API.G_MISS_NUM,
263 line_value NUMBER:=OKE_API.G_MISS_NUM,
264 line_value_total NUMBER:=OKE_API.G_MISS_NUM,
265 UNDEF_UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
266 UNDEF_LINE_VALUE NUMBER := OKE_API.G_MISS_NUM,
267 UNDEF_LINE_VALUE_TOTAL NUMBER := OKE_API.G_MISS_NUM,
268
269
270 -- id NUMBER := OKE_API.G_MISS_NUM,
271 object_version_number NUMBER := OKE_API.G_MISS_NUM,
272 sfwt_flag OKC_K_LINES_V.SFWT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
273 chr_id NUMBER := OKE_API.G_MISS_NUM,
274 cle_id NUMBER := OKE_API.G_MISS_NUM,
275 cle_id_renewed NUMBER := OKE_API.G_MISS_NUM,
276 cle_id_renewed_to NUMBER := OKE_API.G_MISS_NUM,
277 lse_id NUMBER := OKE_API.G_MISS_NUM,
278 line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
279 sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKE_API.G_MISS_CHAR,
280 display_sequence NUMBER := OKE_API.G_MISS_NUM,
281 trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKE_API.G_MISS_CHAR,
282 dnz_chr_id NUMBER := OKE_API.G_MISS_NUM,
283 comments OKC_K_LINES_V.COMMENTS%TYPE := OKE_API.G_MISS_CHAR,
284 item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKE_API.G_MISS_CHAR,
285 oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKE_API.G_MISS_CHAR,
286 hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKE_API.G_MISS_CHAR,
287 price_unit NUMBER := OKE_API.G_MISS_NUM,
288 price_unit_percent NUMBER := OKE_API.G_MISS_NUM,
289 price_negotiated NUMBER := OKE_API.G_MISS_NUM,
290 price_negotiated_renewed NUMBER := OKE_API.G_MISS_NUM,
291 price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKE_API.G_MISS_CHAR,
292 invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKE_API.G_MISS_CHAR,
293 dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKE_API.G_MISS_CHAR,
294 block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKE_API.G_MISS_CHAR,
295 exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKE_API.G_MISS_CHAR,
296 template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKE_API.G_MISS_CHAR,
297 date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKE_API.G_MISS_DATE,
298 name OKC_K_LINES_V.NAME%TYPE := OKE_API.G_MISS_CHAR,
299 start_date OKC_K_LINES_V.START_DATE%TYPE := OKE_API.G_MISS_DATE,
300 end_date OKC_K_LINES_V.END_DATE%TYPE := OKE_API.G_MISS_DATE,
301 upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKE_API.G_MISS_CHAR,
302 upg_orig_system_ref_id NUMBER := OKE_API.G_MISS_NUM,
303 attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKE_API.G_MISS_CHAR,
304 attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKE_API.G_MISS_CHAR,
305 attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKE_API.G_MISS_CHAR,
306 attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKE_API.G_MISS_CHAR,
307 attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKE_API.G_MISS_CHAR,
308 attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKE_API.G_MISS_CHAR,
309 attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKE_API.G_MISS_CHAR,
310 attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKE_API.G_MISS_CHAR,
311 attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKE_API.G_MISS_CHAR,
312 attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKE_API.G_MISS_CHAR,
313 attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKE_API.G_MISS_CHAR,
314 attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKE_API.G_MISS_CHAR,
315 attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKE_API.G_MISS_CHAR,
316 attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKE_API.G_MISS_CHAR,
317 attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKE_API.G_MISS_CHAR,
318 attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKE_API.G_MISS_CHAR,
319 price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKE_API.G_MISS_CHAR,
320 currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKE_API.G_MISS_CHAR,
321 currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKE_API.G_MISS_CHAR,
322
323 created_by NUMBER := OKE_API.G_MISS_NUM,
324 creation_date OKE_K_LINES.CREATION_DATE%TYPE := OKE_API.G_MISS_DATE,
325 last_updated_by NUMBER := OKE_API.G_MISS_NUM,
326 last_update_login NUMBER := OKE_API.G_MISS_NUM,
327 last_update_date OKE_K_LINES.LAST_UPDATE_DATE%TYPE := OKE_API.G_MISS_DATE
328 );
329
330
331 TYPE bill_rec_type IS RECORD(
332 K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
333 BILLING_METHOD_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
334 CREATION_DATE DATE := OKE_API.G_MISS_DATE,
335 CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
336 LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
337 LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
338 LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
339 DEFAULT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
340 ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
341 ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
342 ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
343 ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
344 ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
345 ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
346 ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
347 ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
348 ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
349 ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
350 ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
351 ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
352 ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
353 ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
354 ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
355 ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR
356
357 );
358
359 TYPE bill_tbl_type IS TABLE OF bill_rec_type INDEX BY BINARY_INTEGER;
360
361 TYPE cimv_rec_type IS RECORD(
362 id NUMBER := OKC_API.G_MISS_NUM,
363 object_version_number NUMBER := OKC_API.G_MISS_NUM,
364 cle_id NUMBER := OKC_API.G_MISS_NUM,
365 chr_id NUMBER := OKC_API.G_MISS_NUM,
366 cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368 object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369 object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370 jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371 uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372 exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373 number_of_items NUMBER := OKC_API.G_MISS_NUM,
374 upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376 priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377 created_by NUMBER := OKC_API.G_MISS_NUM,
378 creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
380 last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
381 last_update_login NUMBER := OKC_API.G_MISS_NUM
382 );
383
384 TYPE cimv_tbl_type IS TABLE OF cimv_rec_type INDEX BY BINARY_INTEGER;
385
386
387
388 /*#
389 * Creates the contract header. This is the first step towards creating a
390 * complete contract document.
391 * @rep:metalink 234864.1 See OracleMetaLink bulletin 234864.1
392 * @rep:scope public
393 * @rep:lifecycle active
394 * @rep:displayname Create Project Contract Header
395 * @rep:category BUSINESS_ENTITY OKE_CONTRACT
396 */
397 PROCEDURE create_contract_header(
398
399 p_api_version IN NUMBER,
400 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
401 p_ignore_oke_validation IN VARCHAR2 DEFAULT 'N',
402 x_return_status OUT NOCOPY VARCHAR2,
403 x_msg_count OUT NOCOPY NUMBER,
404 x_msg_data OUT NOCOPY VARCHAR2,
405
406 p_chr_rec IN chr_rec_type,
407 x_chr_rec OUT NOCOPY chr_rec_type);
408
409 /*#
410 * Creates a contract line. The top level line must be created before
411 * creating the lower level sub-lines with this same procedure
412 * @rep:metalink 234864.1 See OracleMetaLink bulletin 234864.1
413 * @rep:scope public
414 * @rep:lifecycle active
415 * @rep:displayname Create Project Contract Line
416 * @rep:category BUSINESS_ENTITY OKE_CONTRACT
417 */
418 PROCEDURE create_contract_line(
419
420 p_api_version IN NUMBER,
421 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
422 x_return_status OUT NOCOPY VARCHAR2,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425
426 p_cle_rec IN cle_rec_type,
427 x_cle_rec OUT NOCOPY cle_rec_type);
428
429 /*#
430 * Creates a contract deliverable. This is used to create deliverables
431 * after all sub-lines are in place.
432 * @rep:metalink 234864.1 See OracleMetaLink bulletin 234864.1
433 * @rep:scope public
434 * @rep:lifecycle active
435 * @rep:displayname Create Project Contract Deliverable
436 * @rep:category BUSINESS_ENTITY OKE_CONTRACT
437 */
438 PROCEDURE create_deliverable(
439
440 p_api_version IN NUMBER,
441 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
442 x_return_status OUT NOCOPY VARCHAR2,
443 x_msg_count OUT NOCOPY NUMBER,
444 x_msg_data OUT NOCOPY VARCHAR2,
445
446 p_del_rec IN del_rec_type,
447 x_del_rec OUT NOCOPY del_rec_type);
448
449
450 /*#
451 * Define billing method set for a particular contract.
452 * This can be done anytime after the header has been created.
453 * @rep:metalink 234864.1 See OracleMetaLink bulletin 234864.1
454 * @rep:scope public
455 * @rep:lifecycle active
456 * @rep:displayname Define Project Contract Billing Method
457 * @rep:category BUSINESS_ENTITY OKE_CONTRACT
458 */
459 PROCEDURE define_billing_methods(
460 p_api_version IN NUMBER,
461 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
462 x_return_status OUT NOCOPY VARCHAR2,
463 x_msg_count OUT NOCOPY NUMBER,
464 x_msg_data OUT NOCOPY VARCHAR2,
465
466 p_bill_tbl IN bill_tbl_type);
467
468
469 /* - only need to provide k_header_id and billing_method_code to remove
470 - will only remove billing_methods not assigned at the lines */
471
472 PROCEDURE remove_billing_methods(
473 p_api_version IN NUMBER,
474 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
475 x_return_status OUT NOCOPY VARCHAR2,
476 x_msg_count OUT NOCOPY NUMBER,
477 x_msg_data OUT NOCOPY VARCHAR2,
478
479 p_bill_tbl IN bill_tbl_type);
480
481
482
483 /*
484 PURPORSE:
485 to attach a line item to a contract line.
486 line items should only be attached to lines that have 'item' line style.
487
488
489 INPUT PARAMETERS:
490 DNZ_CHR_ID -- k_header_id of oke_k_headers; the id of the header that the line belongs to
491 CLE_ID -- k_line_id of oke_k_lines; the id of the particular line you are attaching
492 this line item to.
493 EXCEPTION_YN -- use 'N'
494 PRICED_ITEM_YN -- use 'N'
495 OBJECT1_ID1 -- item id
496 OBJECT1_ID2 -- 'inventory org id' also known as 'item master org id'
497 JTOT_OBJECT1_CODE -- 'OKE_ITEMS'
498 UOM_CODE -- same as uom_code of the line in oke_k_lines table
499 NUMBER_OF_ITEMS -- same as line_quantity of the line in oke_k_lines
500
501 CREATED_BY -- who columns; please copy from the respective line.
502 CREATION_DATE it is supposed to be the same as the line it is attached to.
503 LAST_UPDATED_BY
504 LAST_UPDATE_DATE
505 LAST_UPDATE_LOGIN
506
507 */
508
509 PROCEDURE create_line_item(
510 p_api_version IN NUMBER,
511 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
512 x_return_status OUT NOCOPY VARCHAR2,
513 x_msg_count OUT NOCOPY NUMBER,
514 x_msg_data OUT NOCOPY VARCHAR2,
515
516 p_cimv_rec IN cimv_rec_type,
517 x_cimv_rec OUT NOCOPY cimv_rec_type);
518
519
520 END OKE_IMPORT_CONTRACT_PUB;
521