4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE qua_rec_type IS RECORD (
8: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
9: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
10: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE qua_rec_type IS RECORD (
8: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
9: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
10: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
6: ---------------------------------------------------------------------------
7: TYPE qua_rec_type IS RECORD (
8: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
9: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
10: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
7: TYPE qua_rec_type IS RECORD (
8: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
9: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
10: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
8: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
9: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
10: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
9: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
10: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
10: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
12: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
13: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
14: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
15: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
18: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
24: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
51: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
51: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
52: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
51: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
52: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
53: );
46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
51: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
52: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
53: );
54:
47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
51: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
52: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
53: );
54:
55: g_miss_qua_rec qua_rec_type;
48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
51: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
52: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
53: );
54:
55: g_miss_qua_rec qua_rec_type;
56: TYPE qua_tbl_type IS TABLE OF qua_rec_type
55: g_miss_qua_rec qua_rec_type;
56: TYPE qua_tbl_type IS TABLE OF qua_rec_type
57: INDEX BY BINARY_INTEGER;
58: TYPE quav_rec_type IS RECORD (
59: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
60: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
61: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
56: TYPE qua_tbl_type IS TABLE OF qua_rec_type
57: INDEX BY BINARY_INTEGER;
58: TYPE quav_rec_type IS RECORD (
59: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
60: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
61: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
57: INDEX BY BINARY_INTEGER;
58: TYPE quav_rec_type IS RECORD (
59: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
60: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
61: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
58: TYPE quav_rec_type IS RECORD (
59: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
60: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
61: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
59: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
60: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
61: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
60: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
61: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
61: CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
63: LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
64: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
65: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
66: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
69: QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
75: QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
102: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
102: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
103: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
102: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
103: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
104: );
97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
102: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
103: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
104: );
105: g_miss_quav_rec quav_rec_type;
98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
102: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
103: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
104: );
105: g_miss_quav_rec quav_rec_type;
106: TYPE quav_tbl_type IS TABLE OF quav_rec_type
99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
102: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
103: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
104: );
105: g_miss_quav_rec quav_rec_type;
106: TYPE quav_tbl_type IS TABLE OF quav_rec_type
107: INDEX BY BINARY_INTEGER;
107: INDEX BY BINARY_INTEGER;
108: ---------------------------------------------------------------------------
109: -- GLOBAL MESSAGE CONSTANTS
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
108: ---------------------------------------------------------------------------
109: -- GLOBAL MESSAGE CONSTANTS
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
109: -- GLOBAL MESSAGE CONSTANTS
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_QUALIFIERS_UNEXPECTED_ERROR';
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_QUALIFIERS_UNEXPECTED_ERROR';
122: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_QUALIFIERS_UNEXPECTED_ERROR';
122: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
123: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_QUALIFIERS_UNEXPECTED_ERROR';
122: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
123: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
124: ---------------------------------------------------------------------------
129: ---------------------------------------------------------------------------
130: -- GLOBAL VARIABLES
131: ---------------------------------------------------------------------------
132: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_QUA_PVT';
133: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
134: ---------------------------------------------------------------------------
135: -- Procedures and Functions
136: ---------------------------------------------------------------------------
137:
139: PROCEDURE change_version;
140: PROCEDURE api_copy;
141: PROCEDURE insert_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_quav_rec IN quav_rec_type,
148: x_quav_rec OUT NOCOPY quav_rec_type);
149:
150: PROCEDURE insert_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_quav_tbl IN quav_tbl_type,
157: x_quav_tbl OUT NOCOPY quav_tbl_type);
158:
159: PROCEDURE lock_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_quav_rec IN quav_rec_type);
165: p_quav_rec IN quav_rec_type);
166:
167: PROCEDURE lock_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_quav_tbl IN quav_tbl_type);
173: p_quav_tbl IN quav_tbl_type);
174:
175: PROCEDURE update_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_quav_rec IN quav_rec_type,
182: x_quav_rec OUT NOCOPY quav_rec_type);
183:
184: PROCEDURE update_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_quav_tbl IN quav_tbl_type,
191: x_quav_tbl OUT NOCOPY quav_tbl_type);
192:
193: PROCEDURE delete_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_quav_rec IN quav_rec_type);
199: p_quav_rec IN quav_rec_type);
200:
201: PROCEDURE delete_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_quav_tbl IN quav_tbl_type);
207: p_quav_tbl IN quav_tbl_type);
208:
209: PROCEDURE validate_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_quav_rec IN quav_rec_type);
215: p_quav_rec IN quav_rec_type);
216:
217: PROCEDURE validate_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_quav_tbl IN quav_tbl_type);