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_STEP_CHARGE_DBL dependencies on GME_BATCH_STEP_CHARGES

Line 3: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_CHARGES';

1: PACKAGE BODY gme_batch_step_charge_dbl AS
2: /* $Header: GMEVGSCB.pls 120.1 2005/06/03 13:46:38 appldev $ */
3: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_CHARGES';
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'gme_batch_step_charges_dbl';
5: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
6:
7: /* Api start of comments

Line 4: g_pkg_name CONSTANT VARCHAR2 (30) := 'gme_batch_step_charges_dbl';

1: PACKAGE BODY gme_batch_step_charge_dbl AS
2: /* $Header: GMEVGSCB.pls 120.1 2005/06/03 13:46:38 appldev $ */
3: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_CHARGES';
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'gme_batch_step_charges_dbl';
5: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
6:
7: /* Api start of comments
8: +==========================================================================+

Line 16: | insert_Row will insert a row in gme_batch_step_charges |

12: | TYPE |
13: | Private |
14: | |
15: | DESCRIPTION |
16: | insert_Row will insert a row in gme_batch_step_charges |
17: | |
18: | |
19: | PARAMETERS |
20: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

Line 20: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

16: | insert_Row will insert a row in gme_batch_step_charges |
17: | |
18: | |
19: | PARAMETERS |
20: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |
21: | x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE |
22: | RETURNS |
23: | BOOLEAN |
24: | |

Line 21: | x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE |

17: | |
18: | |
19: | PARAMETERS |
20: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |
21: | x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE |
22: | RETURNS |
23: | BOOLEAN |
24: | |
25: | HISTORY |

Line 33: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE

29: +==========================================================================+
30: Api end of comments
31: */
32: FUNCTION insert_row (
33: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE
34: ,x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE)
35: RETURN BOOLEAN
36: IS
37: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';

Line 34: ,x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE)

30: Api end of comments
31: */
32: FUNCTION insert_row (
33: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE
34: ,x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE)
35: RETURN BOOLEAN
36: IS
37: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
38: BEGIN

Line 41: INSERT INTO gme_batch_step_charges

37: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
38: BEGIN
39: x_batch_step_charges := p_batch_step_charges_in;
40:
41: INSERT INTO gme_batch_step_charges
42: (batch_id
43: ,batchstep_id
44: ,resources
45: ,charge_number

Line 87: | fetch_Row will fetch a row in gme_batch_step_charges |

83: | TYPE |
84: | Private |
85: | |
86: | USAGE |
87: | fetch_Row will fetch a row in gme_batch_step_charges |
88: | |
89: | |
90: | DESCRIPTION |
91: | fetch_row will fetch a row in gme_batch_step_charges |

Line 91: | fetch_row will fetch a row in gme_batch_step_charges |

87: | fetch_Row will fetch a row in gme_batch_step_charges |
88: | |
89: | |
90: | DESCRIPTION |
91: | fetch_row will fetch a row in gme_batch_step_charges |
92: | |
93: | |
94: | PARAMETERS |
95: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

Line 95: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

91: | fetch_row will fetch a row in gme_batch_step_charges |
92: | |
93: | |
94: | PARAMETERS |
95: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |
96: | x_batch_steps IN OUT NOCOPY gme_batch_step_charges%ROWTYPE |
97: | RETURNS |
98: | BOOLEAN |
99: | |

Line 96: | x_batch_steps IN OUT NOCOPY gme_batch_step_charges%ROWTYPE |

92: | |
93: | |
94: | PARAMETERS |
95: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |
96: | x_batch_steps IN OUT NOCOPY gme_batch_step_charges%ROWTYPE |
97: | RETURNS |
98: | BOOLEAN |
99: | |
100: | HISTORY |

Line 108: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE

104: +==========================================================================+
105: Api end of comments
106: */
107: FUNCTION fetch_row (
108: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE
109: ,x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE)
110: RETURN BOOLEAN
111: IS
112: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';

Line 109: ,x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE)

105: Api end of comments
106: */
107: FUNCTION fetch_row (
108: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE
109: ,x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE)
110: RETURN BOOLEAN
111: IS
112: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
113: BEGIN

Line 141: FROM gme_batch_step_charges

137: ,x_batch_step_charges.creation_date
138: ,x_batch_step_charges.created_by
139: ,x_batch_step_charges.last_updated_by
140: ,x_batch_step_charges.last_update_login
141: FROM gme_batch_step_charges
142: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id;
143: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
144: AND p_batch_step_charges_in.batchstep_id IS NOT NULL THEN
145: SELECT batch_id

Line 171: FROM gme_batch_step_charges

167: ,x_batch_step_charges.creation_date
168: ,x_batch_step_charges.created_by
169: ,x_batch_step_charges.last_updated_by
170: ,x_batch_step_charges.last_update_login
171: FROM gme_batch_step_charges
172: WHERE batch_id = p_batch_step_charges_in.batch_id
173: AND batchstep_id = p_batch_step_charges_in.batchstep_id;
174: ELSE
175: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 204: | update_Row will update a row in gme_batch_step_charges |

200: | TYPE |
201: | Private |
202: | |
203: | USAGE |
204: | update_Row will update a row in gme_batch_step_charges |
205: | |
206: | DESCRIPTION |
207: | update_row will update a row in gme_batch_step_charges |
208: | |

Line 207: | update_row will update a row in gme_batch_step_charges |

203: | USAGE |
204: | update_Row will update a row in gme_batch_step_charges |
205: | |
206: | DESCRIPTION |
207: | update_row will update a row in gme_batch_step_charges |
208: | |
209: | |
210: | PARAMETERS |
211: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

