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

Line 32: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE

28: Purge the data only if there are no exceptions.
29: =============================================================================================*/
30:
31: PROCEDURE complete_step
32: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
33: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
34: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
35: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
36: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 34: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE

30:
31: PROCEDURE complete_step
32: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
33: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
34: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
35: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
36: ,x_return_status OUT NOCOPY VARCHAR2) IS
37:
38: CURSOR Cur_step_count(v_batch_id NUMBER) IS

Line 40: FROM GME_BATCH_STEPS

36: ,x_return_status OUT NOCOPY VARCHAR2) IS
37:
38: CURSOR Cur_step_count(v_batch_id NUMBER) IS
39: SELECT count(1)
40: FROM GME_BATCH_STEPS
41: WHERE batch_id = v_batch_id
42: AND step_status < gme_common_pvt.g_step_completed
43: AND rownum = 1;
44:

Line 49: l_batch_step_rec gme_batch_steps%ROWTYPE;

45: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step';
46:
47: l_batch_header_rec gme_batch_header%ROWTYPE;
48: l_in_batch_header_rec gme_batch_header%ROWTYPE;
49: l_batch_step_rec gme_batch_steps%ROWTYPE;
50: l_return_status VARCHAR2(1);
51: l_step_count NUMBER;
52:
53: error_release_batch EXCEPTION;

Line 215: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

211: x_return_status := FND_API.g_ret_sts_unexp_error;
212: END complete_step;
213:
214: PROCEDURE complete_step_recursive
215: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
216: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
217: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
218: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
219: ,x_return_status OUT NOCOPY VARCHAR2

Line 217: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

213:
214: PROCEDURE complete_step_recursive
215: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
216: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
217: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
218: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
219: ,x_return_status OUT NOCOPY VARCHAR2
220: ,p_quality_override IN BOOLEAN := FALSE) IS --Bug#6348353
221:

Line 224: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

220: ,p_quality_override IN BOOLEAN := FALSE) IS --Bug#6348353
221:
222: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step_recursive';
223:
224: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
225: l_return_status VARCHAR2 (1);
226: l_msg_count NUMBER;
227: l_msg_stack VARCHAR2 (2000);
228: l_lock_status VARCHAR2(1);

Line 439: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

435:
436: =============================================================================================*/
437:
438: PROCEDURE complete_step_line
439: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
440: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
441: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
442: ,x_return_status OUT NOCOPY VARCHAR2) IS
443:

Line 440: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

436: =============================================================================================*/
437:
438: PROCEDURE complete_step_line
439: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
440: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
441: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
442: ,x_return_status OUT NOCOPY VARCHAR2) IS
443:
444: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step_line';

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

460: /* Update the Batch Step Status to WIP */
461: x_batch_step_rec.step_status := gme_common_pvt.g_step_completed;
462:
463: -- Update the batch step
464: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec)) THEN
465: RAISE batch_step_upd_err;
466: END IF;
467:
468: -- Update WHO columns for output structure

Line 521: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

517: x_return_status := FND_API.g_ret_sts_unexp_error;
518: END complete_step_line;
519:
520: PROCEDURE complete_step_material
521: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
522: ,p_update_inv_ind IN VARCHAR2
523: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
524: ,x_return_status OUT NOCOPY VARCHAR2) IS
525:

Line 607: FROM gme_batch_step_dependencies d, gme_batch_steps s

603:
604: CURSOR Cur_get_dep_steps(v_batch_id NUMBER, v_step_id NUMBER) IS
605: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,
606: s.step_status,s.actual_cmplt_date,s.actual_start_date
607: FROM gme_batch_step_dependencies d, gme_batch_steps s
608: WHERE d.batchstep_id = v_step_id
609: AND s.batchstep_id = d.dep_step_id
610: AND s.batch_id = v_batch_id
611: AND s.batch_id = d.batch_id;

Line 679: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

675: x_return_status := FND_API.g_ret_sts_unexp_error;
676: END validate_dependent_steps;
677:
678: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
679: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
680: ,p_override_quality IN VARCHAR2
681: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
682: ,x_return_status OUT NOCOPY VARCHAR2) IS
683:

Line 681: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

677:
678: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
679: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
680: ,p_override_quality IN VARCHAR2
681: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
682: ,x_return_status OUT NOCOPY VARCHAR2) IS
683:
684: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_complete';
685: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)

Line 901: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE

897: Improved performance of dependent step cursor. This issue was found by migration testing.
898: =============================================================================================*/
899:
900: PROCEDURE validate_step_cmplt_date
901: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
902: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
903: ,x_batch_start_date OUT NOCOPY DATE
904: ,x_return_status OUT NOCOPY VARCHAR2) IS
905:

Line 918: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) s,

914:
915: CURSOR Cur_get_dep_steps IS
916: SELECT dep_step_id, dep_type, standard_delay
917: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = p_batch_header_rec.batch_id) d,
918: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) s,
919: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) p
920: WHERE s.batchstep_id = d.batchstep_id
921: AND p.batchstep_id(+) = d.dep_step_id
922: START WITH d.batchstep_id = p_batch_step_rec.batchstep_id

Line 919: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) p

915: CURSOR Cur_get_dep_steps IS
916: SELECT dep_step_id, dep_type, standard_delay
917: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = p_batch_header_rec.batch_id) d,
918: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) s,
919: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) p
920: WHERE s.batchstep_id = d.batchstep_id
921: AND p.batchstep_id(+) = d.dep_step_id
922: START WITH d.batchstep_id = p_batch_step_rec.batchstep_id
923: CONNECT BY d.batchstep_id = PRIOR d.dep_step_id;

Line 930: l_batch_step GME_BATCH_STEPS%ROWTYPE;

926: BATCH_STEP_FETCH_ERROR EXCEPTION;
927: INVALID_DATE_ERR EXCEPTION;
928: X_prev_start_date DATE;
929: X_prev_step NUMBER;
930: l_batch_step GME_BATCH_STEPS%ROWTYPE;
931:
932: BEGIN
933: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
934: gme_debug.g_log_procedure THEN

Line 962: IF NOT (GME_BATCH_STEPS_DBL.fetch_row(l_batch_step, l_batch_step)) THEN

958: FOR get_rec IN Cur_get_dep_steps LOOP
959: l_batch_step.batchstep_id := get_rec.dep_step_id;
960:
961: -- Initialize batch step row
962: IF NOT (GME_BATCH_STEPS_DBL.fetch_row(l_batch_step, l_batch_step)) THEN
963: RAISE BATCH_STEP_FETCH_ERROR;
964: END IF;
965:
966: -- Check if the step has a complete date if so validate otherwise assign one to it