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.INV_MGD_POS_BUCKET_MDTR dependencies on INV_MGD_POS_UTIL

Line 87: INV_MGD_POS_UTIL.Log

83: l_api_name CONSTANT VARCHAR2(30):= 'Get_Context';
84:
85: BEGIN
86:
87: INV_MGD_POS_UTIL.Log
88: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
89: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
90: );
91:

Line 88: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

84:
85: BEGIN
86:
87: INV_MGD_POS_UTIL.Log
88: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
89: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
90: );
91:
92: x_context_rec.organization_id := p_organization_id;

Line 105: INV_MGD_POS_UTIL.Log

101: , org_organization_definitions ood
102: WHERE gsob.set_of_books_id = ood.set_of_books_id
103: AND organization_id = p_organization_id;
104:
105: INV_MGD_POS_UTIL.Log
106: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
107: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
108: );
109:

Line 106: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

102: WHERE gsob.set_of_books_id = ood.set_of_books_id
103: AND organization_id = p_organization_id;
104:
105: INV_MGD_POS_UTIL.Log
106: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
107: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
108: );
109:
110: END Get_Context;

Line 128: INV_MGD_POS_UTIL.Log

124: l_api_name CONSTANT VARCHAR2(30):= 'Open_Cursor';
125:
126: BEGIN
127:
128: INV_MGD_POS_UTIL.Log
129: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
130: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
131: );
132:

Line 129: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

125:
126: BEGIN
127:
128: INV_MGD_POS_UTIL.Log
129: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
130: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
131: );
132:
133: IF p_context_rec.bucket_size = 'PERIOD' THEN

Line 141: INV_MGD_POS_UTIL.Log

137: , p_date_from => p_date_from
138: );
139: END IF;
140:
141: INV_MGD_POS_UTIL.Log
142: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
143: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
144: );
145:

Line 142: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

138: );
139: END IF;
140:
141: INV_MGD_POS_UTIL.Log
142: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
143: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
144: );
145:
146: END Open_Cursor;

Line 159: INV_MGD_POS_UTIL.Log

155: l_api_name CONSTANT VARCHAR2(30):= 'Close_Cursor';
156:
157: BEGIN
158:
159: INV_MGD_POS_UTIL.Log
160: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
161: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
162: );
163:

Line 160: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

156:
157: BEGIN
158:
159: INV_MGD_POS_UTIL.Log
160: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
161: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
162: );
163:
164: IF g_period_crsr%ISOPEN THEN

Line 168: INV_MGD_POS_UTIL.Log

164: IF g_period_crsr%ISOPEN THEN
165: CLOSE g_period_crsr;
166: END IF;
167:
168: INV_MGD_POS_UTIL.Log
169: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
170: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
171: );
172:

Line 169: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

165: CLOSE g_period_crsr;
166: END IF;
167:
168: INV_MGD_POS_UTIL.Log
169: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
170: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
171: );
172:
173: END Close_Cursor;

Line 191: INV_MGD_POS_UTIL.Log

187: l_increment NUMBER;
188:
189: BEGIN
190:
191: INV_MGD_POS_UTIL.Log
192: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
193: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
194: );
195:

Line 192: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

188:
189: BEGIN
190:
191: INV_MGD_POS_UTIL.Log
192: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
193: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
194: );
195:
196: IF p_bucket_size = 'HOUR' THEN

Line 209: INV_MGD_POS_UTIL.Log

205: ELSIF p_bucket_size = 'PERIOD' THEN
206: l_increment := NULL;
207: END IF;
208:
209: INV_MGD_POS_UTIL.Log
210: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
211: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
212: );
213:

Line 210: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

206: l_increment := NULL;
207: END IF;
208:
209: INV_MGD_POS_UTIL.Log
210: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
211: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
212: );
213:
214: RETURN l_Increment;

Line 238: INV_MGD_POS_UTIL.Log

234: l_api_name CONSTANT VARCHAR2(30):= 'Get_Start_Info';
235:
236: BEGIN
237:
238: INV_MGD_POS_UTIL.Log
239: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
240: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
241: );
242:

