4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_TEMPLATE_SET_V Record Spec
7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
5: ---------------------------------------------------------------------------
6: -- OKS_TEMPLATE_SET_V Record Spec
7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
6: -- OKS_TEMPLATE_SET_V Record Spec
7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
24: G_MISS_tmsv_rec tmsv_rec_type;
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
24: G_MISS_tmsv_rec tmsv_rec_type;
25: TYPE tmsv_tbl_type IS TABLE OF tmsv_rec_type
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
24: G_MISS_tmsv_rec tmsv_rec_type;
25: TYPE tmsv_tbl_type IS TABLE OF tmsv_rec_type
26: INDEX BY BINARY_INTEGER;
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
24: G_MISS_tmsv_rec tmsv_rec_type;
25: TYPE tmsv_tbl_type IS TABLE OF tmsv_rec_type
26: INDEX BY BINARY_INTEGER;
27: -- OKS_TEMPLATE_SET Record Spec
25: TYPE tmsv_tbl_type IS TABLE OF tmsv_rec_type
26: INDEX BY BINARY_INTEGER;
27: -- OKS_TEMPLATE_SET Record Spec
28: TYPE tms_rec_type IS RECORD (
29: id NUMBER := OKC_API.G_MISS_NUM
30: ,name OKS_TEMPLATE_SET.NAME%TYPE := OKC_API.G_MISS_CHAR
31: ,description OKS_TEMPLATE_SET.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
26: INDEX BY BINARY_INTEGER;
27: -- OKS_TEMPLATE_SET Record Spec
28: TYPE tms_rec_type IS RECORD (
29: id NUMBER := OKC_API.G_MISS_NUM
30: ,name OKS_TEMPLATE_SET.NAME%TYPE := OKC_API.G_MISS_CHAR
31: ,description OKS_TEMPLATE_SET.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
27: -- OKS_TEMPLATE_SET Record Spec
28: TYPE tms_rec_type IS RECORD (
29: id NUMBER := OKC_API.G_MISS_NUM
30: ,name OKS_TEMPLATE_SET.NAME%TYPE := OKC_API.G_MISS_CHAR
31: ,description OKS_TEMPLATE_SET.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
28: TYPE tms_rec_type IS RECORD (
29: id NUMBER := OKC_API.G_MISS_NUM
30: ,name OKS_TEMPLATE_SET.NAME%TYPE := OKC_API.G_MISS_CHAR
31: ,description OKS_TEMPLATE_SET.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
29: id NUMBER := OKC_API.G_MISS_NUM
30: ,name OKS_TEMPLATE_SET.NAME%TYPE := OKC_API.G_MISS_CHAR
31: ,description OKS_TEMPLATE_SET.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
30: ,name OKS_TEMPLATE_SET.NAME%TYPE := OKC_API.G_MISS_CHAR
31: ,description OKS_TEMPLATE_SET.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
31: ,description OKS_TEMPLATE_SET.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,start_date OKS_TEMPLATE_SET.START_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,end_date OKS_TEMPLATE_SET.END_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34: ,org_id NUMBER := OKC_API.G_MISS_NUM
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
42: ,last_update_date OKS_TEMPLATE_SET.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
42: ,last_update_date OKS_TEMPLATE_SET.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
36: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
42: ,last_update_date OKS_TEMPLATE_SET.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
37: ,sts_code OKS_TEMPLATE_SET.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
42: ,last_update_date OKS_TEMPLATE_SET.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_tms_rec tms_rec_type;
38: ,template_source OKS_TEMPLATE_SET.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
42: ,last_update_date OKS_TEMPLATE_SET.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_tms_rec tms_rec_type;
46: TYPE tms_tbl_type IS TABLE OF tms_rec_type
39: ,created_by NUMBER := OKC_API.G_MISS_NUM
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
42: ,last_update_date OKS_TEMPLATE_SET.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_tms_rec tms_rec_type;
46: TYPE tms_tbl_type IS TABLE OF tms_rec_type
47: INDEX BY BINARY_INTEGER;
40: ,creation_date OKS_TEMPLATE_SET.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
42: ,last_update_date OKS_TEMPLATE_SET.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_tms_rec tms_rec_type;
46: TYPE tms_tbl_type IS TABLE OF tms_rec_type
47: INDEX BY BINARY_INTEGER;
48: ---------------------------------------------------------------------------
47: INDEX BY BINARY_INTEGER;
48: ---------------------------------------------------------------------------
49: -- GLOBAL MESSAGE CONSTANTS
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: ---------------------------------------------------------------------------
49: -- GLOBAL MESSAGE CONSTANTS
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: -- GLOBAL MESSAGE CONSTANTS
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
62: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
62: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
63: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
62: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
63: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
64:
70: ---------------------------------------------------------------------------
71: -- GLOBAL VARIABLES
72: ---------------------------------------------------------------------------
73: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_TEMPLATE_SET_PVT';
74: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
75: ---------------------------------------------------------------------------
76: -- Procedures and Functions
77: ---------------------------------------------------------------------------
78:
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_tmsv_tbl IN tmsv_tbl_type,
97: x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
98: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
99: PROCEDURE insert_row(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2,
102: x_return_status OUT NOCOPY VARCHAR2,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_tmsv_tbl IN tmsv_tbl_type,
121: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
122: PROCEDURE lock_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_tmsv_tbl IN tmsv_tbl_type,
144: x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
145: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2,
149: x_return_status OUT NOCOPY VARCHAR2,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_tmsv_tbl IN tmsv_tbl_type,
168: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2,
172: x_return_status OUT NOCOPY VARCHAR2,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_tmsv_tbl IN tmsv_tbl_type,
190: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
191: PROCEDURE validate_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2,
194: x_return_status OUT NOCOPY VARCHAR2,