3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE pat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_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: bsl_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE pat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_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: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE pat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_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: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE pat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_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: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_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: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: pat_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: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
11: bsl_id NUMBER := OKC_API.G_MISS_NUM,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: bcl_id NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
14: creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
16: last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
17: modified_from NUMBER := OKC_API.G_MISS_NUM,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
18: modified_to NUMBER := OKC_API.G_MISS_NUM,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
19: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
20: operand NUMBER := OKC_API.G_MISS_NUM,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
21: arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
22: automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
23: update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
25: applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
26: on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
27: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
32: request_id NUMBER := OKC_API.G_MISS_NUM,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
33: list_header_id NUMBER := OKC_API.G_MISS_NUM,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
34: list_line_id NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
35: list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
36: change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
37: change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
38: estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
39: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
40: charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
41: charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
44: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
45: accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
46: list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
47: source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
48: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
49: benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63: attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
64: attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM,
65: attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM,
73: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
66: attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM,
73: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
74: g_miss_pat_rec pat_rec_type;
67: attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM,
73: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
74: g_miss_pat_rec pat_rec_type;
75: TYPE pat_tbl_type IS TABLE OF pat_rec_type
68: attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM,
73: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
74: g_miss_pat_rec pat_rec_type;
75: TYPE pat_tbl_type IS TABLE OF pat_rec_type
76: INDEX BY BINARY_INTEGER;
69: attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM,
73: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
74: g_miss_pat_rec pat_rec_type;
75: TYPE pat_tbl_type IS TABLE OF pat_rec_type
76: INDEX BY BINARY_INTEGER;
77: TYPE patv_rec_type IS RECORD (
74: g_miss_pat_rec pat_rec_type;
75: TYPE pat_tbl_type IS TABLE OF pat_rec_type
76: INDEX BY BINARY_INTEGER;
77: TYPE patv_rec_type IS RECORD (
78: id NUMBER := OKC_API.G_MISS_NUM,
79: pat_id NUMBER := OKC_API.G_MISS_NUM,
80: chr_id NUMBER := OKC_API.G_MISS_NUM,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
75: TYPE pat_tbl_type IS TABLE OF pat_rec_type
76: INDEX BY BINARY_INTEGER;
77: TYPE patv_rec_type IS RECORD (
78: id NUMBER := OKC_API.G_MISS_NUM,
79: pat_id NUMBER := OKC_API.G_MISS_NUM,
80: chr_id NUMBER := OKC_API.G_MISS_NUM,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
76: INDEX BY BINARY_INTEGER;
77: TYPE patv_rec_type IS RECORD (
78: id NUMBER := OKC_API.G_MISS_NUM,
79: pat_id NUMBER := OKC_API.G_MISS_NUM,
80: chr_id NUMBER := OKC_API.G_MISS_NUM,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
77: TYPE patv_rec_type IS RECORD (
78: id NUMBER := OKC_API.G_MISS_NUM,
79: pat_id NUMBER := OKC_API.G_MISS_NUM,
80: chr_id NUMBER := OKC_API.G_MISS_NUM,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
78: id NUMBER := OKC_API.G_MISS_NUM,
79: pat_id NUMBER := OKC_API.G_MISS_NUM,
80: chr_id NUMBER := OKC_API.G_MISS_NUM,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: pat_id NUMBER := OKC_API.G_MISS_NUM,
80: chr_id NUMBER := OKC_API.G_MISS_NUM,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
80: chr_id NUMBER := OKC_API.G_MISS_NUM,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
81: cle_id NUMBER := OKC_API.G_MISS_NUM,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
82: bsl_id NUMBER := OKC_API.G_MISS_NUM,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
83: bcl_id NUMBER := OKC_API.G_MISS_NUM,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: modified_from NUMBER := OKC_API.G_MISS_NUM,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
85: modified_to NUMBER := OKC_API.G_MISS_NUM,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
86: modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
87: operand NUMBER := OKC_API.G_MISS_NUM,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
88: arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
89: automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
90: update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
91: updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
92: applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
93: on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
94: pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
95: context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
97: program_id NUMBER := OKC_API.G_MISS_NUM,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
99: request_id NUMBER := OKC_API.G_MISS_NUM,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
100: list_header_id NUMBER := OKC_API.G_MISS_NUM,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
101: list_line_id NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
102: list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
103: change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
104: change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
105: estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
106: adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
107: charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
108: charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109: range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110: accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
111: pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
112: accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
113: list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
114: source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
115: benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
116: benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
117: expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
118: modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
119: price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
120: substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
121: proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
122: include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
123: object_version_number NUMBER := OKC_API.G_MISS_NUM,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
124: attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
125: attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
126: attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
127: attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
128: attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
129: attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
130: attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
131: attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
132: attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
133: attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
134: attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142: last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
135: attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142: last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
143: last_update_login NUMBER := OKC_API.G_MISS_NUM,
136: attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142: last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
143: last_update_login NUMBER := OKC_API.G_MISS_NUM,
144: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
137: attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142: last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
143: last_update_login NUMBER := OKC_API.G_MISS_NUM,
144: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
145: g_miss_patv_rec patv_rec_type;
138: attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142: last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
143: last_update_login NUMBER := OKC_API.G_MISS_NUM,
144: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
145: g_miss_patv_rec patv_rec_type;
146: TYPE patv_tbl_type IS TABLE OF patv_rec_type
139: created_by NUMBER := OKC_API.G_MISS_NUM,
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142: last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
143: last_update_login NUMBER := OKC_API.G_MISS_NUM,
144: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
145: g_miss_patv_rec patv_rec_type;
146: TYPE patv_tbl_type IS TABLE OF patv_rec_type
147: INDEX BY BINARY_INTEGER;
140: creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142: last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
143: last_update_login NUMBER := OKC_API.G_MISS_NUM,
144: rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
145: g_miss_patv_rec patv_rec_type;
146: TYPE patv_tbl_type IS TABLE OF patv_rec_type
147: INDEX BY BINARY_INTEGER;
148: ---------------------------------------------------------------------------
147: INDEX BY BINARY_INTEGER;
148: ---------------------------------------------------------------------------
149: -- GLOBAL MESSAGE CONSTANTS
150: ---------------------------------------------------------------------------
151: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
148: ---------------------------------------------------------------------------
149: -- GLOBAL MESSAGE CONSTANTS
150: ---------------------------------------------------------------------------
151: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
149: -- GLOBAL MESSAGE CONSTANTS
150: ---------------------------------------------------------------------------
151: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
150: ---------------------------------------------------------------------------
151: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
151: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
162: G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
162: G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
163: G_UNIQUE_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNIQUE_KEY_ERROR';
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
162: G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
163: G_UNIQUE_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNIQUE_KEY_ERROR';
164: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
173: ---------------------------------------------------------------------------
174: -- GLOBAL VARIABLES
175: ---------------------------------------------------------------------------
176: G_PKG_NAME CONSTANT VARCHAR2(200) := 'PAT_PVT';
177: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
178: ---------------------------------------------------------------------------
179: -- Procedures and Functions
180: ---------------------------------------------------------------------------
181:
183: PROCEDURE change_version;
184: PROCEDURE api_copy;
185: PROCEDURE insert_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_patv_rec IN patv_rec_type,
192: x_patv_rec OUT NOCOPY patv_rec_type);
193:
194: PROCEDURE insert_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_patv_tbl IN patv_tbl_type,
201: x_patv_tbl OUT NOCOPY patv_tbl_type);
202:
203: PROCEDURE lock_row(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_patv_rec IN patv_rec_type);
209: p_patv_rec IN patv_rec_type);
210:
211: PROCEDURE lock_row(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_patv_tbl IN patv_tbl_type);
217: p_patv_tbl IN patv_tbl_type);
218:
219: PROCEDURE update_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_patv_rec IN patv_rec_type,
226: x_patv_rec OUT NOCOPY patv_rec_type);
227:
228: PROCEDURE update_row(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_patv_tbl IN patv_tbl_type,
235: x_patv_tbl OUT NOCOPY patv_tbl_type);
236:
237: PROCEDURE delete_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_patv_rec IN patv_rec_type);
243: p_patv_rec IN patv_rec_type);
244:
245: PROCEDURE delete_row(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_patv_tbl IN patv_tbl_type);
251: p_patv_tbl IN patv_tbl_type);
252:
253: PROCEDURE validate_row(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_patv_rec IN patv_rec_type);
259: p_patv_rec IN patv_rec_type);
260:
261: PROCEDURE validate_row(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_patv_tbl IN patv_tbl_type);