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.12010000.2 2009/10/09 11:51:23 gmurator ship $ */
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.12010000.2 2009/10/09 11:51:23 gmurator ship $ */
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 66: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

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

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

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

Line 73: INSERT INTO gme_resource_txns_gtmp

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

Line 175: | Fetch_Row will fetch a row in gme_resource_txns_gtmp

Line 179: | Fetch_Row will fetch a row in gme_resource_txns_gtmp

175: | Fetch_Row will fetch a row in gme_resource_txns_gtmp
176: |
177: |
178: | DESCRIPTION
179: | Fetch_Row will fetch a row in gme_resource_txns_gtmp
180: |
181: |
182: |
183: | PARAMETERS

Line 184: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

180: |
181: |
182: |
183: | PARAMETERS
184: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
185: | x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
186: |
187: | RETURNS
188: | BOOLEAN

Line 185: | x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE

Line 200: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

196: +=============================================================================
197: Api end of comments
198: */
199: FUNCTION fetch_row (
200: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
201: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)
202: RETURN BOOLEAN
203: IS
204: BEGIN

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

197: Api end of comments
198: */
199: FUNCTION fetch_row (
200: p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
201: ,x_resource_txns IN OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE)
202: RETURN BOOLEAN
203: IS
204: BEGIN
205: IF p_resource_txns.poc_trans_id IS NOT NULL THEN

Line 282: FROM gme_resource_txns_gtmp

278: ,x_resource_txns.attribute26, x_resource_txns.attribute27
279: ,x_resource_txns.attribute28, x_resource_txns.attribute29
280: ,x_resource_txns.attribute30
281: /*end */
282: FROM gme_resource_txns_gtmp
283: WHERE poc_trans_id = p_resource_txns.poc_trans_id;
284: ELSE
285: gme_common_pvt.log_message ('GME_NO_KEYS'
286: ,'TABLE_NAME'

Line 312: | Delete_Row will delete a row in gme_resource_txns_gtmp

Line 316: | Delete_Row will delete a row in gme_resource_txns_gtmp

312: | Delete_Row will delete a row in gme_resource_txns_gtmp
313: |
314: |
315: | DESCRIPTION
316: | Delete_Row will delete a row in gme_resource_txns_gtmp
317: |
318: |
319: |
320: | PARAMETERS

Line 321: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

317: |
318: |
319: |
320: | PARAMETERS
321: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
322: |
323: | RETURNS
324: | BOOLEAN
325: | HISTORY

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

329: |
330: +=============================================================================
331: Api end of comments
332: */
333: FUNCTION delete_row (p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE)
334: RETURN BOOLEAN
335: IS
336: BEGIN
337: IF p_resource_txns.poc_trans_id IS NOT NULL THEN

Line 338: UPDATE gme_resource_txns_gtmp

334: RETURN BOOLEAN
335: IS
336: BEGIN
337: IF p_resource_txns.poc_trans_id IS NOT NULL THEN
338: UPDATE gme_resource_txns_gtmp
339: SET delete_mark = 1
340: WHERE poc_trans_id = p_resource_txns.poc_trans_id;
341: ELSE
342: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 371: | Update_Row will update a row in gme_resource_txns_gtmp

Line 375: | Update_Row will update a row in gme_resource_txns_gtmp

371: | Update_Row will update a row in gme_resource_txns_gtmp
372: |
373: |
374: | DESCRIPTION
375: | Update_Row will update a row in gme_resource_txns_gtmp
376: |
377: |
378: |
379: | PARAMETERS

Line 380: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE

376: |
377: |
378: |
379: | PARAMETERS
380: | p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE
381: |
382: | RETURNS
383: | BOOLEAN
384: | HISTORY

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

391: | Add attribute_category column.
392: +=============================================================================
393: Api end of comments
394: */
395: FUNCTION update_row (p_resource_txns IN gme_resource_txns_gtmp%ROWTYPE)
396: RETURN BOOLEAN
397: IS
398: BEGIN
399: IF p_resource_txns.poc_trans_id IS NOT NULL THEN

Line 400: UPDATE gme_resource_txns_gtmp

396: RETURN BOOLEAN
397: IS
398: BEGIN
399: IF p_resource_txns.poc_trans_id IS NOT NULL THEN
400: UPDATE gme_resource_txns_gtmp
401: SET
402: --ORGN_CODE = p_resource_txns.ORGN_CODE
403:
404: /* start , Punit Kumar */

Line 486: END gme_resource_txns_gtmp_dbl;

482: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
483: ,SQLERRM);
484: RETURN FALSE;
485: END update_row;
486: END gme_resource_txns_gtmp_dbl;