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 23: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE

19: X - Unallocated Items Found
20: =============================================================================================*/
21:
22: PROCEDURE complete_step
23: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
24: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
25: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
26: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
27: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 25: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE

21:
22: PROCEDURE complete_step
23: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
24: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
25: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
26: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
27: ,x_return_status OUT NOCOPY VARCHAR2) IS
28:
29: CURSOR Cur_step_count(v_batch_id NUMBER) IS

Line 31: FROM GME_BATCH_STEPS

27: ,x_return_status OUT NOCOPY VARCHAR2) IS
28:
29: CURSOR Cur_step_count(v_batch_id NUMBER) IS
30: SELECT count(1)
31: FROM GME_BATCH_STEPS
32: WHERE batch_id = v_batch_id
33: AND step_status < gme_common_pvt.g_step_completed
34: AND rownum = 1;
35:

Line 40: l_batch_step_rec gme_batch_steps%ROWTYPE;

36: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step';
37:
38: l_batch_header_rec gme_batch_header%ROWTYPE;
39: l_in_batch_header_rec gme_batch_header%ROWTYPE;
40: l_batch_step_rec gme_batch_steps%ROWTYPE;
41: l_return_status VARCHAR2(1);
42: l_step_count NUMBER;
43:
44: error_release_batch EXCEPTION;

Line 183: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

179: x_return_status := FND_API.g_ret_sts_unexp_error;
180: END complete_step;
181:
182: PROCEDURE complete_step_recursive
183: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
184: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
185: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
186: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
187: ,x_return_status OUT NOCOPY VARCHAR2

Line 185: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

181:
182: PROCEDURE complete_step_recursive
183: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
184: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
185: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
186: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
187: ,x_return_status OUT NOCOPY VARCHAR2
188: , p_quality_override IN BOOLEAN := FALSE) IS --Bug#6348353
189:

Line 192: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

188: , p_quality_override IN BOOLEAN := FALSE) IS --Bug#6348353
189:
190: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step_recursive';
191:
192: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
193: l_return_status VARCHAR2 (1);
194: l_msg_count NUMBER;
195: l_msg_stack VARCHAR2 (2000);
196: l_lock_status VARCHAR2(1);

Line 382: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

378:
379: =============================================================================================*/
380:
381: PROCEDURE complete_step_line
382: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
383: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
384: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
385: ,x_return_status OUT NOCOPY VARCHAR2) IS
386:

Line 383: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

379: =============================================================================================*/
380:
381: PROCEDURE complete_step_line
382: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
383: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
384: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
385: ,x_return_status OUT NOCOPY VARCHAR2) IS
386:
387: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step_line';

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

403: /* Update the Batch Step Status to WIP */
404: x_batch_step_rec.step_status := gme_common_pvt.g_step_completed;
405:
406: -- Update the batch step
407: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec)) THEN
408: RAISE batch_step_upd_err;
409: END IF;
410:
411: -- Update WHO columns for output structure

Line 464: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

460: x_return_status := FND_API.g_ret_sts_unexp_error;
461: END complete_step_line;
462:
463: PROCEDURE complete_step_material
464: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
465: ,p_update_inv_ind IN VARCHAR2
466: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
467: ,x_return_status OUT NOCOPY VARCHAR2) IS
468:

Line 549: FROM gme_batch_step_dependencies d, gme_batch_steps s

545:
546: CURSOR Cur_get_dep_steps(v_batch_id NUMBER, v_step_id NUMBER) IS
547: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,
548: s.step_status,s.actual_cmplt_date,s.actual_start_date
549: FROM gme_batch_step_dependencies d, gme_batch_steps s
550: WHERE d.batchstep_id = v_step_id
551: AND s.batchstep_id = d.dep_step_id
552: AND s.batch_id = v_batch_id
553: AND s.batch_id = d.batch_id;

Line 621: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

617: x_return_status := FND_API.g_ret_sts_unexp_error;
618: END validate_dependent_steps;
619:
620: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
621: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
622: ,p_override_quality IN VARCHAR2
623: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
624: ,x_return_status OUT NOCOPY VARCHAR2) IS
625:

Line 623: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

619:
620: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
621: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
622: ,p_override_quality IN VARCHAR2
623: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
624: ,x_return_status OUT NOCOPY VARCHAR2) IS
625:
626: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_complete';
627: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)

Line 824: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE

820:
821: =============================================================================================*/
822:
823: PROCEDURE validate_step_cmplt_date
824: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
825: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
826: ,x_batch_start_date OUT NOCOPY DATE
827: ,x_return_status OUT NOCOPY VARCHAR2) IS
828:

Line 841: l_batch_step GME_BATCH_STEPS%ROWTYPE;

837: BATCH_STEP_FETCH_ERROR EXCEPTION;
838: INVALID_DATE_ERR EXCEPTION;
839: X_prev_start_date DATE;
840: X_prev_step NUMBER;
841: l_batch_step GME_BATCH_STEPS%ROWTYPE;
842:
843: BEGIN
844: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
845: gme_debug.g_log_procedure THEN

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

869: FOR get_rec IN Cur_get_dep_steps LOOP
870: l_batch_step.batchstep_id := get_rec.dep_step_id;
871:
872: -- Initialize batch step row
873: IF NOT (GME_BATCH_STEPS_DBL.fetch_row(l_batch_step, l_batch_step)) THEN
874: RAISE BATCH_STEP_FETCH_ERROR;
875: END IF;
876:
877: -- Check if the step has a complete date if so validate otherwise assign one to it