4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_PROD_STRM_TYPES_V Record Spec
7: TYPE psyv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,from_date OKL_PROD_STRM_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- OKL_PROD_STRM_TYPES_V Record Spec
7: TYPE psyv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,from_date OKL_PROD_STRM_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
6: -- OKL_PROD_STRM_TYPES_V Record Spec
7: TYPE psyv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,from_date OKL_PROD_STRM_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE psyv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,from_date OKL_PROD_STRM_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,from_date OKL_PROD_STRM_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
9: ,from_date OKL_PROD_STRM_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
19: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
12: ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
19: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: G_MISS_psyv_rec psyv_rec_type;
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
19: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: G_MISS_psyv_rec psyv_rec_type;
21: TYPE psyv_tbl_type IS TABLE OF psyv_rec_type
14: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
19: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: G_MISS_psyv_rec psyv_rec_type;
21: TYPE psyv_tbl_type IS TABLE OF psyv_rec_type
22: INDEX BY BINARY_INTEGER;
15: ,created_by NUMBER := OKC_API.G_MISS_NUM
16: ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
19: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: G_MISS_psyv_rec psyv_rec_type;
21: TYPE psyv_tbl_type IS TABLE OF psyv_rec_type
22: INDEX BY BINARY_INTEGER;
23: -- OKL_PROD_STRM_TYPES Record Spec
21: TYPE psyv_tbl_type IS TABLE OF psyv_rec_type
22: INDEX BY BINARY_INTEGER;
23: -- OKL_PROD_STRM_TYPES Record Spec
24: TYPE psy_rec_type IS RECORD (
25: id NUMBER := OKC_API.G_MISS_NUM
26: ,TO_DATE OKL_PROD_STRM_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
22: INDEX BY BINARY_INTEGER;
23: -- OKL_PROD_STRM_TYPES Record Spec
24: TYPE psy_rec_type IS RECORD (
25: id NUMBER := OKC_API.G_MISS_NUM
26: ,TO_DATE OKL_PROD_STRM_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
23: -- OKL_PROD_STRM_TYPES Record Spec
24: TYPE psy_rec_type IS RECORD (
25: id NUMBER := OKC_API.G_MISS_NUM
26: ,TO_DATE OKL_PROD_STRM_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: TYPE psy_rec_type IS RECORD (
25: id NUMBER := OKC_API.G_MISS_NUM
26: ,TO_DATE OKL_PROD_STRM_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
25: id NUMBER := OKC_API.G_MISS_NUM
26: ,TO_DATE OKL_PROD_STRM_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,TO_DATE OKL_PROD_STRM_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
27: ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKL_PROD_STRM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
28: ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKL_PROD_STRM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
29: ,sty_id NUMBER := OKC_API.G_MISS_NUM
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKL_PROD_STRM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: G_MISS_psy_rec psy_rec_type;
30: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKL_PROD_STRM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: G_MISS_psy_rec psy_rec_type;
38: TYPE psy_tbl_type IS TABLE OF psy_rec_type
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKL_PROD_STRM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: G_MISS_psy_rec psy_rec_type;
38: TYPE psy_tbl_type IS TABLE OF psy_rec_type
39: INDEX BY BINARY_INTEGER;
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKL_PROD_STRM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: G_MISS_psy_rec psy_rec_type;
38: TYPE psy_tbl_type IS TABLE OF psy_rec_type
39: INDEX BY BINARY_INTEGER;
40: ---------------------------------------------------------------------------
39: INDEX BY BINARY_INTEGER;
40: ---------------------------------------------------------------------------
41: -- GLOBAL MESSAGE CONSTANTS
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
40: ---------------------------------------------------------------------------
41: -- GLOBAL MESSAGE CONSTANTS
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
41: -- GLOBAL MESSAGE CONSTANTS
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
54: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
54: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
55: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
54: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
55: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
56: G_TO_DATE_ERROR CONSTANT VARCHAR2(200) := 'OKL_TO_DATE_ERROR';
66: ---------------------------------------------------------------------------
67: -- GLOBAL VARIABLES
68: ---------------------------------------------------------------------------
69: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PSY_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_psyv_rec IN psyv_rec_type,
84: p_psyv_rec IN psyv_rec_type,
85: x_psyv_rec OUT NOCOPY psyv_rec_type);
86: PROCEDURE insert_row(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_psyv_tbl IN psyv_tbl_type,
93: x_psyv_tbl OUT NOCOPY psyv_tbl_type,
94: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
95: PROCEDURE insert_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_psyv_tbl IN psyv_tbl_type,
101: p_psyv_tbl IN psyv_tbl_type,
102: x_psyv_tbl OUT NOCOPY psyv_tbl_type);
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_psyv_rec IN psyv_rec_type);
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_psyv_rec IN psyv_rec_type);
110: PROCEDURE lock_row(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_psyv_tbl IN psyv_tbl_type,
116: p_psyv_tbl IN psyv_tbl_type,
117: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
118: PROCEDURE lock_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_psyv_tbl IN psyv_tbl_type);
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_psyv_tbl IN psyv_tbl_type);
125: PROCEDURE update_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_psyv_rec IN psyv_rec_type,
131: p_psyv_rec IN psyv_rec_type,
132: x_psyv_rec OUT NOCOPY psyv_rec_type);
133: PROCEDURE update_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_psyv_tbl IN psyv_tbl_type,
140: x_psyv_tbl OUT NOCOPY psyv_tbl_type,
141: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
142: PROCEDURE update_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_psyv_tbl IN psyv_tbl_type,
148: p_psyv_tbl IN psyv_tbl_type,
149: x_psyv_tbl OUT NOCOPY psyv_tbl_type);
150: PROCEDURE delete_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_psyv_rec IN psyv_rec_type);
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_psyv_rec IN psyv_rec_type);
157: PROCEDURE delete_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_psyv_tbl IN psyv_tbl_type,
163: p_psyv_tbl IN psyv_tbl_type,
164: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_psyv_tbl IN psyv_tbl_type);
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_psyv_tbl IN psyv_tbl_type);
172: PROCEDURE validate_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_psyv_rec IN psyv_rec_type);
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_psyv_rec IN psyv_rec_type);
179: PROCEDURE validate_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_psyv_tbl IN psyv_tbl_type,
185: p_psyv_tbl IN psyv_tbl_type,
186: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
187: PROCEDURE validate_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_psyv_tbl IN psyv_tbl_type);