5: ---------------------------------------------------------------------------
6: TYPE agn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: line_number NUMBER := Okc_Api.G_MISS_NUM,
9: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
10: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
6: TYPE agn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: line_number NUMBER := Okc_Api.G_MISS_NUM,
9: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
10: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: line_number NUMBER := Okc_Api.G_MISS_NUM,
9: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
10: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
8: line_number NUMBER := Okc_Api.G_MISS_NUM,
9: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
10: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
16: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
9: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
10: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
16: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
16: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
16: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: org_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
13: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
16: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: org_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
16: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: org_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
17: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: org_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCRUAL_GNRTNS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
25: g_miss_agn_rec agn_rec_type;
19: org_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCRUAL_GNRTNS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
25: g_miss_agn_rec agn_rec_type;
26: TYPE agn_tbl_type IS TABLE OF agn_rec_type
27: INDEX BY BINARY_INTEGER;
27: INDEX BY BINARY_INTEGER;
28: TYPE agnv_rec_type IS RECORD (
29: id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
32: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
34: line_number NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
28: TYPE agnv_rec_type IS RECORD (
29: id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
32: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
34: line_number NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
29: id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
32: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
34: line_number NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
37: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
31: aro_code OKL_ACCRUAL_GNRTNS.ARO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
32: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
34: line_number NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
37: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
38: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
39: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
32: arlo_code OKL_ACCRUAL_GNRTNS.ARLO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
34: line_number NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
37: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
38: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
39: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
33: acro_code OKL_ACCRUAL_GNRTNS.ACRO_CODE%TYPE := Okc_Api.G_MISS_CHAR,
34: line_number NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
37: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
38: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
39: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: org_id NUMBER := Okc_Api.G_MISS_NUM,
34: line_number NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
37: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
38: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
39: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: org_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: version OKL_ACCRUAL_GNRTNS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
37: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
38: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
39: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: org_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: left_parentheses OKL_ACCRUAL_GNRTNS.LEFT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
37: right_operand_literal OKL_ACCRUAL_GNRTNS.RIGHT_OPERAND_LITERAL%TYPE := Okc_Api.G_MISS_CHAR,
38: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%TYPE := Okc_Api.G_MISS_CHAR,
39: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: org_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
39: from_date OKL_ACCRUAL_GNRTNS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: TO_DATE OKL_ACCRUAL_GNRTNS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: org_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCRUAL_GNRTNS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
47: g_miss_agnv_rec agnv_rec_type;
41: org_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCRUAL_GNRTNS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCRUAL_GNRTNS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
47: g_miss_agnv_rec agnv_rec_type;
48: TYPE agnv_tbl_type IS TABLE OF agnv_rec_type
49: INDEX BY BINARY_INTEGER;