DBA Data[Home] [Help]

APPS.OKC_SPN_PVT dependencies on OKC_SPAN

Line 15: uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,

11: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12: TYPE spn_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM,
14: tve_id NUMBER := OKC_API.G_MISS_NUM,
15: uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,
16: spn_id NUMBER := OKC_API.G_MISS_NUM,
17: duration NUMBER := OKC_API.G_MISS_NUM,
18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,

14: tve_id NUMBER := OKC_API.G_MISS_NUM,
15: uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,
16: spn_id NUMBER := OKC_API.G_MISS_NUM,
17: duration NUMBER := OKC_API.G_MISS_NUM,
18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,

15: uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,
16: spn_id NUMBER := OKC_API.G_MISS_NUM,
17: duration NUMBER := OKC_API.G_MISS_NUM,
18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

Line 38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;

Line 39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;
43: TYPE spn_tbl_type IS TABLE OF spn_rec_type

Line 40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;
43: TYPE spn_tbl_type IS TABLE OF spn_rec_type
44: INDEX BY BINARY_INTEGER;

Line 41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;
43: TYPE spn_tbl_type IS TABLE OF spn_rec_type
44: INDEX BY BINARY_INTEGER;
45: TYPE spnv_rec_type IS RECORD (

Line 49: uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,

45: TYPE spnv_rec_type IS RECORD (
46: id NUMBER := OKC_API.G_MISS_NUM,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: tve_id NUMBER := OKC_API.G_MISS_NUM,
49: uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,

47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: tve_id NUMBER := OKC_API.G_MISS_NUM,
49: uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,

49: uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

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

Line 60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

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

Line 61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

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

Line 62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

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

Line 63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

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

Line 64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

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

Line 65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

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

Line 66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

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

Line 67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

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

Line 68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

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

Line 69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

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

Line 71: creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 73: last_update_date OKC_SPAN_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKC_SPAN_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_spnv_rec spnv_rec_type;
76: TYPE spnv_tbl_type IS TABLE OF spnv_rec_type
77: INDEX BY BINARY_INTEGER;