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_STREAMS_PVT dependencies on OKC_API

Line 12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

8: SUBTYPE selv_tbl_type IS Okl_Sel_Pvt.selv_tbl_type;
9: ------------------------------------------------------------------------------
10: -- Global Variables
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STREAMS_PVT';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16: ------------------------------------------------------------------------------

Line 27: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

23:
24: --Object type procedure for insert
25: PROCEDURE create_streams(
26: p_api_version IN NUMBER
27: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
28: ,x_return_status OUT NOCOPY VARCHAR2
29: ,x_msg_count OUT NOCOPY NUMBER
30: ,x_msg_data OUT NOCOPY VARCHAR2
31: ,p_stmv_rec IN stmv_rec_type

Line 40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

36:
37: --Object type procedure for insert(master-table,detail-table)
38: PROCEDURE create_streams(
39: p_api_version IN NUMBER
40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY NUMBER
43: ,x_msg_data OUT NOCOPY VARCHAR2
44: ,p_stmv_tbl IN stmv_tbl_type

Line 57: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

53:
54: --Object type procedure for insert(master-table,detail-table)
55: PROCEDURE create_streams_perf(
56: p_api_version IN NUMBER
57: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_stmv_tbl IN stmv_tbl_type

Line 71: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

67:
68: --Object type procedure for update
69: PROCEDURE update_streams(
70: p_api_version IN NUMBER
71: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
72: ,x_return_status OUT NOCOPY VARCHAR2
73: ,x_msg_count OUT NOCOPY NUMBER
74: ,x_msg_data OUT NOCOPY VARCHAR2
75: ,p_stmv_rec IN stmv_rec_type

Line 84: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

80:
81: --Object type procedure for validate
82: PROCEDURE validate_streams(
83: p_api_version IN NUMBER
84: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
85: ,x_return_status OUT NOCOPY VARCHAR2
86: ,x_msg_count OUT NOCOPY NUMBER
87: ,x_msg_data OUT NOCOPY VARCHAR2
88: ,p_stmv_rec IN stmv_rec_type

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92:
93:
94: PROCEDURE create_streams(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_stmv_tbl IN stmv_tbl_type,

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

101: x_stmv_tbl OUT NOCOPY stmv_tbl_type);
102:
103: PROCEDURE create_streams(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_stmv_rec IN stmv_rec_type,

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

110: x_stmv_rec OUT NOCOPY stmv_rec_type);
111:
112: PROCEDURE lock_streams(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117:
118: x_msg_data OUT NOCOPY VARCHAR2,

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

119: p_stmv_tbl IN stmv_tbl_type);
120:
121: PROCEDURE lock_streams(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_stmv_rec IN stmv_rec_type);

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127: p_stmv_rec IN stmv_rec_type);
128:
129: PROCEDURE update_streams(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_stmv_tbl IN stmv_tbl_type,

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

136: x_stmv_tbl OUT NOCOPY stmv_tbl_type);
137:
138: PROCEDURE update_streams(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_stmv_rec IN stmv_rec_type,

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

145: x_stmv_rec OUT NOCOPY stmv_rec_type);
146:
147: PROCEDURE delete_streams(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_stmv_tbl IN stmv_tbl_type);

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

153: p_stmv_tbl IN stmv_tbl_type);
154:
155: PROCEDURE delete_streams(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_stmv_rec IN stmv_rec_type);

Line 165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

161: p_stmv_rec IN stmv_rec_type);
162:
163: PROCEDURE validate_streams(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_stmv_tbl IN stmv_tbl_type);

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

169: p_stmv_tbl IN stmv_tbl_type);
170:
171: PROCEDURE validate_streams(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_stmv_rec IN stmv_rec_type);

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178:
179:
180: PROCEDURE create_stream_elements(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_selv_tbl IN selv_tbl_type,

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

187: x_selv_tbl OUT NOCOPY selv_tbl_type);
188:
189: PROCEDURE create_stream_elements(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_selv_rec IN selv_rec_type,

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

196: x_selv_rec OUT NOCOPY selv_rec_type);
197:
198: PROCEDURE lock_stream_elements(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_selv_tbl IN selv_tbl_type);

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

204: p_selv_tbl IN selv_tbl_type);
205:
206: PROCEDURE lock_stream_elements(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_selv_rec IN selv_rec_type);

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

212: p_selv_rec IN selv_rec_type);
213:
214: PROCEDURE update_stream_elements(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217:
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

222: x_selv_tbl OUT NOCOPY selv_tbl_type);
223:
224: PROCEDURE update_stream_elements(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_selv_rec IN selv_rec_type,

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: x_selv_rec OUT NOCOPY selv_rec_type);
232:
233: PROCEDURE delete_stream_elements(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_selv_tbl IN selv_tbl_type);

Line 243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

239: p_selv_tbl IN selv_tbl_type);
240:
241: PROCEDURE delete_stream_elements(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_selv_rec IN selv_rec_type);

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

247: p_selv_rec IN selv_rec_type);
248:
249: PROCEDURE validate_stream_elements(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_selv_tbl IN selv_tbl_type);

Line 259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

255: p_selv_tbl IN selv_tbl_type);
256:
257: PROCEDURE validate_stream_elements(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_selv_rec IN selv_rec_type);

Line 266: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_selv_rec IN selv_rec_type);
264: PROCEDURE version_stream(
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_khr_id IN NUMBER,