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_RESOURCE_TXNS_GTMP_DBL dependencies on GME_RESOURCE_TXNS_GTMP

Line 1: PACKAGE BODY gme_resource_txns_gtmp_dbl AS

1: PACKAGE BODY gme_resource_txns_gtmp_dbl AS
2: /* $Header: GMEVGRGB.pls 120.2 2005/07/12 12:35:30 snene noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_RESOURCE_TXNS_GTMP';

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

1: PACKAGE BODY gme_resource_txns_gtmp_dbl AS
2: /* $Header: GMEVGRGB.pls 120.2 2005/07/12 12:35:30 snene noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_RESOURCE_TXNS_GTMP';
6:
7: /*============================================================================
8: | Copyright (c) 2001 Oracle Corporation
9: | TVP, Reading

Line 41: | Insert_Row will insert a row in gme_resource_txns_gtmp

Line 45: | Insert_Row will insert a row in gme_resource_txns_gtmp

41: | Insert_Row will insert a row in gme_resource_txns_gtmp
42: |
43: |
44: | DESCRIPTION
45: | Insert_Row will insert a row in gme_resource_txns_gtmp
46: |
47: |
48: |
49: | PARAMETERS

Line 50: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

46: |
47: |
48: |
49: | PARAMETERS
50: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
51: | x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
52: |
53: | RETURNS
54: | BOOLEAN

Line 51: | x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE

Line 64: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

60: +=============================================================================
61: Api end of comments
62: */
63: FUNCTION insert_row (
64: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
65: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)
66: RETURN BOOLEAN
67: IS
68: BEGIN

Line 65: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)

61: Api end of comments
62: */
63: FUNCTION insert_row (
64: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
65: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)
66: RETURN BOOLEAN
67: IS
68: BEGIN
69: x_resource_txns := p_resource_txns;

Line 71: INSERT INTO gme_resource_txns_gtmp

67: IS
68: BEGIN
69: x_resource_txns := p_resource_txns;
70:
71: INSERT INTO gme_resource_txns_gtmp
72: (poc_trans_id
73: /*start Punit Kumar*/
74: , organization_id
75: /*end*/

Line 171: | Fetch_Row will fetch a row in gme_resource_txns_gtmp

Line 175: | Fetch_Row will fetch a row in gme_resource_txns_gtmp

171: | Fetch_Row will fetch a row in gme_resource_txns_gtmp
172: |
173: |
174: | DESCRIPTION
175: | Fetch_Row will fetch a row in gme_resource_txns_gtmp
176: |
177: |
178: |
179: | PARAMETERS

Line 180: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

176: |
177: |
178: |
179: | PARAMETERS
180: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
181: | x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
182: |
183: | RETURNS
184: | BOOLEAN

Line 181: | x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE

Line 194: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

190: +=============================================================================
191: Api end of comments
192: */
193: FUNCTION fetch_row (
194: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
195: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)
196: RETURN BOOLEAN
197: IS
198: BEGIN

Line 195: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)

191: Api end of comments
192: */
193: FUNCTION fetch_row (
194: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
195: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)
196: RETURN BOOLEAN
197: IS
198: BEGIN
199: IF p_resource_txns.poc_trans_id IS NOT NULL THEN

Line 274: FROM gme_resource_txns_gtmp

270: ,x_resource_txns.attribute26, x_resource_txns.attribute27
271: ,x_resource_txns.attribute28, x_resource_txns.attribute29
272: ,x_resource_txns.attribute30
273: /*end */
274: FROM gme_resource_txns_gtmp
275: WHERE poc_trans_id = p_resource_txns.poc_trans_id;
276: ELSE
277: gme_common_pvt.log_message ('GME_NO_KEYS'
278: ,'TABLE_NAME'

Line 304: | Delete_Row will delete a row in gme_resource_txns_gtmp

Line 308: | Delete_Row will delete a row in gme_resource_txns_gtmp

304: | Delete_Row will delete a row in gme_resource_txns_gtmp
305: |
306: |
307: | DESCRIPTION
308: | Delete_Row will delete a row in gme_resource_txns_gtmp
309: |
310: |
311: |
312: | PARAMETERS

Line 313: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

309: |
310: |
311: |
312: | PARAMETERS
313: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
314: |
315: | RETURNS
316: | BOOLEAN
317: | HISTORY

Line 325: FUNCTION delete_row (p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE)

321: |
322: +=============================================================================
323: Api end of comments
324: */
325: FUNCTION delete_row (p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE)
326: RETURN BOOLEAN
327: IS
328: BEGIN
329: IF p_resource_txns.poc_trans_id IS NOT NULL THEN

Line 330: UPDATE gme_resource_txns_gtmp

326: RETURN BOOLEAN
327: IS
328: BEGIN
329: IF p_resource_txns.poc_trans_id IS NOT NULL THEN
330: UPDATE gme_resource_txns_gtmp
331: SET delete_mark = 1
332: WHERE poc_trans_id = p_resource_txns.poc_trans_id;
333: ELSE
334: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 363: | Update_Row will update a row in gme_resource_txns_gtmp

Line 367: | Update_Row will update a row in gme_resource_txns_gtmp

363: | Update_Row will update a row in gme_resource_txns_gtmp
364: |
365: |
366: | DESCRIPTION
367: | Update_Row will update a row in gme_resource_txns_gtmp
368: |
369: |
370: |
371: | PARAMETERS

Line 372: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

368: |
369: |
370: |
371: | PARAMETERS
372: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
373: |
374: | RETURNS
375: | BOOLEAN
376: | HISTORY

Line 384: FUNCTION update_row (p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE)

380: | 16-March-2005 Punit Kumar Convergence changes
381: +=============================================================================
382: Api end of comments
383: */
384: FUNCTION update_row (p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE)
385: RETURN BOOLEAN
386: IS
387: BEGIN
388: IF p_resource_txns.poc_trans_id IS NOT NULL THEN

Line 389: UPDATE gme_resource_txns_gtmp

385: RETURN BOOLEAN
386: IS
387: BEGIN
388: IF p_resource_txns.poc_trans_id IS NOT NULL THEN
389: UPDATE gme_resource_txns_gtmp
390: SET
391: --ORGN_CODE = p_resource_txns.ORGN_CODE
392:
393: /* start , Punit Kumar */

Line 474: END gme_resource_txns_gtmp_dbl;

470: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
471: ,SQLERRM);
472: RETURN FALSE;
473: END update_row;
474: END gme_resource_txns_gtmp_dbl;