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_STEPS_DBL dependencies on GME_BATCH_STEPS

Line 1: PACKAGE BODY gme_batch_steps_dbl AS

1: PACKAGE BODY gme_batch_steps_dbl AS
2: /* $Header: GMEVGBSB.pls 120.3 2006/06/14 14:43:18 svgonugu noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEPS';

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

1: PACKAGE BODY gme_batch_steps_dbl AS
2: /* $Header: GMEVGBSB.pls 120.3 2006/06/14 14:43:18 svgonugu noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEPS';
6: g_pkg_name CONSTANT VARCHAR2 (30) := 'gme_batch_step_dbl';
7: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
8:
9: /* ===========================================================================

Line 19: | Body of package gme_batch_steps_dbl |

15: | GMEVGBSB.pls |
16: | |
17: | DESCRIPTION |
18: | |
19: | Body of package gme_batch_steps_dbl |
20: | |
21: | NOTES |
22: | HISTORY |
23: | |

Line 53: | insert_Row will insert a row in gme_batch_steps |

49: | TYPE |
50: | Private |
51: | |
52: | USAGE |
53: | insert_Row will insert a row in gme_batch_steps |
54: | |
55: | |
56: | DESCRIPTION |
57: | insert_Row will insert a row in gme_batch_steps |

Line 57: | insert_Row will insert a row in gme_batch_steps |

53: | insert_Row will insert a row in gme_batch_steps |
54: | |
55: | |
56: | DESCRIPTION |
57: | insert_Row will insert a row in gme_batch_steps |
58: | |
59: | |
60: | PARAMETERS |
61: | p_batch_step IN gme_batch_step%ROWTYPE |

Line 77: p_batch_step IN gme_batch_steps%ROWTYPE

73: +==========================================================================+
74: Api end of comments
75: */
76: FUNCTION insert_row (
77: p_batch_step IN gme_batch_steps%ROWTYPE
78: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE)
79: RETURN BOOLEAN
80: IS
81: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';

Line 78: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE)

74: Api end of comments
75: */
76: FUNCTION insert_row (
77: p_batch_step IN gme_batch_steps%ROWTYPE
78: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE)
79: RETURN BOOLEAN
80: IS
81: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
82: BEGIN

Line 90: INSERT INTO gme_batch_steps

86: END IF;
87:
88: x_batch_step := p_batch_step;
89:
90: INSERT INTO gme_batch_steps
91: (batch_id, batchstep_id
92: ,routingstep_id, batchstep_no
93: ,oprn_id, plan_step_qty
94: ,actual_step_qty

Line 218: | fetch_Row will fetch a row in gme_batch_steps |

214: | TYPE |
215: | Private |
216: | |
217: | USAGE |
218: | fetch_Row will fetch a row in gme_batch_steps |
219: | |
220: | |
221: | DESCRIPTION |
222: | fetch_row will fetch a row in gme_batch_steps |

Line 222: | fetch_row will fetch a row in gme_batch_steps |

218: | fetch_Row will fetch a row in gme_batch_steps |
219: | |
220: | |
221: | DESCRIPTION |
222: | fetch_row will fetch a row in gme_batch_steps |
223: | |
224: | |
225: | PARAMETERS |
226: | p_batch_step IN gme_batch_steps%ROWTYPE |

Line 226: | p_batch_step IN gme_batch_steps%ROWTYPE |

222: | fetch_row will fetch a row in gme_batch_steps |
223: | |
224: | |
225: | PARAMETERS |
226: | p_batch_step IN gme_batch_steps%ROWTYPE |
227: | x_batch_steps IN OUT NOCOPY gme_batch_steps%ROWTYPE |
228: | RETURNS |
229: | BOOLEAN |
230: | |

Line 227: | x_batch_steps IN OUT NOCOPY gme_batch_steps%ROWTYPE |

223: | |
224: | |
225: | PARAMETERS |
226: | p_batch_step IN gme_batch_steps%ROWTYPE |
227: | x_batch_steps IN OUT NOCOPY gme_batch_steps%ROWTYPE |
228: | RETURNS |
229: | BOOLEAN |
230: | |
231: | HISTORY |

Line 241: p_batch_step IN gme_batch_steps%ROWTYPE

237: +==========================================================================+
238: Api end of comments
239: */
240: FUNCTION fetch_row (
241: p_batch_step IN gme_batch_steps%ROWTYPE
242: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE)
243: RETURN BOOLEAN
244: IS
245: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';

Line 242: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE)

