132:
133: TYPE clev_rec_type IS RECORD (
134: id NUMBER := OKC_API.G_MISS_NUM,
135: object_version_number NUMBER := OKC_API.G_MISS_NUM,
136: sfwt_flag OKC_K_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
137: chr_id NUMBER := OKC_API.G_MISS_NUM,
138: cle_id NUMBER := OKC_API.G_MISS_NUM,
139: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
140: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
138: cle_id NUMBER := OKC_API.G_MISS_NUM,
139: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
140: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
141: lse_id NUMBER := OKC_API.G_MISS_NUM,
142: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
143: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
144: display_sequence NUMBER := OKC_API.G_MISS_NUM,
145: trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
146: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
139: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
140: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
141: lse_id NUMBER := OKC_API.G_MISS_NUM,
142: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
143: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
144: display_sequence NUMBER := OKC_API.G_MISS_NUM,
145: trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
146: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
147: comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: lse_id NUMBER := OKC_API.G_MISS_NUM,
142: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
143: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
144: display_sequence NUMBER := OKC_API.G_MISS_NUM,
145: trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
146: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
147: comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
148: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
149: oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
143: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
144: display_sequence NUMBER := OKC_API.G_MISS_NUM,
145: trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
146: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
147: comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
148: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
149: oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
150: cognomen OKC_K_LINES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
151: hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
144: display_sequence NUMBER := OKC_API.G_MISS_NUM,
145: trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
146: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
147: comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
148: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
149: oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
150: cognomen OKC_K_LINES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
151: hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
152: price_unit NUMBER := OKC_API.G_MISS_NUM,
145: trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
146: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
147: comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
148: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
149: oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
150: cognomen OKC_K_LINES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
151: hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
152: price_unit NUMBER := OKC_API.G_MISS_NUM,
153: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
146: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
147: comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
148: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
149: oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
150: cognomen OKC_K_LINES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
151: hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
152: price_unit NUMBER := OKC_API.G_MISS_NUM,
153: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
154: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
147: comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
148: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
149: oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
150: cognomen OKC_K_LINES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
151: hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
152: price_unit NUMBER := OKC_API.G_MISS_NUM,
153: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
154: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
155: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
152: price_unit NUMBER := OKC_API.G_MISS_NUM,
153: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
154: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
155: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
156: price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
157: invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
158: dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
153: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
154: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
155: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
156: price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
157: invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
158: dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
154: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
155: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
156: price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
157: invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
158: dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
155: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
156: price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
157: invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
158: dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
156: price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
157: invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
158: dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
157: invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
158: dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
158: dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166: date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
159: block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166: date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
167: upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
160: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166: date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
167: upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
168: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
161: template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166: date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
167: upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
168: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
169: orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
162: date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166: date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
167: upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
168: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
169: orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
170: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
163: name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166: date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
167: upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
168: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
169: orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
170: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
171: orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
165: end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166: date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
167: upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
168: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
169: orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
170: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
171: orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
167: upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
168: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
169: orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
170: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
171: orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
168: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
169: orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
170: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
171: orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
169: orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
170: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
171: orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
170: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
171: orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
171: orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
173: attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
175: attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
176: attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
177: attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
178: attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186: attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
179: attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186: attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
187: attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
180: attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186: attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
187: attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
188: created_by NUMBER := OKC_API.G_MISS_NUM,
181: attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186: attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
187: attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
188: created_by NUMBER := OKC_API.G_MISS_NUM,
189: creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
182: attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186: attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
187: attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
188: created_by NUMBER := OKC_API.G_MISS_NUM,
189: creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
190: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
183: attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184: attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186: attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
187: attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
188: created_by NUMBER := OKC_API.G_MISS_NUM,
189: creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
190: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
191: last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
185: attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186: attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
187: attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
188: created_by NUMBER := OKC_API.G_MISS_NUM,
189: creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
190: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
191: last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
192: price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
193: currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
187: attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
188: created_by NUMBER := OKC_API.G_MISS_NUM,
189: creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
190: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
191: last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
192: price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
193: currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
195: last_update_login NUMBER := OKC_API.G_MISS_NUM,
188: created_by NUMBER := OKC_API.G_MISS_NUM,
189: creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
190: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
191: last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
192: price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
193: currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
195: last_update_login NUMBER := OKC_API.G_MISS_NUM,
196: old_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
190: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
191: last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
192: price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
193: currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
195: last_update_login NUMBER := OKC_API.G_MISS_NUM,
196: old_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: new_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
190: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
191: last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
192: price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
193: currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
195: last_update_login NUMBER := OKC_API.G_MISS_NUM,
196: old_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: new_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
198: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
192: price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
193: currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
195: last_update_login NUMBER := OKC_API.G_MISS_NUM,
196: old_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: new_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
198: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
199: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
200: Call_Action_Asmblr VARCHAR2(1) := 'Y',
193: currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
195: last_update_login NUMBER := OKC_API.G_MISS_NUM,
196: old_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: new_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
198: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
199: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
200: Call_Action_Asmblr VARCHAR2(1) := 'Y',
201: request_id NUMBER := OKC_API.G_MISS_NUM,
200: Call_Action_Asmblr VARCHAR2(1) := 'Y',
201: request_id NUMBER := OKC_API.G_MISS_NUM,
202: program_application_id NUMBER := OKC_API.G_MISS_NUM,
203: program_id NUMBER := OKC_API.G_MISS_NUM,
204: program_update_date OKC_K_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: price_list_id NUMBER := OKC_API.G_MISS_NUM,
206: pricing_date OKC_K_LINES_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
207: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
208: line_list_price NUMBER := OKC_API.G_MISS_NUM,
202: program_application_id NUMBER := OKC_API.G_MISS_NUM,
203: program_id NUMBER := OKC_API.G_MISS_NUM,
204: program_update_date OKC_K_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: price_list_id NUMBER := OKC_API.G_MISS_NUM,
206: pricing_date OKC_K_LINES_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
207: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
208: line_list_price NUMBER := OKC_API.G_MISS_NUM,
209: item_to_price_yn OKC_K_LINES_V.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
210: price_basis_yn OKC_K_LINES_V.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
205: price_list_id NUMBER := OKC_API.G_MISS_NUM,
206: pricing_date OKC_K_LINES_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
207: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
208: line_list_price NUMBER := OKC_API.G_MISS_NUM,
209: item_to_price_yn OKC_K_LINES_V.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
210: price_basis_yn OKC_K_LINES_V.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
211: config_header_id NUMBER := OKC_API.G_MISS_NUM,
212: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
213: config_complete_yn OKC_K_LINES_V.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
206: pricing_date OKC_K_LINES_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
207: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
208: line_list_price NUMBER := OKC_API.G_MISS_NUM,
209: item_to_price_yn OKC_K_LINES_V.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
210: price_basis_yn OKC_K_LINES_V.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
211: config_header_id NUMBER := OKC_API.G_MISS_NUM,
212: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
213: config_complete_yn OKC_K_LINES_V.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
214: config_valid_yn OKC_K_LINES_V.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
209: item_to_price_yn OKC_K_LINES_V.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
210: price_basis_yn OKC_K_LINES_V.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
211: config_header_id NUMBER := OKC_API.G_MISS_NUM,
212: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
213: config_complete_yn OKC_K_LINES_V.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
214: config_valid_yn OKC_K_LINES_V.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
215: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
216: config_item_type OKC_K_LINES_V.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
217: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
210: price_basis_yn OKC_K_LINES_V.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
211: config_header_id NUMBER := OKC_API.G_MISS_NUM,
212: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
213: config_complete_yn OKC_K_LINES_V.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
214: config_valid_yn OKC_K_LINES_V.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
215: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
216: config_item_type OKC_K_LINES_V.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
217: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
218: service_item_yn OKC_K_LINES_V.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
212: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
213: config_complete_yn OKC_K_LINES_V.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
214: config_valid_yn OKC_K_LINES_V.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
215: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
216: config_item_type OKC_K_LINES_V.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
217: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
218: service_item_yn OKC_K_LINES_V.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
219: --new columns for price hold
220: ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
214: config_valid_yn OKC_K_LINES_V.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
215: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
216: config_item_type OKC_K_LINES_V.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
217: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
218: service_item_yn OKC_K_LINES_V.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
219: --new columns for price hold
220: ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
216: config_item_type OKC_K_LINES_V.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
217: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
218: service_item_yn OKC_K_LINES_V.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
219: --new columns for price hold
220: ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
217: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
218: service_item_yn OKC_K_LINES_V.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
219: --new columns for price hold
220: ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
218: service_item_yn OKC_K_LINES_V.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
219: --new columns for price hold
220: ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226: ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
219: --new columns for price hold
220: ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226: ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
227: ph_adjustment OKC_K_LINES_V.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
220: ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226: ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
227: ph_adjustment OKC_K_LINES_V.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
228: ph_integrated_with_qp OKC_K_LINES_V.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226: ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
227: ph_adjustment OKC_K_LINES_V.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
228: ph_integrated_with_qp OKC_K_LINES_V.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
229:
222: ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226: ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
227: ph_adjustment OKC_K_LINES_V.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
228: ph_integrated_with_qp OKC_K_LINES_V.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
229:
230: --new columns to replace rules
223: ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226: ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
227: ph_adjustment OKC_K_LINES_V.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
228: ph_integrated_with_qp OKC_K_LINES_V.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
229:
230: --new columns to replace rules
231: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
224: ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225: ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226: ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
227: ph_adjustment OKC_K_LINES_V.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
228: ph_integrated_with_qp OKC_K_LINES_V.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
229:
230: --new columns to replace rules
231: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
232: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
230: --new columns to replace rules
231: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
232: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
233: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
234: line_renewal_type_code OKC_K_LINES_V.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
235: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
236: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
237: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
238: --- Line level Cancellation ---
235: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
236: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
237: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
238: --- Line level Cancellation ---
239: date_cancelled OKC_K_LINES_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
240: --canc_reason_code OKC_K_LINES_V.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
241: term_cancel_source OKC_K_LINES_V.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
242: cancelled_amount OKC_K_LINES_V.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
243: --R12 changes added by mchoudha--
236: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
237: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
238: --- Line level Cancellation ---
239: date_cancelled OKC_K_LINES_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
240: --canc_reason_code OKC_K_LINES_V.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
241: term_cancel_source OKC_K_LINES_V.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
242: cancelled_amount OKC_K_LINES_V.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
243: --R12 changes added by mchoudha--
244: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
237: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
238: --- Line level Cancellation ---
239: date_cancelled OKC_K_LINES_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
240: --canc_reason_code OKC_K_LINES_V.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
241: term_cancel_source OKC_K_LINES_V.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
242: cancelled_amount OKC_K_LINES_V.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
243: --R12 changes added by mchoudha--
244: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
245: payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
238: --- Line level Cancellation ---
239: date_cancelled OKC_K_LINES_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
240: --canc_reason_code OKC_K_LINES_V.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
241: term_cancel_source OKC_K_LINES_V.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
242: cancelled_amount OKC_K_LINES_V.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
243: --R12 changes added by mchoudha--
244: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
245: payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
246: );