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.GME_BATCH_HISTORY_DBL dependencies on GME_BATCH_HISTORY

Line 1: PACKAGE BODY gme_batch_history_dbl AS

1: PACKAGE BODY gme_batch_history_dbl AS
2: /* $Header: GMEVGHSB.pls 120.1 2005/06/03 13:45:15 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_HISTORY';

Line 5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_HISTORY';

1: PACKAGE BODY gme_batch_history_dbl AS
2: /* $Header: GMEVGHSB.pls 120.1 2005/06/03 13:45:15 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_HISTORY';
6:
7: /*============================================================================
8: | Copyright (c) 2001 Oracle Corporation
9: | TVP, Reading

Line 43: | Insert_Row will insert a row in gme_batch_history

Line 47: | Insert_Row will insert a row in gme_batch_history

43: | Insert_Row will insert a row in gme_batch_history
44: |
45: |
46: | DESCRIPTION
47: | Insert_Row will insert a row in gme_batch_history
48: |
49: |
50: |
51: | PARAMETERS

Line 52: | p_batch_history IN gme_batch_history%ROWTYPE

48: |
49: |
50: |
51: | PARAMETERS
52: | p_batch_history IN gme_batch_history%ROWTYPE
53: | x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE
54: |
55: | RETURNS
56: | BOOLEAN

Line 53: | x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE

Line 66: p_batch_history IN gme_batch_history%ROWTYPE

62: +=============================================================================
63: Api end of comments
64: */
65: FUNCTION insert_row (
66: p_batch_history IN gme_batch_history%ROWTYPE
67: ,x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE)
68: RETURN BOOLEAN
69: IS
70: BEGIN

Line 67: ,x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE)

63: Api end of comments
64: */
65: FUNCTION insert_row (
66: p_batch_history IN gme_batch_history%ROWTYPE
67: ,x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE)
68: RETURN BOOLEAN
69: IS
70: BEGIN
71: x_batch_history := p_batch_history;

Line 73: INSERT INTO gme_batch_history

69: IS
70: BEGIN
71: x_batch_history := p_batch_history;
72:
73: INSERT INTO gme_batch_history
74: (event_id, batch_id
75: ,orig_status, new_status
76: ,orig_wip_whse
77: ,new_wip_whse

Line 119: | Fetch_Row will fetch a row in gme_batch_history

Line 123: | Fetch_Row will fetch a row in gme_batch_history

119: | Fetch_Row will fetch a row in gme_batch_history
120: |
121: |
122: | DESCRIPTION
123: | Fetch_Row will fetch a row in gme_batch_history
124: |
125: |
126: |
127: | PARAMETERS

Line 128: | p_batch_history IN gme_batch_history%ROWTYPE

124: |
125: |
126: |
127: | PARAMETERS
128: | p_batch_history IN gme_batch_history%ROWTYPE
129: | x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE
130: |
131: | RETURNS
132: | BOOLEAN

Line 129: | x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE

Line 142: p_batch_history IN gme_batch_history%ROWTYPE

138: +=============================================================================
139: Api end of comments
140: */
141: FUNCTION fetch_row (
142: p_batch_history IN gme_batch_history%ROWTYPE
143: ,x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE)
144: RETURN BOOLEAN
145: IS
146: BEGIN

Line 143: ,x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE)

139: Api end of comments
140: */
141: FUNCTION fetch_row (
142: p_batch_history IN gme_batch_history%ROWTYPE
143: ,x_batch_history IN OUT NOCOPY gme_batch_history%ROWTYPE)
144: RETURN BOOLEAN
145: IS
146: BEGIN
147: IF p_batch_history.event_id IS NOT NULL THEN

Line 170: FROM gme_batch_history