238: Api end of comments
239: */
240: FUNCTION fetch_row (
241: p_batch_step IN gme_batch_steps%ROWTYPE
242: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE)
243: RETURN BOOLEAN
244: IS
245: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
246: BEGIN

Line 343: FROM gme_batch_steps

339: ,x_batch_step.minimum_transfer_qty
340: ,x_batch_step.terminated_ind, x_batch_step.step_qty_um
341: ,x_batch_step.mass_ref_um, x_batch_step.volume_ref_um
342: ,x_batch_step.max_step_capacity_um --Bug#5231180
343: FROM gme_batch_steps
344: WHERE batchstep_id = p_batch_step.batchstep_id;
345: ELSIF p_batch_step.batch_id IS NOT NULL
346: AND p_batch_step.batchstep_no IS NOT NULL THEN
347: SELECT batch_id, batchstep_id

Line 437: FROM gme_batch_steps

433: ,x_batch_step.minimum_transfer_qty
434: ,x_batch_step.terminated_ind, x_batch_step.step_qty_um
435: ,x_batch_step.mass_ref_um, x_batch_step.volume_ref_um
436: ,x_batch_step.max_step_capacity_um --Bug#5231180
437: FROM gme_batch_steps
438: WHERE batch_id = p_batch_step.batch_id
439: AND batchstep_no = p_batch_step.batchstep_no;
440: ELSE
441: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 475: | delete_Row will delete a row in gme_batch_steps |

471: | TYPE |
472: | Private |
473: | |
474: | USAGE |
475: | delete_Row will delete a row in gme_batch_steps |
476: | |
477: | |
478: | DESCRIPTION |
479: | delete_row will delete a row in gme_batch_steps |

Line 479: | delete_row will delete a row in gme_batch_steps |

475: | delete_Row will delete a row in gme_batch_steps |
476: | |
477: | |
478: | DESCRIPTION |
479: | delete_row will delete a row in gme_batch_steps |
480: | |
481: | |
482: | PARAMETERS |
483: | p_batch_step IN gme_batch_steps%ROWTYPE |

Line 483: | p_batch_step IN gme_batch_steps%ROWTYPE |

479: | delete_row will delete a row in gme_batch_steps |
480: | |
481: | |
482: | PARAMETERS |
483: | p_batch_step IN gme_batch_steps%ROWTYPE |
484: | RETURNS |
485: | BOOLEAN |
486: | |
487: | HISTORY |

Line 495: FUNCTION delete_row (p_batch_step IN gme_batch_steps%ROWTYPE)

491: | |
492: +==========================================================================+
493: Api end of comments
494: */
495: FUNCTION delete_row (p_batch_step IN gme_batch_steps%ROWTYPE)
496: RETURN BOOLEAN
497: IS
498: l_dummy NUMBER (5) := 0;
499: locked_by_other_user EXCEPTION;

Line 511: FROM gme_batch_steps

507:
508: IF p_batch_step.batchstep_id IS NOT NULL THEN
509: SELECT 1
510: INTO l_dummy
511: FROM gme_batch_steps
512: WHERE batchstep_id = p_batch_step.batchstep_id
513: FOR UPDATE NOWAIT;
514:
515: DELETE FROM gme_batch_steps

Line 515: DELETE FROM gme_batch_steps

511: FROM gme_batch_steps
512: WHERE batchstep_id = p_batch_step.batchstep_id
513: FOR UPDATE NOWAIT;
514:
515: DELETE FROM gme_batch_steps
516: WHERE batchstep_id = p_batch_step.batchstep_id;
517: ELSIF p_batch_step.batch_id IS NOT NULL
518: AND p_batch_step.batchstep_no IS NOT NULL THEN
519: SELECT 1

Line 521: FROM gme_batch_steps

517: ELSIF p_batch_step.batch_id IS NOT NULL
518: AND p_batch_step.batchstep_no IS NOT NULL THEN
519: SELECT 1
520: INTO l_dummy
521: FROM gme_batch_steps
522: WHERE batch_id = p_batch_step.batch_id
523: AND batchstep_no = p_batch_step.batchstep_no
524: FOR UPDATE NOWAIT;
525:

Line 526: DELETE FROM gme_batch_steps

