3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE OkcProcessDefParmsTlRecType IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEF_PARMS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE OkcProcessDefParmsTlRecType IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEF_PARMS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE OkcProcessDefParmsTlRecType IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEF_PARMS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE OkcProcessDefParmsTlRecType IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEF_PARMS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEF_PARMS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEF_PARMS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PROCESS_DEF_PARMS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PROCESS_DEF_PARMS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
10: sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PROCESS_DEF_PARMS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: GMissOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
11: name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PROCESS_DEF_PARMS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: GMissOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
19: TYPE OkcProcessDefParmsTlTblType IS TABLE OF OkcProcessDefParmsTlRecType
12: description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PROCESS_DEF_PARMS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: GMissOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
19: TYPE OkcProcessDefParmsTlTblType IS TABLE OF OkcProcessDefParmsTlRecType
20: INDEX BY BINARY_INTEGER;
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_PROCESS_DEF_PARMS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: GMissOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
19: TYPE OkcProcessDefParmsTlTblType IS TABLE OF OkcProcessDefParmsTlRecType
20: INDEX BY BINARY_INTEGER;
21: TYPE pdp_rec_type IS RECORD (
18: GMissOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
19: TYPE OkcProcessDefParmsTlTblType IS TABLE OF OkcProcessDefParmsTlRecType
20: INDEX BY BINARY_INTEGER;
21: TYPE pdp_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: pdf_id NUMBER := OKC_API.G_MISS_NUM,
24: name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
19: TYPE OkcProcessDefParmsTlTblType IS TABLE OF OkcProcessDefParmsTlRecType
20: INDEX BY BINARY_INTEGER;
21: TYPE pdp_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: pdf_id NUMBER := OKC_API.G_MISS_NUM,
24: name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: INDEX BY BINARY_INTEGER;
21: TYPE pdp_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: pdf_id NUMBER := OKC_API.G_MISS_NUM,
24: name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
21: TYPE pdp_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: pdf_id NUMBER := OKC_API.G_MISS_NUM,
24: name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: id NUMBER := OKC_API.G_MISS_NUM,
23: pdf_id NUMBER := OKC_API.G_MISS_NUM,
24: name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: pdf_id NUMBER := OKC_API.G_MISS_NUM,
24: name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
25: data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
27: object_version_number NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: NAME_COLUMN OKC_PROCESS_DEF_PARMS_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: NAME_COLUMN OKC_PROCESS_DEF_PARMS_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
38: description_column OKC_PROCESS_DEF_PARMS_B.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
31: last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: NAME_COLUMN OKC_PROCESS_DEF_PARMS_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
38: description_column OKC_PROCESS_DEF_PARMS_B.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_pdp_rec pdp_rec_type;
32: default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: NAME_COLUMN OKC_PROCESS_DEF_PARMS_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
38: description_column OKC_PROCESS_DEF_PARMS_B.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_pdp_rec pdp_rec_type;
40: TYPE pdp_tbl_type IS TABLE OF pdp_rec_type
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: NAME_COLUMN OKC_PROCESS_DEF_PARMS_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
38: description_column OKC_PROCESS_DEF_PARMS_B.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_pdp_rec pdp_rec_type;
40: TYPE pdp_tbl_type IS TABLE OF pdp_rec_type
41: INDEX BY BINARY_INTEGER;
34: application_id NUMBER := OKC_API.G_MISS_NUM,
35: seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: NAME_COLUMN OKC_PROCESS_DEF_PARMS_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
38: description_column OKC_PROCESS_DEF_PARMS_B.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_pdp_rec pdp_rec_type;
40: TYPE pdp_tbl_type IS TABLE OF pdp_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE pdpv_rec_type IS RECORD (
39: g_miss_pdp_rec pdp_rec_type;
40: TYPE pdp_tbl_type IS TABLE OF pdp_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE pdpv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: TYPE pdp_tbl_type IS TABLE OF pdp_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE pdpv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
41: INDEX BY BINARY_INTEGER;
42: TYPE pdpv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: TYPE pdpv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63: g_miss_pdpv_rec pdpv_rec_type;
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63: g_miss_pdpv_rec pdpv_rec_type;
64: TYPE pdpv_tbl_type IS TABLE OF pdpv_rec_type
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63: g_miss_pdpv_rec pdpv_rec_type;
64: TYPE pdpv_tbl_type IS TABLE OF pdpv_rec_type
65: INDEX BY BINARY_INTEGER;
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63: g_miss_pdpv_rec pdpv_rec_type;
64: TYPE pdpv_tbl_type IS TABLE OF pdpv_rec_type
65: INDEX BY BINARY_INTEGER;
66: ---------------------------------------------------------------------------
65: INDEX BY BINARY_INTEGER;
66: ---------------------------------------------------------------------------
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
66: ---------------------------------------------------------------------------
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
69: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
79: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
79: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
80: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
79: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
80: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
81: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
79: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
80: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
81: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
82: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
84: ---------------------------------------------------------------------------
85: -- GLOBAL VARIABLES
86: ---------------------------------------------------------------------------
87: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PDP_PVT';
88: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_PROCESS_DEF_PARAMETERS_V';
90: ---------------------------------------------------------------------------
91: -- GLOBAL EXCEPTION
92: ---------------------------------------------------------------------------
101: PROCEDURE api_copy;
102: PROCEDURE add_language;
103: PROCEDURE insert_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_pdpv_rec IN pdpv_rec_type,
110: x_pdpv_rec OUT NOCOPY pdpv_rec_type);
111:
112: PROCEDURE insert_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_pdpv_tbl IN pdpv_tbl_type,
119: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
120:
121: PROCEDURE lock_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_pdpv_rec IN pdpv_rec_type);
127: p_pdpv_rec IN pdpv_rec_type);
128:
129: PROCEDURE lock_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_pdpv_tbl IN pdpv_tbl_type);
135: p_pdpv_tbl IN pdpv_tbl_type);
136:
137: PROCEDURE update_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_pdpv_rec IN pdpv_rec_type,
144: x_pdpv_rec OUT NOCOPY pdpv_rec_type);
145:
146: PROCEDURE update_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_pdpv_tbl IN pdpv_tbl_type,
153: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
154:
155: PROCEDURE delete_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_pdpv_rec IN pdpv_rec_type);
161: p_pdpv_rec IN pdpv_rec_type);
162:
163: PROCEDURE delete_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_pdpv_tbl IN pdpv_tbl_type);
169: p_pdpv_tbl IN pdpv_tbl_type);
170:
171: PROCEDURE validate_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_pdpv_rec IN pdpv_rec_type);
177: p_pdpv_rec IN pdpv_rec_type);
178:
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_pdpv_tbl IN pdpv_tbl_type);