4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6:
7: TYPE gtt_rec_type IS RECORD (
8: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
5: ---------------------------------------------------------------------------
6:
7: TYPE gtt_rec_type IS RECORD (
8: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
6:
7: TYPE gtt_rec_type IS RECORD (
8: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
7: TYPE gtt_rec_type IS RECORD (
8: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
8: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
11: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
36: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
36: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
37: );
30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
36: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
37: );
38:
31: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
36: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
37: );
38:
39:
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
36: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
37: );
38:
39:
40: G_MISS_GTT_REC gtt_rec_type;
41: TYPE gtt_tbl_type IS TABLE OF gtt_rec_type
42: INDEX BY BINARY_INTEGER;
43:
44: TYPE gttv_rec_type IS RECORD (
45: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
46: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
42: INDEX BY BINARY_INTEGER;
43:
44: TYPE gttv_rec_type IS RECORD (
45: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
46: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
43:
44: TYPE gttv_rec_type IS RECORD (
45: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
46: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
44: TYPE gttv_rec_type IS RECORD (
45: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
46: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
45: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
46: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
46: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
48: ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
72: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
72: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
73: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
72: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
73: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
74: );
67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
72: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
73: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
74: );
75:
68: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
72: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
73: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
74: );
75:
76:
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
72: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
73: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
74: );
75:
76:
77: G_MISS_GTTV_REC gttv_rec_type;
81: ---------------------------------------------------------------------------
82: -- GLOBAL VARIABLES
83: ---------------------------------------------------------------------------
84: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GTT_PVT';
85: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
86: --------------------------------------------------------------------------------
87: -- ERRORS AND EXCEPTIONS
88: --------------------------------------------------------------------------------
89: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
93: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
94: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
95: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
96: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
100: G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATE';
101:
94: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
95: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
96: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
100: G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATE';
101:
102: ---------------------------------------------------------------------------
95: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
96: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
100: G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATE';
101:
102: ---------------------------------------------------------------------------
103: -- Procedures and Functions
107: PROCEDURE api_copy;
108:
109: PROCEDURE insert_row(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_gttv_rec IN gttv_rec_type,
116: x_gttv_rec OUT NOCOPY gttv_rec_type );
117:
118: PROCEDURE insert_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_gttv_tbl IN gttv_tbl_type,
125: x_gttv_tbl OUT NOCOPY gttv_tbl_type);
126:
127: PROCEDURE update_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_gttv_rec IN gttv_rec_type,
134: x_gttv_rec OUT NOCOPY gttv_rec_type);
135:
136: PROCEDURE update_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_gttv_tbl IN gttv_tbl_type,
143: x_gttv_tbl OUT NOCOPY gttv_tbl_type);
144:
145: PROCEDURE delete_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_gttv_rec IN gttv_rec_type);
151: p_gttv_rec IN gttv_rec_type);
152:
153: PROCEDURE delete_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_gttv_tbl IN gttv_tbl_type);