166: ,x_batch_history.last_update_date
167: ,x_batch_history.program_id, x_batch_history.request_id
168: ,x_batch_history.program_update_date
169: ,x_batch_history.program_application_id
170: FROM gme_batch_history
171: WHERE event_id = p_batch_history.event_id;
172: ELSE
173: gme_common_pvt.log_message ('GME_NO_KEYS'
174: ,'TABLE_NAME'

Line 200: | Delete_Row will delete a row in gme_batch_history

Line 204: | Delete_Row will delete a row in gme_batch_history

200: | Delete_Row will delete a row in gme_batch_history
201: |
202: |
203: | DESCRIPTION
204: | Delete_Row will delete a row in gme_batch_history
205: |
206: |
207: |
208: | PARAMETERS

Line 209: | p_batch_history IN gme_batch_history%ROWTYPE

205: |
206: |
207: |
208: | PARAMETERS
209: | p_batch_history IN gme_batch_history%ROWTYPE
210: |
211: | RETURNS
212: | BOOLEAN
213: | HISTORY

Line 222: FUNCTION delete_row (p_batch_history IN gme_batch_history%ROWTYPE)

218: |
219: +=============================================================================
220: Api end of comments
221: */
222: FUNCTION delete_row (p_batch_history IN gme_batch_history%ROWTYPE)
223: RETURN BOOLEAN
224: IS
225: l_dummy NUMBER := 0;
226: locked_by_other_user EXCEPTION;

Line 232: FROM gme_batch_history

228: BEGIN
229: IF p_batch_history.event_id IS NOT NULL THEN
230: SELECT 1
231: INTO l_dummy
232: FROM gme_batch_history
233: WHERE event_id = p_batch_history.event_id
234: FOR UPDATE NOWAIT;
235:
236: DELETE FROM gme_batch_history

Line 236: DELETE FROM gme_batch_history

232: FROM gme_batch_history
233: WHERE event_id = p_batch_history.event_id
234: FOR UPDATE NOWAIT;
235:
236: DELETE FROM gme_batch_history
237: WHERE event_id = p_batch_history.event_id;
238: ELSE
239: gme_common_pvt.log_message ('GME_NO_KEYS'
240: ,'TABLE_NAME'

Line 296: | Update_Row will update a row in gme_batch_history

Line 300: | Update_Row will update a row in gme_batch_history

296: | Update_Row will update a row in gme_batch_history
297: |
298: |
299: | DESCRIPTION
300: | Update_Row will update a row in gme_batch_history
301: |
302: |
303: |
304: | PARAMETERS

Line 305: | p_batch_history IN gme_batch_history%ROWTYPE

301: |
302: |
303: |
304: | PARAMETERS
305: | p_batch_history IN gme_batch_history%ROWTYPE
306: |
307: | RETURNS
308: | BOOLEAN
309: | HISTORY

Line 318: FUNCTION update_row (p_batch_history IN gme_batch_history%ROWTYPE)

314: |
315: +=============================================================================
316: Api end of comments
317: */
318: FUNCTION update_row (p_batch_history IN gme_batch_history%ROWTYPE)
319: RETURN BOOLEAN
320: IS
321: l_dummy NUMBER := 0;
322: locked_by_other_user EXCEPTION;

Line 328: FROM gme_batch_history

324: BEGIN
325: IF p_batch_history.event_id IS NOT NULL THEN
326: SELECT 1
327: INTO l_dummy
328: FROM gme_batch_history
329: WHERE event_id = p_batch_history.event_id
330: FOR UPDATE NOWAIT;
331:
332: UPDATE gme_batch_history

Line 332: UPDATE gme_batch_history

328: FROM gme_batch_history
329: WHERE event_id = p_batch_history.event_id
330: FOR UPDATE NOWAIT;
331:
332: UPDATE gme_batch_history
333: SET batch_id = p_batch_history.batch_id
334: ,orig_status = p_batch_history.orig_status
335: ,new_status = p_batch_history.new_status
336: ,orig_wip_whse = p_batch_history.orig_wip_whse

Line 407: | Lock_Row will lock a row in gme_batch_history

Line 411: | Lock_Row will lock a row in gme_batch_history

407: | Lock_Row will lock a row in gme_batch_history
408: |
409: |
410: | DESCRIPTION
411: | Lock_Row will lock a row in gme_batch_history
412: |
413: |
414: |
415: | PARAMETERS

Line 416: | p_batch_history IN gme_batch_history%ROWTYPE

412: |
413: |
414: |
415: | PARAMETERS
416: | p_batch_history IN gme_batch_history%ROWTYPE
417: |
418: | RETURNS
419: | BOOLEAN
420: | HISTORY

Line 428: FUNCTION lock_row (p_batch_history IN gme_batch_history%ROWTYPE)

424: |
425: +=============================================================================
426: Api end of comments
427: */
428: FUNCTION lock_row (p_batch_history IN gme_batch_history%ROWTYPE)
429: RETURN BOOLEAN
430: IS
431: l_dummy NUMBER;
432: BEGIN

Line 436: FROM gme_batch_history

432: BEGIN
433: IF p_batch_history.event_id IS NOT NULL THEN
434: SELECT 1
435: INTO l_dummy
436: FROM gme_batch_history
437: WHERE event_id = p_batch_history.event_id
438: FOR UPDATE NOWAIT;
439: END IF;
440:

Line 455: END gme_batch_history_dbl;

451: RETURN FALSE;
452: WHEN OTHERS THEN
453: RETURN FALSE;
454: END lock_row;
455: END gme_batch_history_dbl;