522: WHERE batch_id = p_batch_step.batch_id
523: AND batchstep_no = p_batch_step.batchstep_no
524: FOR UPDATE NOWAIT;
525:
526: DELETE FROM gme_batch_steps
527: WHERE batch_id = p_batch_step.batch_id
528: AND batchstep_no = p_batch_step.batchstep_no;
529: ELSE
530: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 586: | update_row will update a row in gme_batch_steps |

582: | TYPE |
583: | Private |
584: | |
585: | USAGE |
586: | update_row will update a row in gme_batch_steps |
587: | |
588: | |
589: | DESCRIPTION |
590: | update_row will update a row in gme_batch_steps |

Line 590: | update_row will update a row in gme_batch_steps |

586: | update_row will update a row in gme_batch_steps |
587: | |
588: | |
589: | DESCRIPTION |
590: | update_row will update a row in gme_batch_steps |
591: | |
592: | |
593: | PARAMETERS |
594: | p_batch_step IN gme_batch_steps%ROWTYPE |

Line 594: | p_batch_step IN gme_batch_steps%ROWTYPE |

590: | update_row will update a row in gme_batch_steps |
591: | |
592: | |
593: | PARAMETERS |
594: | p_batch_step IN gme_batch_steps%ROWTYPE |
595: | RETURNS |
596: | BOOLEAN |
597: | |
598: | HISTORY |

Line 608: FUNCTION update_row (p_batch_step IN gme_batch_steps%ROWTYPE)

604: | |
605: +==========================================================================+
606: Api end of comments
607: */
608: FUNCTION update_row (p_batch_step IN gme_batch_steps%ROWTYPE)
609: RETURN BOOLEAN
610: IS
611: l_dummy NUMBER := 0;
612: locked_by_other_user EXCEPTION;

Line 624: FROM gme_batch_steps

620:
621: IF p_batch_step.batchstep_id IS NOT NULL THEN
622: SELECT 1
623: INTO l_dummy
624: FROM gme_batch_steps
625: WHERE batchstep_id = p_batch_step.batchstep_id
626: FOR UPDATE NOWAIT;
627:
628: UPDATE gme_batch_steps

Line 628: UPDATE gme_batch_steps

624: FROM gme_batch_steps
625: WHERE batchstep_id = p_batch_step.batchstep_id
626: FOR UPDATE NOWAIT;
627:
628: UPDATE gme_batch_steps
629: SET routingstep_id = p_batch_step.routingstep_id
630: ,batchstep_no = p_batch_step.batchstep_no
631: ,oprn_id = p_batch_step.oprn_id
632: ,plan_step_qty = p_batch_step.plan_step_qty

Line 704: FROM gme_batch_steps

700: ELSIF p_batch_step.batch_id IS NOT NULL
701: AND p_batch_step.batchstep_no IS NOT NULL THEN
702: SELECT 1
703: INTO l_dummy
704: FROM gme_batch_steps
705: WHERE batch_id = p_batch_step.batch_id
706: AND batchstep_no = p_batch_step.batchstep_no
707: FOR UPDATE NOWAIT;
708:

Line 709: UPDATE gme_batch_steps

705: WHERE batch_id = p_batch_step.batch_id
706: AND batchstep_no = p_batch_step.batchstep_no
707: FOR UPDATE NOWAIT;
708:
709: UPDATE gme_batch_steps
710: SET routingstep_id = p_batch_step.routingstep_id
711: ,batchstep_no = p_batch_step.batchstep_no
712: ,oprn_id = p_batch_step.oprn_id
713: ,plan_step_qty = p_batch_step.plan_step_qty

Line 831: FUNCTION lock_row (p_batch_step IN gme_batch_steps%ROWTYPE)

827: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
828: RETURN FALSE;
829: END update_row;
830:
831: FUNCTION lock_row (p_batch_step IN gme_batch_steps%ROWTYPE)
832: RETURN BOOLEAN
833: IS
834: l_dummy NUMBER;
835: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';

Line 845: FROM gme_batch_steps

841:
842: IF p_batch_step.batchstep_id IS NOT NULL THEN
843: SELECT 1
844: INTO l_dummy
845: FROM gme_batch_steps
846: WHERE batchstep_id = p_batch_step.batchstep_id
847: FOR UPDATE NOWAIT;
848: END IF;
849: