eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GTT_PVT dependencies on OKL_API

Line 8: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM

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

Line 9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 10: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 11: ,version OKL_ST_GEN_TEMPLATES.VERSION%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

Line 12: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 13: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 14: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%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

Line 15: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%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

Line 16: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%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

Line 17: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%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

Line 18: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%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

Line 19: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%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

Line 20: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%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

Line 21: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%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

Line 22: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%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

Line 23: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%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

Line 24: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%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

Line 25: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%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

Line 26: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%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

Line 27: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%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

Line 28: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%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
32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 29: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%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
33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

Line 30: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%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
34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 31: ,org_id 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

Line 32: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 33: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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: );

Line 34: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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:

Line 35: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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:

Line 36: ,last_update_login 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:
40: G_MISS_GTT_REC gtt_rec_type;

Line 45: id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM

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

Line 46: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 47: ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 48: ,version OKL_ST_GEN_TEMPLATES.VERSION%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

Line 49: ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 50: ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 51: ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%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

Line 52: ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%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

Line 53: ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%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

Line 54: ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%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

Line 55: ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%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

Line 56: ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%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

Line 57: ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%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

Line 58: ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%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

Line 59: ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%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

Line 60: ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%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

Line 61: ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%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

Line 62: ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%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

Line 63: ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%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

Line 64: ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%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

Line 65: ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%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
69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 66: ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%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
70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

Line 67: ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%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
71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 68: ,org_id 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

Line 69: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 70: ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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: );

Line 71: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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:

Line 72: ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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:

Line 73: ,last_update_login 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:
77: G_MISS_GTTV_REC gttv_rec_type;

Line 85: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

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;

Line 97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;

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:

Line 98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

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: ---------------------------------------------------------------------------

Line 99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;

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

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);