3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
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,
4: -- GLOBAL DATASTRUCTURES
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,
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,
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,
16: pricing_attr_value_from OKC_PRICE_ADJ_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE := OKC_API.G_MISS_CHAR,
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,
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,
18: comparison_operator OKC_PRICE_ADJ_ATTRIBS.COMPARISON_OPERATOR%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,
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,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
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,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM);
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,
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;
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
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;
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 (
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,
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,
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,
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,
41: last_update_login NUMBER := OKC_API.G_MISS_NUM,
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,
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,
43: program_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,
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,
45: request_id 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,
45: request_id NUMBER := OKC_API.G_MISS_NUM,
46: object_version_number NUMBER := OKC_API.G_MISS_NUM);
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,
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;
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
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
49: INDEX BY BINARY_INTEGER;
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
49: INDEX BY BINARY_INTEGER;
50: ---------------------------------------------------------------------------
49: INDEX BY BINARY_INTEGER;
50: ---------------------------------------------------------------------------
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
50: ---------------------------------------------------------------------------
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
53: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
64: G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
64: G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
65: G_UNIQUE_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNIQUE_KEY_ERROR';
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
64: G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
65: G_UNIQUE_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNIQUE_KEY_ERROR';
66: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
75: ---------------------------------------------------------------------------
76: -- GLOBAL VARIABLES
77: ---------------------------------------------------------------------------
78: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PAA_PVT';
79: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
80: ---------------------------------------------------------------------------
81: -- Procedures and Functions
82: ---------------------------------------------------------------------------
83:
85: PROCEDURE change_version;
86: PROCEDURE api_copy;
87: PROCEDURE insert_row(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_paav_rec IN paav_rec_type,
94: x_paav_rec OUT NOCOPY paav_rec_type);
95:
96: PROCEDURE insert_row(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_paav_tbl IN paav_tbl_type,
103: x_paav_tbl OUT NOCOPY paav_tbl_type);
104:
105: PROCEDURE lock_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_paav_rec IN paav_rec_type);
111: p_paav_rec IN paav_rec_type);
112:
113: PROCEDURE lock_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_paav_tbl IN paav_tbl_type);
119: p_paav_tbl IN paav_tbl_type);
120:
121: PROCEDURE update_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_paav_rec IN paav_rec_type,
128: x_paav_rec OUT NOCOPY paav_rec_type);
129:
130: PROCEDURE update_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_paav_tbl IN paav_tbl_type,
137: x_paav_tbl OUT NOCOPY paav_tbl_type);
138:
139: PROCEDURE delete_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_paav_rec IN paav_rec_type);
145: p_paav_rec IN paav_rec_type);
146:
147: PROCEDURE delete_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_paav_tbl IN paav_tbl_type);
153: p_paav_tbl IN paav_tbl_type);
154:
155: PROCEDURE validate_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_paav_rec IN paav_rec_type);
161: p_paav_rec IN paav_rec_type);
162:
163: PROCEDURE validate_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_paav_tbl IN paav_tbl_type);