3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
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,
4: -- GLOBAL DATASTRUCTURES
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,
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,
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,
18: TO_DATE OKL_ACCRUAL_GNRTNS.TO_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,
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,
23: last_update_date OKL_ACCRUAL_GNRTNS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
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,
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);
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;
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;
26: TYPE agn_tbl_type IS TABLE OF 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;
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;
28: TYPE agnv_rec_type IS RECORD (
25: g_miss_agn_rec agn_rec_type;
26: TYPE agn_tbl_type IS TABLE OF agn_rec_type
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,
26: TYPE agn_tbl_type IS TABLE OF agn_rec_type
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,
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,
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,
38: right_parentheses OKL_ACCRUAL_GNRTNS.RIGHT_PARENTHESES%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,
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,
45: last_update_date OKL_ACCRUAL_GNRTNS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
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,
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);
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;
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;
48: TYPE agnv_tbl_type IS TABLE OF 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;
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;
50: ---------------------------------------------------------------------------
49: INDEX BY BINARY_INTEGER;
50: ---------------------------------------------------------------------------
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
50: ---------------------------------------------------------------------------
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
66: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_AGN_ELEMENT_NOT_UNIQUE';
73: ---------------------------------------------------------------------------
74: -- GLOBAL VARIABLES
75: ---------------------------------------------------------------------------
76: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AGN_PVT';
77: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
78: ---------------------------------------------------------------------------
79: -- Procedures and Functions
80: ---------------------------------------------------------------------------
81:
83: Procedure change_version;
84: Procedure api_copy;
85: Procedure insert_row(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_agnv_rec IN agnv_rec_type,
92: x_agnv_rec OUT NOCOPY agnv_rec_type);
93:
94: Procedure insert_row(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_agnv_tbl IN agnv_tbl_type,
101: x_agnv_tbl OUT NOCOPY agnv_tbl_type);
102:
103: Procedure lock_row(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_agnv_rec IN agnv_rec_type);
109: p_agnv_rec IN agnv_rec_type);
110:
111: Procedure lock_row(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_agnv_tbl IN agnv_tbl_type);
117: p_agnv_tbl IN agnv_tbl_type);
118:
119: Procedure update_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_agnv_rec IN agnv_rec_type,
126: x_agnv_rec OUT NOCOPY agnv_rec_type);
127:
128: Procedure update_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_agnv_tbl IN agnv_tbl_type,
135: x_agnv_tbl OUT NOCOPY agnv_tbl_type);
136:
137: Procedure delete_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_agnv_rec IN agnv_rec_type);
143: p_agnv_rec IN agnv_rec_type);
144:
145: Procedure delete_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_agnv_tbl IN agnv_tbl_type);
151: p_agnv_tbl IN agnv_tbl_type);
152:
153: Procedure validate_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_agnv_rec IN agnv_rec_type);
159: p_agnv_rec IN agnv_rec_type);
160:
161: Procedure validate_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_agnv_tbl IN agnv_tbl_type);