3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE opd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPERANDS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: fma_id NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE opd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPERANDS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: fma_id NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE opd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPERANDS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: fma_id NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
6: TYPE opd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPERANDS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: fma_id NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPERANDS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: fma_id NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
8: name OKL_OPERANDS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: fma_id NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
9: fma_id NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
10: dsf_id NUMBER := OKC_API.G_MISS_NUM,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
11: version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
12: opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: end_date OKL_OPERANDS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE);
15: start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: end_date OKL_OPERANDS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE);
23: g_miss_opd_rec opd_rec_type;
16: source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: end_date OKL_OPERANDS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE);
23: g_miss_opd_rec opd_rec_type;
24: TYPE opd_tbl_type IS TABLE OF opd_rec_type
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: end_date OKL_OPERANDS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE);
23: g_miss_opd_rec opd_rec_type;
24: TYPE opd_tbl_type IS TABLE OF opd_rec_type
25: INDEX BY BINARY_INTEGER;
18: creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: end_date OKL_OPERANDS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE);
23: g_miss_opd_rec opd_rec_type;
24: TYPE opd_tbl_type IS TABLE OF opd_rec_type
25: INDEX BY BINARY_INTEGER;
26: TYPE okl_operands_tl_rec_type IS RECORD (
23: g_miss_opd_rec opd_rec_type;
24: TYPE opd_tbl_type IS TABLE OF opd_rec_type
25: INDEX BY BINARY_INTEGER;
26: TYPE okl_operands_tl_rec_type IS RECORD (
27: id NUMBER := OKC_API.G_MISS_NUM,
28: language OKL_OPERANDS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
29: source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: TYPE opd_tbl_type IS TABLE OF opd_rec_type
25: INDEX BY BINARY_INTEGER;
26: TYPE okl_operands_tl_rec_type IS RECORD (
27: id NUMBER := OKC_API.G_MISS_NUM,
28: language OKL_OPERANDS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
29: source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
25: INDEX BY BINARY_INTEGER;
26: TYPE okl_operands_tl_rec_type IS RECORD (
27: id NUMBER := OKC_API.G_MISS_NUM,
28: language OKL_OPERANDS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
29: source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
26: TYPE okl_operands_tl_rec_type IS RECORD (
27: id NUMBER := OKC_API.G_MISS_NUM,
28: language OKL_OPERANDS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
29: source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
27: id NUMBER := OKC_API.G_MISS_NUM,
28: language OKL_OPERANDS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
29: source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_OPERANDS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
28: language OKL_OPERANDS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
29: source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_OPERANDS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
29: source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_OPERANDS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_okl_operands_tl_rec okl_operands_tl_rec_type;
30: sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_OPERANDS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_okl_operands_tl_rec okl_operands_tl_rec_type;
38: TYPE okl_operands_tl_tbl_type IS TABLE OF okl_operands_tl_rec_type
31: description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_OPERANDS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_okl_operands_tl_rec okl_operands_tl_rec_type;
38: TYPE okl_operands_tl_tbl_type IS TABLE OF okl_operands_tl_rec_type
39: INDEX BY BINARY_INTEGER;
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_OPERANDS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_okl_operands_tl_rec okl_operands_tl_rec_type;
38: TYPE okl_operands_tl_tbl_type IS TABLE OF okl_operands_tl_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE opdv_rec_type IS RECORD (
37: g_miss_okl_operands_tl_rec okl_operands_tl_rec_type;
38: TYPE okl_operands_tl_tbl_type IS TABLE OF okl_operands_tl_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE opdv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
38: TYPE okl_operands_tl_tbl_type IS TABLE OF okl_operands_tl_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE opdv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
39: INDEX BY BINARY_INTEGER;
40: TYPE opdv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
40: TYPE opdv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
43: sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
44: fma_id NUMBER := OKC_API.G_MISS_NUM,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
45: dsf_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
46: name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
47: description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_OPERANDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_OPERANDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_OPERANDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_opdv_rec opdv_rec_type;
52: opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_OPERANDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_opdv_rec opdv_rec_type;
60: TYPE opdv_tbl_type IS TABLE OF opdv_rec_type
53: org_id NUMBER := OKC_API.G_MISS_NUM,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_OPERANDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_opdv_rec opdv_rec_type;
60: TYPE opdv_tbl_type IS TABLE OF opdv_rec_type
61: INDEX BY BINARY_INTEGER;
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_OPERANDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_opdv_rec opdv_rec_type;
60: TYPE opdv_tbl_type IS TABLE OF opdv_rec_type
61: INDEX BY BINARY_INTEGER;
62: ---------------------------------------------------------------------------
61: INDEX BY BINARY_INTEGER;
62: ---------------------------------------------------------------------------
63: -- GLOBAL MESSAGE CONSTANTS
64: ---------------------------------------------------------------------------
65: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
66: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
67: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: ---------------------------------------------------------------------------
63: -- GLOBAL MESSAGE CONSTANTS
64: ---------------------------------------------------------------------------
65: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
66: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
67: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: -- GLOBAL MESSAGE CONSTANTS
64: ---------------------------------------------------------------------------
65: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
66: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
67: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: ---------------------------------------------------------------------------
65: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
66: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
67: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
66: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
67: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
73: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
67: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
73: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
74: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
73: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
74: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
75:
68: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
73: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
74: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
75:
76: --RPOONUGA001: Added the following
69: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
73: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
74: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
75:
76: --RPOONUGA001: Added the following
77: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
73: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
74: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
75:
76: --RPOONUGA001: Added the following
77: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
78: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
86: ---------------------------------------------------------------------------
87: -- GLOBAL VARIABLES
88: ---------------------------------------------------------------------------
89: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OPD_PVT';
90: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
91: --RPOONUGA001: Added the following
92: G_FORMULA_TYPE CONSTANT VARCHAR2(10) := 'FMLA';
93: G_FUNCTION_TYPE CONSTANT VARCHAR2(10) := 'FCNT';
94: G_CONSTANT_TYPE CONSTANT VARCHAR2(10) := 'CNST';
107: PROCEDURE api_copy;
108: PROCEDURE add_language;
109: PROCEDURE insert_row(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_opdv_rec IN opdv_rec_type,
116: x_opdv_rec OUT NOCOPY opdv_rec_type);
117:
118: PROCEDURE insert_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_opdv_tbl IN opdv_tbl_type,
125: x_opdv_tbl OUT NOCOPY opdv_tbl_type);
126:
127: PROCEDURE lock_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_opdv_rec IN opdv_rec_type);
133: p_opdv_rec IN opdv_rec_type);
134:
135: PROCEDURE lock_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_opdv_tbl IN opdv_tbl_type);
141: p_opdv_tbl IN opdv_tbl_type);
142:
143: PROCEDURE update_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_opdv_rec IN opdv_rec_type,
150: x_opdv_rec OUT NOCOPY opdv_rec_type);
151:
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_opdv_tbl IN opdv_tbl_type,
159: x_opdv_tbl OUT NOCOPY opdv_tbl_type);
160:
161: PROCEDURE delete_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_opdv_rec IN opdv_rec_type);
167: p_opdv_rec IN opdv_rec_type);
168:
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_opdv_tbl IN opdv_tbl_type);
175: p_opdv_tbl IN opdv_tbl_type);
176:
177: PROCEDURE validate_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_opdv_rec IN opdv_rec_type);
183: p_opdv_rec IN opdv_rec_type);
184:
185: PROCEDURE validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_opdv_tbl IN opdv_tbl_type);