Line 239: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

235:
236: BEGIN
237:
238: INV_MGD_POS_UTIL.Log
239: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
240: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
241: );
242:
243: IF p_context_rec.bucket_size = 'HOUR' THEN

Line 258: INV_MGD_POS_UTIL.Log

254: , x_period_rec.end_date
255: , x_start_date;
256: END IF;
257:
258: INV_MGD_POS_UTIL.Log
259: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
260: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
261: );
262:

Line 259: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

255: , x_start_date;
256: END IF;
257:
258: INV_MGD_POS_UTIL.Log
259: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
260: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
261: );
262:
263: END Get_Start_Info;

Line 277: , x_bucket_rec OUT NOCOPY INV_MGD_POS_UTIL.bucket_rec_type

273: PROCEDURE Get_Bucket
274: ( p_context_rec IN g_context_rec_type
275: , p_start_date IN DATE
276: , p_period_rec IN g_period_rec_type
277: , x_bucket_rec OUT NOCOPY INV_MGD_POS_UTIL.bucket_rec_type
278: )
279: IS
280:
281: l_api_name CONSTANT VARCHAR2(30):= 'Get_Bucket';

Line 285: INV_MGD_POS_UTIL.Log

281: l_api_name CONSTANT VARCHAR2(30):= 'Get_Bucket';
282:
283: BEGIN
284:
285: INV_MGD_POS_UTIL.Log
286: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
287: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
288: );
289:

Line 286: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

282:
283: BEGIN
284:
285: INV_MGD_POS_UTIL.Log
286: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
287: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
288: );
289:
290: --#11703554 Character date international calendar support Added calendar_aware in date function arguments

Line 315: INV_MGD_POS_UTIL.Log

311: x_bucket_rec.end_date := p_period_rec.end_date + 1; /*2872802*/
312: END IF;
313: x_bucket_rec.bucket_size := p_context_rec.bucket_size;
314:
315: INV_MGD_POS_UTIL.Log
316: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
317: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
318: );
319:

Line 316: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

312: END IF;
313: x_bucket_rec.bucket_size := p_context_rec.bucket_size;
314:
315: INV_MGD_POS_UTIL.Log
316: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
317: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
318: );
319:
320: END Get_Bucket;

Line 340: INV_MGD_POS_UTIL.Log

336: l_api_name CONSTANT VARCHAR2(30):= 'Increment_Start_Info';
337:
338: BEGIN
339:
340: INV_MGD_POS_UTIL.Log
341: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
342: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
343: );
344:

Line 341: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

337:
338: BEGIN
339:
340: INV_MGD_POS_UTIL.Log
341: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
342: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
343: );
344:
345: IF p_context_rec.bucket_size = 'PERIOD' THEN

Line 352: INV_MGD_POS_UTIL.Log

348: x_period_rec.name
349: , x_period_rec.start_date
350: , x_period_rec.end_date
351: , x_start_date;
352: INV_MGD_POS_UTIL.Log
353: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
354: , p_msg => 'start date:'||TO_CHAR(x_period_rec.start_date, 'YYYY/MM/DD HH24:MI:SS')
355: );
356: ELSE

Line 353: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

349: , x_period_rec.start_date
350: , x_period_rec.end_date
351: , x_start_date;
352: INV_MGD_POS_UTIL.Log
353: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
354: , p_msg => 'start date:'||TO_CHAR(x_period_rec.start_date, 'YYYY/MM/DD HH24:MI:SS')
355: );
356: ELSE
357: x_start_date := x_start_date + Get_Increment(p_context_rec.bucket_size);

Line 360: INV_MGD_POS_UTIL.Log

356: ELSE
357: x_start_date := x_start_date + Get_Increment(p_context_rec.bucket_size);
358: END IF;
359:
360: INV_MGD_POS_UTIL.Log
361: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
362: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
363: );
364:

Line 361: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

