3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE pon_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE pon_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE pon_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE pon_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
9: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_PDT_OPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
10: optional_yn OKL_PDT_OPTS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_PDT_OPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_PDT_OPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_pon_rec pon_rec_type;
12: from_date OKL_PDT_OPTS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_PDT_OPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_pon_rec pon_rec_type;
20: TYPE pon_tbl_type IS TABLE OF pon_rec_type
13: to_date OKL_PDT_OPTS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_PDT_OPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_pon_rec pon_rec_type;
20: TYPE pon_tbl_type IS TABLE OF pon_rec_type
21: INDEX BY BINARY_INTEGER;
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_OPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_PDT_OPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_pon_rec pon_rec_type;
20: TYPE pon_tbl_type IS TABLE OF pon_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ponv_rec_type IS RECORD (
19: g_miss_pon_rec pon_rec_type;
20: TYPE pon_tbl_type IS TABLE OF pon_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ponv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
20: TYPE pon_tbl_type IS TABLE OF pon_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ponv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
21: INDEX BY BINARY_INTEGER;
22: TYPE ponv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
22: TYPE ponv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_OPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
26: pdt_id NUMBER := OKC_API.G_MISS_NUM,
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_OPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
27: from_date OKL_PDT_OPTS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_OPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ponv_rec ponv_rec_type;
28: to_date OKL_PDT_OPTS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_OPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ponv_rec ponv_rec_type;
36: TYPE ponv_tbl_type IS TABLE OF ponv_rec_type
29: optional_yn OKL_PDT_OPTS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_OPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ponv_rec ponv_rec_type;
36: TYPE ponv_tbl_type IS TABLE OF ponv_rec_type
37: INDEX BY BINARY_INTEGER;
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_OPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_OPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ponv_rec ponv_rec_type;
36: TYPE ponv_tbl_type IS TABLE OF ponv_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
52: ---------------------------------------------------------------------------
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
52: ---------------------------------------------------------------------------
53: -- GLOBAL EXCEPTION
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
52: ---------------------------------------------------------------------------
53: -- GLOBAL EXCEPTION
54: ---------------------------------------------------------------------------
66: ------TCHGS END--------------------------------------------------------------- ---------------------------------------------------------------------------
67: -- GLOBAL VARIABLES
68: ---------------------------------------------------------------------------
69: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PON_PVT';
70: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
71: ---------------------------------------------------------------------------
72: -- Procedures and Functions
73: ---------------------------------------------------------------------------
74:
76: PROCEDURE change_version;
77: PROCEDURE api_copy;
78: PROCEDURE insert_row(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_ponv_rec IN ponv_rec_type,
85: x_ponv_rec OUT NOCOPY ponv_rec_type);
86:
87: PROCEDURE insert_row(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_ponv_tbl IN ponv_tbl_type,
94: x_ponv_tbl OUT NOCOPY ponv_tbl_type);
95:
96: PROCEDURE lock_row(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_ponv_rec IN ponv_rec_type);
102: p_ponv_rec IN ponv_rec_type);
103:
104: PROCEDURE lock_row(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_ponv_tbl IN ponv_tbl_type);
110: p_ponv_tbl IN ponv_tbl_type);
111:
112: PROCEDURE update_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_ponv_rec IN ponv_rec_type,
119: x_ponv_rec OUT NOCOPY ponv_rec_type);
120:
121: PROCEDURE update_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_ponv_tbl IN ponv_tbl_type,
128: x_ponv_tbl OUT NOCOPY ponv_tbl_type);
129:
130: PROCEDURE delete_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_ponv_rec IN ponv_rec_type);
136: p_ponv_rec IN ponv_rec_type);
137:
138: PROCEDURE delete_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_ponv_tbl IN ponv_tbl_type);
144: p_ponv_tbl IN ponv_tbl_type);
145:
146: PROCEDURE validate_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_ponv_rec IN ponv_rec_type);
152: p_ponv_rec IN ponv_rec_type);
153:
154: PROCEDURE validate_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_ponv_tbl IN ponv_tbl_type);