3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cle_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cle_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE cle_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
6: TYPE cle_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
12: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: display_sequence NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
16: lse_id NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
17: exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
18: object_version_number NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
19: created_by NUMBER := OKC_API.G_MISS_NUM,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
20: creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
21: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
22: last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
23: hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: price_unit NUMBER := OKC_API.G_MISS_NUM,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
27: price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
30: template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
31: price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
32: currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
34: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
35: start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
36: end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
37: date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
38: upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
39: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
40: orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
41: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
42: orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
43: attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
52: attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
54: attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
55: attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
56: attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
59: cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
60: currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
61: price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
62: request_id NUMBER := OKC_API.G_MISS_NUM,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
63: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
65: program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
67: pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
68: price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
69: line_list_price NUMBER := OKC_API.G_MISS_NUM,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
71: price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
72: config_header_id NUMBER := OKC_API.G_MISS_NUM,
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
73: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
74: config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
75: config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76: config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
77: config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
78: CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
79: service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
80: --new columns for price hold
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
81: ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
82: ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
83: ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
84: ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
85: ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86: ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
87: ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
94: line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
88: ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
94: line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
96: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
89: ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
94: line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
96: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
97: --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
94: line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
96: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
97: --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
98: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
94: line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
96: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
97: --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
98: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
99: -- Line level Cancellation --
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
94: line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
96: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
97: --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
98: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
99: -- Line level Cancellation --
100: date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
94: line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
96: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
97: --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
98: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
99: -- Line level Cancellation --
100: date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
101: --canc_reason_code OKC_K_LINES_B.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
102: term_cancel_source OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
96: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
97: --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
98: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
99: -- Line level Cancellation --
100: date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
101: --canc_reason_code OKC_K_LINES_B.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
102: term_cancel_source OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
103: cancelled_amount OKC_K_LINES_B.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
104: payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
97: --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
98: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
99: -- Line level Cancellation --
100: date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
101: --canc_reason_code OKC_K_LINES_B.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
102: term_cancel_source OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
103: cancelled_amount OKC_K_LINES_B.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
104: payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
105:
98: annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
99: -- Line level Cancellation --
100: date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
101: --canc_reason_code OKC_K_LINES_B.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
102: term_cancel_source OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
103: cancelled_amount OKC_K_LINES_B.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
104: payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
105:
106: );
99: -- Line level Cancellation --
100: date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
101: --canc_reason_code OKC_K_LINES_B.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
102: term_cancel_source OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
103: cancelled_amount OKC_K_LINES_B.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
104: payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
105:
106: );
107:
100: date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
101: --canc_reason_code OKC_K_LINES_B.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
102: term_cancel_source OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
103: cancelled_amount OKC_K_LINES_B.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
104: payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
105:
106: );
107:
108: g_miss_cle_rec cle_rec_type;
109: TYPE cle_tbl_type IS TABLE OF cle_rec_type
110: INDEX BY BINARY_INTEGER;
111:
112: TYPE okc_k_lines_tl_rec_type IS RECORD (
113: id NUMBER := OKC_API.G_MISS_NUM,
114: language OKC_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
115: source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
110: INDEX BY BINARY_INTEGER;
111:
112: TYPE okc_k_lines_tl_rec_type IS RECORD (
113: id NUMBER := OKC_API.G_MISS_NUM,
114: language OKC_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
115: source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
111:
112: TYPE okc_k_lines_tl_rec_type IS RECORD (
113: id NUMBER := OKC_API.G_MISS_NUM,
114: language OKC_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
115: source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
112: TYPE okc_k_lines_tl_rec_type IS RECORD (
113: id NUMBER := OKC_API.G_MISS_NUM,
114: language OKC_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
115: source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
113: id NUMBER := OKC_API.G_MISS_NUM,
114: language OKC_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
115: source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
114: language OKC_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
115: source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
115: source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118: comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
126: last_update_date OKC_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
119: item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
126: last_update_date OKC_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
127: last_update_login NUMBER := OKC_API.G_MISS_NUM);
120: oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
126: last_update_date OKC_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
127: last_update_login NUMBER := OKC_API.G_MISS_NUM);
128:
121: cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
126: last_update_date OKC_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
127: last_update_login NUMBER := OKC_API.G_MISS_NUM);
128:
129: g_miss_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
122: block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
126: last_update_date OKC_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
127: last_update_login NUMBER := OKC_API.G_MISS_NUM);
128:
129: g_miss_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
130: TYPE okc_k_lines_tl_tbl_type IS TABLE OF okc_k_lines_tl_rec_type
123: created_by NUMBER := OKC_API.G_MISS_NUM,
124: creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
126: last_update_date OKC_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
127: last_update_login NUMBER := OKC_API.G_MISS_NUM);
128:
129: g_miss_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
130: TYPE okc_k_lines_tl_tbl_type IS TABLE OF okc_k_lines_tl_rec_type
131: INDEX BY BINARY_INTEGER;
130: TYPE okc_k_lines_tl_tbl_type IS TABLE OF okc_k_lines_tl_rec_type
131: INDEX BY BINARY_INTEGER;
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,
131: INDEX BY BINARY_INTEGER;
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,
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,
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,
141: lse_id NUMBER := OKC_API.G_MISS_NUM,
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,
141: lse_id NUMBER := OKC_API.G_MISS_NUM,
142: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
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,
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,
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,
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,
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,
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,
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,
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,
148: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%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,
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,
150: cognomen OKC_K_LINES_V.COGNOMEN%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,
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,
156: price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%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,
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,
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,
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,
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,
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,
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,
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,
172: attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%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,
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,
174: attribute2 OKC_K_LINES_V.ATTRIBUTE2%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,
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,
192: price_type OKC_K_LINES_V.PRICE_TYPE%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,
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,
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,
194: currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%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,
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,
199: new_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,
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,
202: program_application_id NUMBER := OKC_API.G_MISS_NUM,
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,
202: program_application_id NUMBER := OKC_API.G_MISS_NUM,
203: program_id NUMBER := OKC_API.G_MISS_NUM,
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,
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,
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,
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,
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,
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,
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,
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,
209: item_to_price_yn OKC_K_LINES_V.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
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,
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,
211: config_header_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,
211: config_header_id NUMBER := OKC_API.G_MISS_NUM,
212: config_revision_number NUMBER := OKC_API.G_MISS_NUM,
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,
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,
215: config_top_model_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,
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,
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,
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,
219: --new columns for price hold
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,
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,
221: ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%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,
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,
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,
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,
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,
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,
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.
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 ---
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 ---
239: date_cancelled OKC_K_LINES_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
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 ---
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,
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: );
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: );
247: g_miss_clev_rec clev_rec_type;
248: TYPE clev_tbl_type IS TABLE OF clev_rec_type
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: );
247: g_miss_clev_rec clev_rec_type;
248: TYPE clev_tbl_type IS TABLE OF clev_rec_type
249: INDEX BY BINARY_INTEGER;
249: INDEX BY BINARY_INTEGER;
250: ---------------------------------------------------------------------------
251: -- GLOBAL MESSAGE CONSTANTS
252: ---------------------------------------------------------------------------
253: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
254: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
255: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
250: ---------------------------------------------------------------------------
251: -- GLOBAL MESSAGE CONSTANTS
252: ---------------------------------------------------------------------------
253: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
254: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
255: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
251: -- GLOBAL MESSAGE CONSTANTS
252: ---------------------------------------------------------------------------
253: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
254: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
255: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
252: ---------------------------------------------------------------------------
253: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
254: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
255: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
260: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
253: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
254: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
255: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
260: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
261: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
254: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
255: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
260: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
261: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
262: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
255: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
260: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
261: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
262: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
263: ---------------------------------------------------------------------------
256: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
260: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
261: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
262: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
263: ---------------------------------------------------------------------------
264: -- GLOBAL VARIABLES
257: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
260: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
261: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
262: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
263: ---------------------------------------------------------------------------
264: -- GLOBAL VARIABLES
265: ---------------------------------------------------------------------------
258: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
259: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
260: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
261: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
262: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
263: ---------------------------------------------------------------------------
264: -- GLOBAL VARIABLES
265: ---------------------------------------------------------------------------
266: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLE_PVT';
263: ---------------------------------------------------------------------------
264: -- GLOBAL VARIABLES
265: ---------------------------------------------------------------------------
266: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLE_PVT';
267: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
268: ---------------------------------------------------------------------------
269: -- Procedures and Functions
270: ---------------------------------------------------------------------------
271:
274: PROCEDURE api_copy;
275: PROCEDURE add_language;
276: PROCEDURE insert_row(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_clev_rec IN clev_rec_type,
283: x_clev_rec OUT NOCOPY clev_rec_type);
284:
285: PROCEDURE insert_row(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_clev_tbl IN clev_tbl_type,
292: x_clev_tbl OUT NOCOPY clev_tbl_type);
293:
294: PROCEDURE lock_row(
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_clev_rec IN clev_rec_type);
300: p_clev_rec IN clev_rec_type);
301:
302: PROCEDURE lock_row(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_clev_tbl IN clev_tbl_type);
308: p_clev_tbl IN clev_tbl_type);
309:
310: PROCEDURE update_row(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
312: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
317: p_clev_rec IN clev_rec_type,
318: x_clev_rec OUT NOCOPY clev_rec_type);
319:
320: PROCEDURE update_row(
318: x_clev_rec OUT NOCOPY clev_rec_type);
319:
320: PROCEDURE update_row(
321: p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2,
326: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
322: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2,
326: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327: p_clev_tbl IN clev_tbl_type,
328: x_clev_tbl OUT NOCOPY clev_tbl_type);
329:
330: PROCEDURE delete_row(
328: x_clev_tbl OUT NOCOPY clev_tbl_type);
329:
330: PROCEDURE delete_row(
331: p_api_version IN NUMBER,
332: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_clev_rec IN clev_rec_type);
336: p_clev_rec IN clev_rec_type);
337:
338: PROCEDURE delete_row(
339: p_api_version IN NUMBER,
340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
341: x_return_status OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,
343: x_msg_data OUT NOCOPY VARCHAR2,
344: p_clev_tbl IN clev_tbl_type);
344: p_clev_tbl IN clev_tbl_type);
345:
346: PROCEDURE force_delete_row(
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
352: p_clev_tbl IN clev_tbl_type);
352: p_clev_tbl IN clev_tbl_type);
353:
354: PROCEDURE validate_row(
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
357: x_return_status OUT NOCOPY VARCHAR2,
358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: p_clev_rec IN clev_rec_type);
360: p_clev_rec IN clev_rec_type);
361:
362: PROCEDURE validate_row(
363: p_api_version IN NUMBER,
364: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_clev_tbl IN clev_tbl_type);