DBA Data[Home] [Help]

APPS.OKL_SGT_PVT dependencies on OKL_SGN_TRANSLATIONS

Line 6: -- OKL_SGN_TRANSLATIONS_V Record Spec

2: /* $Header: OKLSSGTS.pls 115.2 2002/07/22 23:39:07 smahapat noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_SGN_TRANSLATIONS_V Record Spec
7: TYPE sgnv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,jtot_object1_code OKL_SGN_TRANSLATIONS_V.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
10: ,object1_id1 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR

Line 9: ,jtot_object1_code OKL_SGN_TRANSLATIONS_V.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR

5: ---------------------------------------------------------------------------
6: -- OKL_SGN_TRANSLATIONS_V Record Spec
7: TYPE sgnv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,jtot_object1_code OKL_SGN_TRANSLATIONS_V.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
10: ,object1_id1 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR

Line 10: ,object1_id1 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR

6: -- OKL_SGN_TRANSLATIONS_V Record Spec
7: TYPE sgnv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,jtot_object1_code OKL_SGN_TRANSLATIONS_V.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
10: ,object1_id1 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 11: ,object1_id2 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR

7: TYPE sgnv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,jtot_object1_code OKL_SGN_TRANSLATIONS_V.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
10: ,object1_id1 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR

Line 12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR

8: id NUMBER := OKL_API.G_MISS_NUM
9: ,jtot_object1_code OKL_SGN_TRANSLATIONS_V.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
10: ,object1_id1 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR

Line 13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR

9: ,jtot_object1_code OKL_SGN_TRANSLATIONS_V.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
10: ,object1_id1 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE

Line 15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR

11: ,object1_id2 OKL_SGN_TRANSLATIONS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR

12: ,sgn_code OKL_SGN_TRANSLATIONS_V.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE

13: ,value OKL_SGN_TRANSLATIONS_V.VALUE%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE

14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

15: ,default_value OKL_SGN_TRANSLATIONS_V.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

16: ,active_yn OKL_SGN_TRANSLATIONS_V.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

17: ,start_date OKL_SGN_TRANSLATIONS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

18: ,end_date OKL_SGN_TRANSLATIONS_V.END_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

19: ,attribute1 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

20: ,attribute2 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

21: ,attribute3 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

22: ,attribute4 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

23: ,attribute5 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

24: ,attribute6 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

25: ,attribute7 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

26: ,attribute8 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

27: ,attribute9 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_SGN_TRANSLATIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

28: ,attribute10 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_SGN_TRANSLATIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

29: ,attribute11 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_SGN_TRANSLATIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_SGN_TRANSLATIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 35: ,creation_date OKL_SGN_TRANSLATIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

31: ,attribute13 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_SGN_TRANSLATIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_SGN_TRANSLATIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
39: G_MISS_sgnv_rec sgnv_rec_type;

Line 37: ,last_update_date OKL_SGN_TRANSLATIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

33: ,attribute15 OKL_SGN_TRANSLATIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_SGN_TRANSLATIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_SGN_TRANSLATIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
39: G_MISS_sgnv_rec sgnv_rec_type;
40: TYPE sgnv_tbl_type IS TABLE OF sgnv_rec_type
41: INDEX BY BINARY_INTEGER;

Line 42: -- OKL_SGN_TRANSLATIONS Record Spec

38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
39: G_MISS_sgnv_rec sgnv_rec_type;
40: TYPE sgnv_tbl_type IS TABLE OF sgnv_rec_type
41: INDEX BY BINARY_INTEGER;
42: -- OKL_SGN_TRANSLATIONS Record Spec
43: TYPE sgt_rec_type IS RECORD (
44: id NUMBER := OKL_API.G_MISS_NUM
45: ,jtot_object1_code OKL_SGN_TRANSLATIONS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
46: ,object1_id1 OKL_SGN_TRANSLATIONS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR

Line 45: ,jtot_object1_code OKL_SGN_TRANSLATIONS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR

41: INDEX BY BINARY_INTEGER;
42: -- OKL_SGN_TRANSLATIONS Record Spec
43: TYPE sgt_rec_type IS RECORD (
44: id NUMBER := OKL_API.G_MISS_NUM
45: ,jtot_object1_code OKL_SGN_TRANSLATIONS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
46: ,object1_id1 OKL_SGN_TRANSLATIONS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
47: ,object1_id2 OKL_SGN_TRANSLATIONS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR

Line 46: ,object1_id1 OKL_SGN_TRANSLATIONS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR

42: -- OKL_SGN_TRANSLATIONS Record Spec
43: TYPE sgt_rec_type IS RECORD (
44: id NUMBER := OKL_API.G_MISS_NUM
45: ,jtot_object1_code OKL_SGN_TRANSLATIONS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
46: ,object1_id1 OKL_SGN_TRANSLATIONS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
47: ,object1_id2 OKL_SGN_TRANSLATIONS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 47: ,object1_id2 OKL_SGN_TRANSLATIONS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR

43: TYPE sgt_rec_type IS RECORD (
44: id NUMBER := OKL_API.G_MISS_NUM
45: ,jtot_object1_code OKL_SGN_TRANSLATIONS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
46: ,object1_id1 OKL_SGN_TRANSLATIONS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
47: ,object1_id2 OKL_SGN_TRANSLATIONS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR

Line 48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR

44: id NUMBER := OKL_API.G_MISS_NUM
45: ,jtot_object1_code OKL_SGN_TRANSLATIONS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
46: ,object1_id1 OKL_SGN_TRANSLATIONS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
47: ,object1_id2 OKL_SGN_TRANSLATIONS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR

Line 49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR

45: ,jtot_object1_code OKL_SGN_TRANSLATIONS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
46: ,object1_id1 OKL_SGN_TRANSLATIONS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
47: ,object1_id2 OKL_SGN_TRANSLATIONS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE

Line 51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR

47: ,object1_id2 OKL_SGN_TRANSLATIONS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR

48: ,sgn_code OKL_SGN_TRANSLATIONS.SGN_CODE%TYPE := OKL_API.G_MISS_CHAR
49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE

49: ,value OKL_SGN_TRANSLATIONS.VALUE%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE

50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

51: ,default_value OKL_SGN_TRANSLATIONS.DEFAULT_VALUE%TYPE := OKL_API.G_MISS_CHAR
52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

52: ,active_yn OKL_SGN_TRANSLATIONS.ACTIVE_YN%TYPE := OKL_API.G_MISS_CHAR
53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

53: ,start_date OKL_SGN_TRANSLATIONS.START_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

54: ,end_date OKL_SGN_TRANSLATIONS.END_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

55: ,attribute1 OKL_SGN_TRANSLATIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

56: ,attribute2 OKL_SGN_TRANSLATIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

57: ,attribute3 OKL_SGN_TRANSLATIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

58: ,attribute4 OKL_SGN_TRANSLATIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

59: ,attribute5 OKL_SGN_TRANSLATIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

60: ,attribute6 OKL_SGN_TRANSLATIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

61: ,attribute7 OKL_SGN_TRANSLATIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

62: ,attribute8 OKL_SGN_TRANSLATIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
70: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

63: ,attribute9 OKL_SGN_TRANSLATIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
70: ,created_by NUMBER := OKL_API.G_MISS_NUM
71: ,creation_date OKL_SGN_TRANSLATIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

64: ,attribute10 OKL_SGN_TRANSLATIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
70: ,created_by NUMBER := OKL_API.G_MISS_NUM
71: ,creation_date OKL_SGN_TRANSLATIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

65: ,attribute11 OKL_SGN_TRANSLATIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute12 OKL_SGN_TRANSLATIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
70: ,created_by NUMBER := OKL_API.G_MISS_NUM
71: ,creation_date OKL_SGN_TRANSLATIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
73: ,last_update_date OKL_SGN_TRANSLATIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 71: ,creation_date OKL_SGN_TRANSLATIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

67: ,attribute13 OKL_SGN_TRANSLATIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute14 OKL_SGN_TRANSLATIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
70: ,created_by NUMBER := OKL_API.G_MISS_NUM
71: ,creation_date OKL_SGN_TRANSLATIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
73: ,last_update_date OKL_SGN_TRANSLATIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
75: G_MISS_sgt_rec sgt_rec_type;

Line 73: ,last_update_date OKL_SGN_TRANSLATIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

69: ,attribute15 OKL_SGN_TRANSLATIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
70: ,created_by NUMBER := OKL_API.G_MISS_NUM
71: ,creation_date OKL_SGN_TRANSLATIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
73: ,last_update_date OKL_SGN_TRANSLATIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
75: G_MISS_sgt_rec sgt_rec_type;
76: TYPE sgt_tbl_type IS TABLE OF sgt_rec_type
77: INDEX BY BINARY_INTEGER;