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

Line 27: p_batch_step_rec IN gme_batch_steps%ROWTYPE

23: U - Unexpected error
24: X - Exceptions found
25: =============================================================================================*/
26: PROCEDURE release_step (
27: p_batch_step_rec IN gme_batch_steps%ROWTYPE
28: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
29: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
30: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
31: ,x_return_status OUT NOCOPY VARCHAR2)

Line 29: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

25: =============================================================================================*/
26: PROCEDURE release_step (
27: p_batch_step_rec IN gme_batch_steps%ROWTYPE
28: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
29: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
30: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
31: ,x_return_status OUT NOCOPY VARCHAR2)
32: IS
33: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';

Line 40: l_batch_step_rec gme_batch_steps%ROWTYPE;

36: error_release_step_rec EXCEPTION;
37: /* Local variables */
38: l_return_status VARCHAR2 (1);
39: l_batch_header_rec gme_batch_header%ROWTYPE;
40: l_batch_step_rec gme_batch_steps%ROWTYPE;
41: --Bug#5109119
42: l_in_batch_header_rec gme_batch_header%ROWTYPE;
43: BEGIN
44: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 153: p_batch_step_rec IN gme_batch_steps%ROWTYPE

149: U - Unexpected error
150: X - Exception found
151: =============================================================================================*/
152: PROCEDURE release_step_recursive (
153: p_batch_step_rec IN gme_batch_steps%ROWTYPE
154: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
155: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
156: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
157: ,x_return_status OUT NOCOPY VARCHAR2)

Line 155: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

151: =============================================================================================*/
152: PROCEDURE release_step_recursive (
153: p_batch_step_rec IN gme_batch_steps%ROWTYPE
154: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
155: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
156: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
157: ,x_return_status OUT NOCOPY VARCHAR2)
158: IS
159: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_recursive';

Line 170: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

166: /* Local variables */
167: l_return_status VARCHAR2 (1);
168: l_msg_count NUMBER;
169: l_msg_stack VARCHAR2 (2000);
170: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
171: l_batch_step_rec gme_batch_steps%ROWTYPE;
172: BEGIN
173: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
174: gme_debug.g_log_procedure THEN

Line 171: l_batch_step_rec gme_batch_steps%ROWTYPE;

167: l_return_status VARCHAR2 (1);
168: l_msg_count NUMBER;
169: l_msg_stack VARCHAR2 (2000);
170: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
171: l_batch_step_rec gme_batch_steps%ROWTYPE;
172: BEGIN
173: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
174: gme_debug.g_log_procedure THEN
175: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 306: p_batch_step_rec IN gme_batch_steps%ROWTYPE

302: x_return_status := fnd_api.g_ret_sts_unexp_error;
303: END release_step_recursive;
304:
305: PROCEDURE process_dependent_steps (
306: p_batch_step_rec IN gme_batch_steps%ROWTYPE
307: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
308: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
309: ,x_return_status OUT NOCOPY VARCHAR2)
310: IS

Line 317: FROM gme_batch_step_dependencies d, gme_batch_steps s

313: CURSOR cur_get_dep_steps (v_batchstep_id NUMBER, v_batch_id NUMBER)
314: IS
315: SELECT d.dep_step_id, d.dep_type, d.standard_delay
316: ,s.steprelease_type, s.step_status
317: FROM gme_batch_step_dependencies d, gme_batch_steps s
318: WHERE d.batchstep_id = v_batchstep_id
319: AND s.batchstep_id = d.dep_step_id
320: AND s.batch_id = v_batch_id
321: AND d.batch_id = s.batch_id;

Line 325: l_batch_step_rec gme_batch_steps%ROWTYPE;

321: AND d.batch_id = s.batch_id;
322:
323: l_dep_step_rec cur_get_dep_steps%ROWTYPE;
324: l_return_status VARCHAR2 (1);
325: l_batch_step_rec gme_batch_steps%ROWTYPE;
326: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
327: l_complete_dep_step BOOLEAN;
328:
329: batch_step_fetch_error EXCEPTION;

Line 326: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

322:
323: l_dep_step_rec cur_get_dep_steps%ROWTYPE;
324: l_return_status VARCHAR2 (1);
325: l_batch_step_rec gme_batch_steps%ROWTYPE;
326: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
327: l_complete_dep_step BOOLEAN;
328:
329: batch_step_fetch_error EXCEPTION;
330: dep_step_rel_error EXCEPTION;

Line 405: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

401: IF l_dep_step_rec.steprelease_type =
402: gme_common_pvt.g_auto_step_release THEN
403: l_batch_step_rec.batchstep_id := l_dep_step_rec.dep_step_id;
404:
405: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
406: ,l_batch_step_rec) ) THEN
407: RAISE batch_step_fetch_error;
408: END IF;
409:

Line 560: p_batch_step_rec IN gme_batch_steps%ROWTYPE

556: G. Muratore 27-MAR-2012 Bug 13706812
557: Improved performance of activities cursor. This issue was found by migration testing.
558: =============================================================================================*/
559: PROCEDURE release_step_line (
560: p_batch_step_rec IN gme_batch_steps%ROWTYPE
561: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
562: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
563: ,x_return_status OUT NOCOPY VARCHAR2)
564: IS

Line 561: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

557: Improved performance of activities cursor. This issue was found by migration testing.
558: =============================================================================================*/
559: PROCEDURE release_step_line (
560: p_batch_step_rec IN gme_batch_steps%ROWTYPE
561: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
562: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
563: ,x_return_status OUT NOCOPY VARCHAR2)
564: IS
565: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_line';

Line 567: l_batch_step_rec gme_batch_steps%ROWTYPE;

563: ,x_return_status OUT NOCOPY VARCHAR2)
564: IS
565: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_line';
566: l_return_status VARCHAR2 (1);
567: l_batch_step_rec gme_batch_steps%ROWTYPE;
568: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
569: batch_step_upd_err EXCEPTION;
570: BEGIN
571: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 568: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

564: IS
565: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_line';
566: l_return_status VARCHAR2 (1);
567: l_batch_step_rec gme_batch_steps%ROWTYPE;
568: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
569: batch_step_upd_err EXCEPTION;
570: BEGIN
571: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
572: gme_debug.g_log_procedure THEN

Line 590: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN

586: /* Update the Batch Step Status to WIP */
587: x_batch_step_rec.step_status := gme_common_pvt.g_step_wip;
588:
589: -- Update the batch step
590: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
591: RAISE batch_step_upd_err;
592: END IF;
593:
594: -- Update WHO columns for output structure

Line 644: p_batch_step_rec IN gme_batch_steps%ROWTYPE

640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: END release_step_line;
642:
643: PROCEDURE release_step_ingredients (
644: p_batch_step_rec IN gme_batch_steps%ROWTYPE
645: ,p_update_inv_ind IN VARCHAR2
646: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
647: ,x_return_status OUT NOCOPY VARCHAR2)
648: IS

Line 749: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

745: x_return_status := fnd_api.g_ret_sts_unexp_error;
746: END release_step_ingredients;
747:
748: PROCEDURE validate_step_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
749: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
750: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
751: ,x_return_status OUT NOCOPY VARCHAR2) IS
752:
753: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_release';

Line 750: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

746: END release_step_ingredients;
747:
748: PROCEDURE validate_step_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
749: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
750: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
751: ,x_return_status OUT NOCOPY VARCHAR2) IS
752:
753: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_release';
754: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)