[Home] [Help]
5: ---------------------------------------------------------------------------
6: TYPE paa_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_id NUMBER := OKC_API.G_MISS_NUM,
9: flex_title OKC_PRICE_ADJ_ATTRIBS.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
10: pricing_context OKC_PRICE_ADJ_ATTRIBS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
11: pricing_attribute OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKC_PRICE_ADJ_ATTRIBS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE paa_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_id NUMBER := OKC_API.G_MISS_NUM,
9: flex_title OKC_PRICE_ADJ_ATTRIBS.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
10: pricing_context OKC_PRICE_ADJ_ATTRIBS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
11: pricing_attribute OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKC_PRICE_ADJ_ATTRIBS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: pat_id NUMBER := OKC_API.G_MISS_NUM,
9: flex_title OKC_PRICE_ADJ_ATTRIBS.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
10: pricing_context OKC_PRICE_ADJ_ATTRIBS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
11: pricing_attribute OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKC_PRICE_ADJ_ATTRIBS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKC_PRICE_ADJ_ATTRIBS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: flex_title OKC_PRICE_ADJ_ATTRIBS.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
10: pricing_context OKC_PRICE_ADJ_ATTRIBS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
11: pricing_attribute OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKC_PRICE_ADJ_ATTRIBS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKC_PRICE_ADJ_ATTRIBS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
17: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
11: pricing_attribute OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKC_PRICE_ADJ_ATTRIBS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKC_PRICE_ADJ_ATTRIBS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
17: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
18: comparison_operator OKC_PRICE_ADJ_ATTRIBS.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKC_PRICE_ADJ_ATTRIBS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKC_PRICE_ADJ_ATTRIBS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
17: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
18: comparison_operator OKC_PRICE_ADJ_ATTRIBS.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKC_PRICE_ADJ_ATTRIBS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKC_PRICE_ADJ_ATTRIBS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
17: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
18: comparison_operator OKC_PRICE_ADJ_ATTRIBS.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: program_id NUMBER := OKC_API.G_MISS_NUM,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKC_PRICE_ADJ_ATTRIBS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
17: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
18: comparison_operator OKC_PRICE_ADJ_ATTRIBS.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: program_id NUMBER := OKC_API.G_MISS_NUM,
22: program_update_date OKC_PRICE_ADJ_ATTRIBS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: comparison_operator OKC_PRICE_ADJ_ATTRIBS.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: program_id NUMBER := OKC_API.G_MISS_NUM,
22: program_update_date OKC_PRICE_ADJ_ATTRIBS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM);
25: g_miss_paa_rec paa_rec_type;
26: TYPE paa_tbl_type IS TABLE OF paa_rec_type
27: INDEX BY BINARY_INTEGER;
28: TYPE paav_rec_type IS RECORD (
29: id NUMBER := OKC_API.G_MISS_NUM,
30: pat_id NUMBER := OKC_API.G_MISS_NUM,
31: flex_title OKC_PRICE_ADJ_ATTRIBS_V.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
32: pricing_context OKC_PRICE_ADJ_ATTRIBS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
33: pricing_attribute OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
34: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
35: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
28: TYPE paav_rec_type IS RECORD (
29: id NUMBER := OKC_API.G_MISS_NUM,
30: pat_id NUMBER := OKC_API.G_MISS_NUM,
31: flex_title OKC_PRICE_ADJ_ATTRIBS_V.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
32: pricing_context OKC_PRICE_ADJ_ATTRIBS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
33: pricing_attribute OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
34: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
35: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
36: comparison_operator OKC_PRICE_ADJ_ATTRIBS_V.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
29: id NUMBER := OKC_API.G_MISS_NUM,
30: pat_id NUMBER := OKC_API.G_MISS_NUM,
31: flex_title OKC_PRICE_ADJ_ATTRIBS_V.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
32: pricing_context OKC_PRICE_ADJ_ATTRIBS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
33: pricing_attribute OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
34: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
35: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
36: comparison_operator OKC_PRICE_ADJ_ATTRIBS_V.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
37: created_by NUMBER := OKC_API.G_MISS_NUM,
30: pat_id NUMBER := OKC_API.G_MISS_NUM,
31: flex_title OKC_PRICE_ADJ_ATTRIBS_V.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
32: pricing_context OKC_PRICE_ADJ_ATTRIBS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
33: pricing_attribute OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
34: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
35: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
36: comparison_operator OKC_PRICE_ADJ_ATTRIBS_V.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
37: created_by NUMBER := OKC_API.G_MISS_NUM,
38: creation_date OKC_PRICE_ADJ_ATTRIBS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: flex_title OKC_PRICE_ADJ_ATTRIBS_V.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
32: pricing_context OKC_PRICE_ADJ_ATTRIBS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
33: pricing_attribute OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
34: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
35: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
36: comparison_operator OKC_PRICE_ADJ_ATTRIBS_V.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
37: created_by NUMBER := OKC_API.G_MISS_NUM,
38: creation_date OKC_PRICE_ADJ_ATTRIBS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: pricing_context OKC_PRICE_ADJ_ATTRIBS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
33: pricing_attribute OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
34: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
35: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
36: comparison_operator OKC_PRICE_ADJ_ATTRIBS_V.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
37: created_by NUMBER := OKC_API.G_MISS_NUM,
38: creation_date OKC_PRICE_ADJ_ATTRIBS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
40: last_update_date OKC_PRICE_ADJ_ATTRIBS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
35: pricing_attr_value_to OKC_PRICE_ADJ_ATTRIBS_V.PRICING_ATTR_VALUE_TO%TYPE := OKC_API.G_MISS_CHAR,
36: comparison_operator OKC_PRICE_ADJ_ATTRIBS_V.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
37: created_by NUMBER := OKC_API.G_MISS_NUM,
38: creation_date OKC_PRICE_ADJ_ATTRIBS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
40: last_update_date OKC_PRICE_ADJ_ATTRIBS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_update_login NUMBER := OKC_API.G_MISS_NUM,
42: program_application_id NUMBER := OKC_API.G_MISS_NUM,
36: comparison_operator OKC_PRICE_ADJ_ATTRIBS_V.COMPARISON_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
37: created_by NUMBER := OKC_API.G_MISS_NUM,
38: creation_date OKC_PRICE_ADJ_ATTRIBS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
40: last_update_date OKC_PRICE_ADJ_ATTRIBS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_update_login NUMBER := OKC_API.G_MISS_NUM,
42: program_application_id NUMBER := OKC_API.G_MISS_NUM,
43: program_id NUMBER := OKC_API.G_MISS_NUM,
44: program_update_date OKC_PRICE_ADJ_ATTRIBS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_update_date OKC_PRICE_ADJ_ATTRIBS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_update_login NUMBER := OKC_API.G_MISS_NUM,
42: program_application_id NUMBER := OKC_API.G_MISS_NUM,
43: program_id NUMBER := OKC_API.G_MISS_NUM,
44: program_update_date OKC_PRICE_ADJ_ATTRIBS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: request_id NUMBER := OKC_API.G_MISS_NUM,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM);
47: g_miss_paav_rec paav_rec_type;
48: TYPE paav_tbl_type IS TABLE OF paav_rec_type