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_SGT_PVT dependencies on OKL_API

Line 8: id NUMBER := OKL_API.G_MISS_NUM

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

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 14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

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
18: ,end_date OKL_SGN_TRANSLATIONS_V.END_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 34: ,created_by NUMBER := OKL_API.G_MISS_NUM

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
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

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 36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

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;
40: TYPE sgnv_tbl_type IS TABLE OF 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 38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

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;
42: -- OKL_SGN_TRANSLATIONS Record Spec

Line 44: id NUMBER := OKL_API.G_MISS_NUM

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

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 50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

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
54: ,end_date OKL_SGN_TRANSLATIONS.END_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 70: ,created_by NUMBER := OKL_API.G_MISS_NUM

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
74: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

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 72: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

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;
76: TYPE sgt_tbl_type IS TABLE OF 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;

Line 74: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

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

Line 81: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

81: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
94:

Line 104: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SGT_PVT';
104: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
105: ---------------------------------------------------------------------------
106: -- Procedures and Functions
107: ---------------------------------------------------------------------------
108:

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

110: PROCEDURE change_version;
111: PROCEDURE api_copy;
112: PROCEDURE insert_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_sgnv_rec IN sgnv_rec_type,

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

118: p_sgnv_rec IN sgnv_rec_type,
119: x_sgnv_rec OUT NOCOPY sgnv_rec_type);
120: PROCEDURE insert_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_sgnv_tbl IN sgnv_tbl_type,

Line 128: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_sgnv_tbl IN sgnv_tbl_type,
127: x_sgnv_tbl OUT NOCOPY sgnv_tbl_type,
128: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
129: PROCEDURE insert_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

127: x_sgnv_tbl OUT NOCOPY sgnv_tbl_type,
128: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
129: PROCEDURE insert_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_sgnv_tbl IN sgnv_tbl_type,

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

135: p_sgnv_tbl IN sgnv_tbl_type,
136: x_sgnv_tbl OUT NOCOPY sgnv_tbl_type);
137: PROCEDURE lock_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_sgnv_rec IN sgnv_rec_type);

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_sgnv_rec IN sgnv_rec_type);
144: PROCEDURE lock_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_sgnv_tbl IN sgnv_tbl_type,

Line 151: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_sgnv_tbl IN sgnv_tbl_type,
151: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
152: PROCEDURE lock_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

150: p_sgnv_tbl IN sgnv_tbl_type,
151: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
152: PROCEDURE lock_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_sgnv_tbl IN sgnv_tbl_type);

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_sgnv_tbl IN sgnv_tbl_type);
159: PROCEDURE update_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_sgnv_rec IN sgnv_rec_type,

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

165: p_sgnv_rec IN sgnv_rec_type,
166: x_sgnv_rec OUT NOCOPY sgnv_rec_type);
167: PROCEDURE update_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_sgnv_tbl IN sgnv_tbl_type,

Line 175: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_sgnv_tbl IN sgnv_tbl_type,
174: x_sgnv_tbl OUT NOCOPY sgnv_tbl_type,
175: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
176: PROCEDURE update_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

174: x_sgnv_tbl OUT NOCOPY sgnv_tbl_type,
175: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
176: PROCEDURE update_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_sgnv_tbl IN sgnv_tbl_type,

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

182: p_sgnv_tbl IN sgnv_tbl_type,
183: x_sgnv_tbl OUT NOCOPY sgnv_tbl_type);
184: PROCEDURE delete_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_sgnv_rec IN sgnv_rec_type);

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_sgnv_rec IN sgnv_rec_type);
191: PROCEDURE delete_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_sgnv_tbl IN sgnv_tbl_type,

Line 198: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_sgnv_tbl IN sgnv_tbl_type,
198: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
199: PROCEDURE delete_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

197: p_sgnv_tbl IN sgnv_tbl_type,
198: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
199: PROCEDURE delete_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_sgnv_tbl IN sgnv_tbl_type);

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_sgnv_tbl IN sgnv_tbl_type);
206: PROCEDURE validate_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_sgnv_rec IN sgnv_rec_type);

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_sgnv_rec IN sgnv_rec_type);
213: PROCEDURE validate_row(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_sgnv_tbl IN sgnv_tbl_type,

Line 220: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_sgnv_tbl IN sgnv_tbl_type,
220: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
221: PROCEDURE validate_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

219: p_sgnv_tbl IN sgnv_tbl_type,
220: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
221: PROCEDURE validate_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_sgnv_tbl IN sgnv_tbl_type);