eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_QUA_PVT dependencies on OKC_API

Line 8: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,

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,

Line 9: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,

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,

Line 10: CREATED_BY 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,

Line 11: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,

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,

Line 12: LAST_UPDATED_BY 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,

Line 13: REQUEST_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,
17: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,

Line 14: PROGRAM_APPLICATION_ID 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,

Line 15: PROGRAM_ID 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,

Line 16: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_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,
20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,

Line 17: LAST_UPDATE_LOGIN 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,
21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,

Line 18: QUALIFIER_GROUPING_NO 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,
22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,

Line 19: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%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,

Line 20: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%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,

Line 21: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 22: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 23: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 24: QUALIFIER_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,

Line 25: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,

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,

Line 26: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,

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,

Line 27: CREATED_FROM_RULE_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,

Line 28: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,

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,

Line 29: LIST_HEADER_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,
33: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,

Line 30: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,

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,

Line 31: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%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,

Line 32: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%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,

Line 33: CONTEXT OKS_QUALIFIERS.CONTEXT%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,

Line 34: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%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,

Line 35: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%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,

Line 36: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%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,

Line 37: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%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,

Line 38: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%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,

Line 39: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%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,

Line 40: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%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,

Line 41: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%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,

Line 42: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%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,

Line 43: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%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,

Line 44: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%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,

Line 45: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%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,

Line 46: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%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,

Line 47: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%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,

Line 48: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%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,
52: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM

Line 49: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%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
53: );

Line 50: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%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: );
54:

Line 51: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,

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;

Line 52: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM

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

Line 59: QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,

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,

Line 60: CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,

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,

Line 61: CREATED_BY 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,

Line 62: LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,

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,

Line 63: LAST_UPDATED_BY 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,

Line 64: REQUEST_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,
68: LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,

Line 65: PROGRAM_APPLICATION_ID 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,

Line 66: PROGRAM_ID 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,

Line 67: PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_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,
71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,

Line 68: LAST_UPDATE_LOGIN 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,
72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,

Line 69: QUALIFIER_GROUPING_NO 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,
73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,

Line 70: QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%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,

Line 71: QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%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,

Line 72: QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 73: COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 74: EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 75: QUALIFIER_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,

Line 76: START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,

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,

Line 77: END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,

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,

Line 78: CREATED_FROM_RULE_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,

Line 79: QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,

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,

Line 80: LIST_HEADER_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,
84: CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,

Line 81: LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,

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,

Line 82: QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%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,

Line 83: QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%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,

Line 84: CONTEXT OKS_QUALIFIERS.CONTEXT%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,

Line 85: ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%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,

Line 86: ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%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,

Line 87: ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%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,

Line 88: ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%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,

Line 89: ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%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,

Line 90: ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%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,

Line 91: ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%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,

Line 92: ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%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,

Line 93: ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%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,

Line 94: ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%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,

Line 95: ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%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,

Line 96: ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%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,

Line 97: ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%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,

Line 98: ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%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,

Line 99: ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%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,
103: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM

Line 100: ACTIVE_FLAG OKS_QUALIFIERS.active_flag%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
104: );

Line 101: LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%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: );
105: g_miss_quav_rec quav_rec_type;

Line 102: QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,

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

Line 103: QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM

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;

Line 111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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;

Line 112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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;

Line 114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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;

Line 115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;

Line 117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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';

Line 118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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';

Line 119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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';

Line 120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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: ---------------------------------------------------------------------------

Line 133: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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:

Line 143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);