DBA Data[Home] [Help]

APPS.OKL_SRS_PVT dependencies on OKL_SIF_RET_STRMS_V

Line 41: stream_type_name OKL_SIF_RET_STRMS_V.STREAM_TYPE_NAME%TYPE ,

37: TYPE srs_tbl_type IS TABLE OF srs_rec_type
38: INDEX BY BINARY_INTEGER;
39: TYPE srsv_rec_type IS RECORD (
40: id NUMBER ,
41: stream_type_name OKL_SIF_RET_STRMS_V.STREAM_TYPE_NAME%TYPE ,
42: index_number NUMBER ,
43: activity_type OKL_SIF_RET_STRMS_V.ACTIVITY_TYPE%TYPE ,
44: sequence_number NUMBER ,
45: sre_date OKL_SIF_RET_STRMS_V.SRE_DATE%TYPE ,

Line 43: activity_type OKL_SIF_RET_STRMS_V.ACTIVITY_TYPE%TYPE ,

39: TYPE srsv_rec_type IS RECORD (
40: id NUMBER ,
41: stream_type_name OKL_SIF_RET_STRMS_V.STREAM_TYPE_NAME%TYPE ,
42: index_number NUMBER ,
43: activity_type OKL_SIF_RET_STRMS_V.ACTIVITY_TYPE%TYPE ,
44: sequence_number NUMBER ,
45: sre_date OKL_SIF_RET_STRMS_V.SRE_DATE%TYPE ,
46: amount NUMBER ,
47: sir_id NUMBER ,

Line 45: sre_date OKL_SIF_RET_STRMS_V.SRE_DATE%TYPE ,

41: stream_type_name OKL_SIF_RET_STRMS_V.STREAM_TYPE_NAME%TYPE ,
42: index_number NUMBER ,
43: activity_type OKL_SIF_RET_STRMS_V.ACTIVITY_TYPE%TYPE ,
44: sequence_number NUMBER ,
45: sre_date OKL_SIF_RET_STRMS_V.SRE_DATE%TYPE ,
46: amount NUMBER ,
47: sir_id NUMBER ,
48: stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,

Line 48: stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,

44: sequence_number NUMBER ,
45: sre_date OKL_SIF_RET_STRMS_V.SRE_DATE%TYPE ,
46: amount NUMBER ,
47: sir_id NUMBER ,
48: stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,

Line 49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,

45: sre_date OKL_SIF_RET_STRMS_V.SRE_DATE%TYPE ,
46: amount NUMBER ,
47: sir_id NUMBER ,
48: stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,

Line 50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,

46: amount NUMBER ,
47: sir_id NUMBER ,
48: stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,

Line 51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,

47: sir_id NUMBER ,
48: stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,

Line 52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,

48: stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,

Line 53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,

49: stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,

Line 54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,

50: stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,

Line 55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,

51: stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,

Line 56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,

52: stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,

Line 57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,

53: stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
61: stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,

Line 58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,

54: stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
61: stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,
62: stream_interface_attribute15 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,

Line 59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,

55: stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
61: stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,
62: stream_interface_attribute15 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,
63: object_version_number NUMBER ,

Line 60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,

56: stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
61: stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,
62: stream_interface_attribute15 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,
63: object_version_number NUMBER ,
64: created_by NUMBER ,

Line 61: stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,

57: stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
61: stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,
62: stream_interface_attribute15 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,
63: object_version_number NUMBER ,
64: created_by NUMBER ,
65: last_updated_by NUMBER ,

Line 62: stream_interface_attribute15 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,

58: stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59: stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60: stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
61: stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,
62: stream_interface_attribute15 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,
63: object_version_number NUMBER ,
64: created_by NUMBER ,
65: last_updated_by NUMBER ,
66:

Line 73: creation_date OKL_SIF_RET_STRMS_V.CREATION_DATE%TYPE ,

69:
70:
71:
72:
73: creation_date OKL_SIF_RET_STRMS_V.CREATION_DATE%TYPE ,
74: last_update_date OKL_SIF_RET_STRMS_V.LAST_UPDATE_DATE%TYPE ,
75: last_update_login NUMBER );
76: g_miss_srsv_rec srsv_rec_type;
77: TYPE srsv_tbl_type IS TABLE OF srsv_rec_type

Line 74: last_update_date OKL_SIF_RET_STRMS_V.LAST_UPDATE_DATE%TYPE ,

70:
71:
72:
73: creation_date OKL_SIF_RET_STRMS_V.CREATION_DATE%TYPE ,
74: last_update_date OKL_SIF_RET_STRMS_V.LAST_UPDATE_DATE%TYPE ,
75: last_update_login NUMBER );
76: g_miss_srsv_rec srsv_rec_type;
77: TYPE srsv_tbl_type IS TABLE OF srsv_rec_type
78: INDEX BY BINARY_INTEGER;