Line 211: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

207: | update_row will update a row in gme_batch_step_charges |
208: | |
209: | |
210: | PARAMETERS |
211: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |
212: | RETURNS |
213: | BOOLEAN |
214: | |
215: | HISTORY |

Line 223: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE)

219: +==========================================================================+
220: Api end of comments
221: */
222: FUNCTION update_row (
223: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE)
224: RETURN BOOLEAN
225: IS
226: CURSOR cur_both_ids (v_batch_id NUMBER, v_batchstep_id NUMBER)
227: IS

Line 229: FROM gme_batch_step_charges

225: IS
226: CURSOR cur_both_ids (v_batch_id NUMBER, v_batchstep_id NUMBER)
227: IS
228: SELECT 1
229: FROM gme_batch_step_charges
230: WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id
231: FOR UPDATE NOWAIT;
232:
233: CURSOR cur_step_id (v_batchstep_id NUMBER)

Line 236: FROM gme_batch_step_charges

232:
233: CURSOR cur_step_id (v_batchstep_id NUMBER)
234: IS
235: SELECT 1
236: FROM gme_batch_step_charges
237: WHERE batchstep_id = v_batchstep_id
238: FOR UPDATE NOWAIT;
239:
240: l_both_ids_rec NUMBER := 0;

Line 260: UPDATE gme_batch_step_charges

256: EXIT;
257: END IF;
258: END LOOP;
259:
260: UPDATE gme_batch_step_charges
261: SET batch_id = p_batch_step_charges_in.batch_id
262: ,batchstep_id = p_batch_step_charges_in.batchstep_id
263: ,resources = p_batch_step_charges_in.resources
264: ,activity_sequence_number =

Line 291: UPDATE gme_batch_step_charges

287: EXIT;
288: END IF;
289: END LOOP;
290:
291: UPDATE gme_batch_step_charges
292: SET batch_id = p_batch_step_charges_in.batch_id
293: ,batchstep_id = p_batch_step_charges_in.batchstep_id
294: ,resources = p_batch_step_charges_in.resources
295: ,activity_sequence_number =

Line 358: | delete_Row will delete a row in gme_batch_step_charges |

354: | TYPE |
355: | Private |
356: | |
357: | USAGE |
358: | delete_Row will delete a row in gme_batch_step_charges |
359: | |
360: | DESCRIPTION |
361: | delete_row will delete a row in gme_batch_step_charges |
362: | |

Line 361: | delete_row will delete a row in gme_batch_step_charges |

357: | USAGE |
358: | delete_Row will delete a row in gme_batch_step_charges |
359: | |
360: | DESCRIPTION |
361: | delete_row will delete a row in gme_batch_step_charges |
362: | |
363: | |
364: | PARAMETERS |
365: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

Line 365: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |

361: | delete_row will delete a row in gme_batch_step_charges |
362: | |
363: | |
364: | PARAMETERS |
365: | p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE |
366: | RETURNS |
367: | BOOLEAN |
368: | |
369: | HISTORY |

Line 377: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE)

373: +==========================================================================+
374: Api end of comments
375: */
376: FUNCTION delete_row (
377: p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE)
378: RETURN BOOLEAN
379: IS
380: CURSOR cur_both_ids (v_batch_id NUMBER, v_batchstep_id NUMBER)
381: IS

Line 383: FROM gme_batch_step_charges

379: IS
380: CURSOR cur_both_ids (v_batch_id NUMBER, v_batchstep_id NUMBER)
381: IS
382: SELECT 1
383: FROM gme_batch_step_charges
384: WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id
385: FOR UPDATE NOWAIT;
386:
387: CURSOR cur_step_id (v_batchstep_id NUMBER)

Line 390: FROM gme_batch_step_charges

386:
387: CURSOR cur_step_id (v_batchstep_id NUMBER)
388: IS
389: SELECT 1
390: FROM gme_batch_step_charges
391: WHERE batchstep_id = v_batchstep_id
392: FOR UPDATE NOWAIT;
393:
394: CURSOR cur_batch_id (v_batch_id NUMBER)

Line 397: FROM gme_batch_step_charges

393:
394: CURSOR cur_batch_id (v_batch_id NUMBER)
395: IS
396: SELECT 1
397: FROM gme_batch_step_charges
398: WHERE batch_id = v_batch_id
399: FOR UPDATE NOWAIT;
400:
401: l_both_ids_rec NUMBER := 0;

Line 439: DELETE FROM gme_batch_step_charges

435: EXIT;
436: END IF;
437: END LOOP;
438:
439: DELETE FROM gme_batch_step_charges
440: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id;
441: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
442: AND p_batch_step_charges_in.batchstep_id IS NOT NULL THEN
443: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

Line 466: DELETE FROM gme_batch_step_charges

462: EXIT;
463: END IF;
464: END LOOP;
465:
466: DELETE FROM gme_batch_step_charges
467: WHERE batch_id = p_batch_step_charges_in.batch_id
468: AND batchstep_id = p_batch_step_charges_in.batchstep_id;
469: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
470: AND p_batch_step_charges_in.batchstep_id IS NULL THEN

Line 492: DELETE FROM gme_batch_step_charges

488: EXIT;
489: END IF;
490: END LOOP;
491:
492: DELETE FROM gme_batch_step_charges
493: WHERE batch_id = p_batch_step_charges_in.batch_id;
494: ELSE
495: gme_common_pvt.log_message ('GME_NO_KEYS'
496: ,'TABLE_NAME'