357: x_start_date := x_start_date + Get_Increment(p_context_rec.bucket_size);
358: END IF;
359:
360: INV_MGD_POS_UTIL.Log
361: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
362: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
363: );
364:
365: END Increment_Start_Info;

Line 388: , x_bucket_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.bucket_tbl_type

384: ( p_organization_id IN NUMBER
385: , p_date_from IN DATE
386: , p_date_to IN DATE
387: , p_bucket_size IN VARCHAR2
388: , x_bucket_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.bucket_tbl_type
389: )
390: IS
391:
392: l_api_name CONSTANT VARCHAR2(30):= 'Build_Bucket_List';

Line 396: l_bucket_rec INV_MGD_POS_UTIL.bucket_rec_type;

392: l_api_name CONSTANT VARCHAR2(30):= 'Build_Bucket_List';
393: l_context_rec g_context_rec_type;
394: l_start_date DATE;
395: l_period_rec g_period_rec_type;
396: l_bucket_rec INV_MGD_POS_UTIL.bucket_rec_type;
397:
398: BEGIN
399:
400: INV_MGD_POS_UTIL.Log

Line 400: INV_MGD_POS_UTIL.Log

396: l_bucket_rec INV_MGD_POS_UTIL.bucket_rec_type;
397:
398: BEGIN
399:
400: INV_MGD_POS_UTIL.Log
401: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
402: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
403: );
404:

Line 401: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

397:
398: BEGIN
399:
400: INV_MGD_POS_UTIL.Log
401: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
402: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
403: );
404:
405: -- Initialize organization list

Line 429: INV_MGD_POS_UTIL.Log

425: , x_start_date => l_start_date
426: , x_period_rec => l_period_rec
427: );
428:
429: INV_MGD_POS_UTIL.Log
430: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
431: , p_msg => 'initial start date:'||TO_CHAR(l_start_date, 'YYYY/MM/DD HH24:MI:SS')
432: );
433:

Line 430: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

426: , x_period_rec => l_period_rec
427: );
428:
429: INV_MGD_POS_UTIL.Log
430: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
431: , p_msg => 'initial start date:'||TO_CHAR(l_start_date, 'YYYY/MM/DD HH24:MI:SS')
432: );
433:
434: LOOP

Line 445: INV_MGD_POS_UTIL.Log

441: );
442:
443: x_bucket_tbl(x_bucket_tbl.COUNT + 1) := l_bucket_rec;
444:
445: INV_MGD_POS_UTIL.Log
446: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
447: , p_msg => 'bucket_rec.name:'||l_bucket_rec.name
448: );
449:

Line 446: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

442:
443: x_bucket_tbl(x_bucket_tbl.COUNT + 1) := l_bucket_rec;
444:
445: INV_MGD_POS_UTIL.Log
446: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
447: , p_msg => 'bucket_rec.name:'||l_bucket_rec.name
448: );
449:
450: Increment_Start_Info

Line 456: INV_MGD_POS_UTIL.Log

452: , x_start_date => l_start_date
453: , x_period_rec => l_period_rec
454: );
455:
456: INV_MGD_POS_UTIL.Log
457: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
458: , p_msg => 'new start date:'||TO_CHAR(l_start_date, 'YYYY/MM/DD HH24:MI:SS')
459: );
460:

Line 457: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

453: , x_period_rec => l_period_rec
454: );
455:
456: INV_MGD_POS_UTIL.Log
457: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
458: , p_msg => 'new start date:'||TO_CHAR(l_start_date, 'YYYY/MM/DD HH24:MI:SS')
459: );
460:
461: EXIT WHEN l_start_date > p_date_to;

Line 468: INV_MGD_POS_UTIL.Log

464:
465: -- close period cursor
466: Close_Cursor;
467:
468: INV_MGD_POS_UTIL.Log
469: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
470: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
471: );
472:

Line 469: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

465: -- close period cursor
466: Close_Cursor;
467:
468: INV_MGD_POS_UTIL.Log
469: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
470: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
471: );
472:
473: END Build_Bucket_List;