3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cnl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cnh_id NUMBER := OKC_API.G_MISS_NUM,
9: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cnl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cnh_id NUMBER := OKC_API.G_MISS_NUM,
9: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE cnl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cnh_id NUMBER := OKC_API.G_MISS_NUM,
9: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE cnl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cnh_id NUMBER := OKC_API.G_MISS_NUM,
9: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cnh_id NUMBER := OKC_API.G_MISS_NUM,
9: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
8: cnh_id NUMBER := OKC_API.G_MISS_NUM,
9: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
9: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
10: aae_id NUMBER := OKC_API.G_MISS_NUM,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
13: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: sortseq NUMBER := OKC_API.G_MISS_NUM,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
17: logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18: cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
20: created_by NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
21: creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
22: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: tolerance NUMBER := OKC_API.G_MISS_NUM,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: start_at NUMBER := OKC_API.G_MISS_NUM,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47: application_id NUMBER := OKC_API.G_MISS_NUM,
40: attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47: application_id NUMBER := OKC_API.G_MISS_NUM,
48: seeded_flag OKC_CONDITION_LINES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
41: attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47: application_id NUMBER := OKC_API.G_MISS_NUM,
48: seeded_flag OKC_CONDITION_LINES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_cnl_rec cnl_rec_type;
42: attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47: application_id NUMBER := OKC_API.G_MISS_NUM,
48: seeded_flag OKC_CONDITION_LINES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_cnl_rec cnl_rec_type;
50: TYPE cnl_tbl_type IS TABLE OF cnl_rec_type
43: attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47: application_id NUMBER := OKC_API.G_MISS_NUM,
48: seeded_flag OKC_CONDITION_LINES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_cnl_rec cnl_rec_type;
50: TYPE cnl_tbl_type IS TABLE OF cnl_rec_type
51: INDEX BY BINARY_INTEGER;
44: attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47: application_id NUMBER := OKC_API.G_MISS_NUM,
48: seeded_flag OKC_CONDITION_LINES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_cnl_rec cnl_rec_type;
50: TYPE cnl_tbl_type IS TABLE OF cnl_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE OkcConditionLinesTlRecType IS RECORD (
49: g_miss_cnl_rec cnl_rec_type;
50: TYPE cnl_tbl_type IS TABLE OF cnl_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE OkcConditionLinesTlRecType IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: language OKC_CONDITION_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
55: source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: TYPE cnl_tbl_type IS TABLE OF cnl_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE OkcConditionLinesTlRecType IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: language OKC_CONDITION_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
55: source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
51: INDEX BY BINARY_INTEGER;
52: TYPE OkcConditionLinesTlRecType IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: language OKC_CONDITION_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
55: source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: TYPE OkcConditionLinesTlRecType IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: language OKC_CONDITION_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
55: source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
53: id NUMBER := OKC_API.G_MISS_NUM,
54: language OKC_CONDITION_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
55: source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61: last_update_date OKC_CONDITION_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
54: language OKC_CONDITION_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
55: source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61: last_update_date OKC_CONDITION_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_update_login NUMBER := OKC_API.G_MISS_NUM);
55: source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61: last_update_date OKC_CONDITION_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_update_login NUMBER := OKC_API.G_MISS_NUM);
63: GMissOkcConditionLinesTlRec OkcConditionLinesTlRecType;
56: sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61: last_update_date OKC_CONDITION_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_update_login NUMBER := OKC_API.G_MISS_NUM);
63: GMissOkcConditionLinesTlRec OkcConditionLinesTlRecType;
64: TYPE OkcConditionLinesTlTblType IS TABLE OF OkcConditionLinesTlRecType
57: description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61: last_update_date OKC_CONDITION_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_update_login NUMBER := OKC_API.G_MISS_NUM);
63: GMissOkcConditionLinesTlRec OkcConditionLinesTlRecType;
64: TYPE OkcConditionLinesTlTblType IS TABLE OF OkcConditionLinesTlRecType
65: INDEX BY BINARY_INTEGER;
58: created_by NUMBER := OKC_API.G_MISS_NUM,
59: creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61: last_update_date OKC_CONDITION_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_update_login NUMBER := OKC_API.G_MISS_NUM);
63: GMissOkcConditionLinesTlRec OkcConditionLinesTlRecType;
64: TYPE OkcConditionLinesTlTblType IS TABLE OF OkcConditionLinesTlRecType
65: INDEX BY BINARY_INTEGER;
66: TYPE cnlv_rec_type IS RECORD (
63: GMissOkcConditionLinesTlRec OkcConditionLinesTlRecType;
64: TYPE OkcConditionLinesTlTblType IS TABLE OF OkcConditionLinesTlRecType
65: INDEX BY BINARY_INTEGER;
66: TYPE cnlv_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: object_version_number NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
64: TYPE OkcConditionLinesTlTblType IS TABLE OF OkcConditionLinesTlRecType
65: INDEX BY BINARY_INTEGER;
66: TYPE cnlv_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: object_version_number NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
65: INDEX BY BINARY_INTEGER;
66: TYPE cnlv_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: object_version_number NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
66: TYPE cnlv_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: object_version_number NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
67: id NUMBER := OKC_API.G_MISS_NUM,
68: object_version_number NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
68: object_version_number NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
70: cnh_id NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
71: pdf_id NUMBER := OKC_API.G_MISS_NUM,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
72: aae_id NUMBER := OKC_API.G_MISS_NUM,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
74: right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
75: left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
76: right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
78: sortseq NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
79: cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
80: description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
81: left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
82: relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: tolerance NUMBER := OKC_API.G_MISS_NUM,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: start_at NUMBER := OKC_API.G_MISS_NUM,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: application_id NUMBER := OKC_API.G_MISS_NUM,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
99: attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKC_CONDITION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKC_CONDITION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM);
103: attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKC_CONDITION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM);
111: g_miss_cnlv_rec cnlv_rec_type;
104: attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKC_CONDITION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM);
111: g_miss_cnlv_rec cnlv_rec_type;
112: TYPE cnlv_tbl_type IS TABLE OF cnlv_rec_type
105: attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKC_CONDITION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM);
111: g_miss_cnlv_rec cnlv_rec_type;
112: TYPE cnlv_tbl_type IS TABLE OF cnlv_rec_type
113: INDEX BY BINARY_INTEGER;
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKC_CONDITION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM);
111: g_miss_cnlv_rec cnlv_rec_type;
112: TYPE cnlv_tbl_type IS TABLE OF cnlv_rec_type
113: INDEX BY BINARY_INTEGER;
114: ---------------------------------------------------------------------------
113: INDEX BY BINARY_INTEGER;
114: ---------------------------------------------------------------------------
115: -- GLOBAL MESSAGE CONSTANTS
116: ---------------------------------------------------------------------------
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: ---------------------------------------------------------------------------
115: -- GLOBAL MESSAGE CONSTANTS
116: ---------------------------------------------------------------------------
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: -- GLOBAL MESSAGE CONSTANTS
116: ---------------------------------------------------------------------------
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: ---------------------------------------------------------------------------
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
118: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
119: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
120: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
128: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
121: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
128: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
129: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
122: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
128: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
129: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
130: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
135: ---------------------------------------------------------------------------
136: -- GLOBAL VARIABLES
137: ---------------------------------------------------------------------------
138: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CNL_PVT';
139: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
140: ---------------------------------------------------------------------------
141: -- Procedures and Functions
142: ---------------------------------------------------------------------------
143:
146: PROCEDURE api_copy;
147: PROCEDURE add_language;
148: PROCEDURE insert_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_cnlv_rec IN cnlv_rec_type,
155: x_cnlv_rec OUT NOCOPY cnlv_rec_type);
156:
157: PROCEDURE insert_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_cnlv_tbl IN cnlv_tbl_type,
164: x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
165:
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_cnlv_rec IN cnlv_rec_type);
172: p_cnlv_rec IN cnlv_rec_type);
173:
174: PROCEDURE lock_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_cnlv_tbl IN cnlv_tbl_type);
180: p_cnlv_tbl IN cnlv_tbl_type);
181:
182: PROCEDURE update_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_cnlv_rec IN cnlv_rec_type,
189: x_cnlv_rec OUT NOCOPY cnlv_rec_type);
190:
191: PROCEDURE update_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_cnlv_tbl IN cnlv_tbl_type,
198: x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
199:
200: PROCEDURE delete_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_cnlv_rec IN cnlv_rec_type);
206: p_cnlv_rec IN cnlv_rec_type);
207:
208: PROCEDURE delete_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_cnlv_tbl IN cnlv_tbl_type);
214: p_cnlv_tbl IN cnlv_tbl_type);
215:
216: PROCEDURE validate_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_cnlv_rec IN cnlv_rec_type);
222: p_cnlv_rec IN cnlv_rec_type);
223:
224: PROCEDURE validate_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_cnlv_tbl IN cnlv_tbl_type);