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_CLOSE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 26: p_batch_header_rec IN gme_batch_header%ROWTYPE

22: 08-AUG-2002 Shrikant Nene Bug# 2495557
23: Close the "not yet closed" phantom batches.
24: ================================================================================*/
25: PROCEDURE close_batch (
26: p_batch_header_rec IN gme_batch_header%ROWTYPE
27: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
28: ,x_return_status OUT NOCOPY VARCHAR2)
29: IS
30: /* Miscellaneous */

Line 27: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

23: Close the "not yet closed" phantom batches.
24: ================================================================================*/
25: PROCEDURE close_batch (
26: p_batch_header_rec IN gme_batch_header%ROWTYPE
27: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
28: ,x_return_status OUT NOCOPY VARCHAR2)
29: IS
30: /* Miscellaneous */
31: l_api_name CONSTANT VARCHAR2 (30) := 'close_batch';

Line 40: l_batch_header gme_batch_header%ROWTYPE;

36: l_return_status VARCHAR2 (1);
37: l_ins_history gme_batch_history%ROWTYPE;
38: l_batch_step gme_batch_steps%ROWTYPE;
39: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
40: l_batch_header gme_batch_header%ROWTYPE;
41: l_in_batch_header gme_batch_header%ROWTYPE;
42: l_material_detail_ids gme_common_pvt.number_tab;
43: l_message_count NUMBER;
44: l_message_list VARCHAR2 (2000);

Line 41: l_in_batch_header gme_batch_header%ROWTYPE;

37: l_ins_history gme_batch_history%ROWTYPE;
38: l_batch_step gme_batch_steps%ROWTYPE;
39: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
40: l_batch_header gme_batch_header%ROWTYPE;
41: l_in_batch_header gme_batch_header%ROWTYPE;
42: l_material_detail_ids gme_common_pvt.number_tab;
43: l_message_count NUMBER;
44: l_message_list VARCHAR2 (2000);
45: l_step_count NUMBER;

Line 46: l_batch_header_rec gme_batch_header%ROWTYPE;

42: l_material_detail_ids gme_common_pvt.number_tab;
43: l_message_count NUMBER;
44: l_message_list VARCHAR2 (2000);
45: l_step_count NUMBER;
46: l_batch_header_rec gme_batch_header%ROWTYPE;
47:
48: /*siva FPbug#4684029*/
49: l_gmf_cost_alloc_calc NUMBER;
50: l_total_plan_output NUMBER;

Line 86: FROM gme_material_details d, gme_batch_header h

82: /* Get only the phantom ingredients which are not close already */
83: CURSOR cur_get_phant
84: IS
85: SELECT phantom_id
86: FROM gme_material_details d, gme_batch_header h
87: WHERE d.batch_id = x_batch_header_rec.batch_id
88: AND phantom_id IS NOT NULL
89: AND h.batch_id = d.phantom_id
90: AND h.batch_status <> 4;

Line 122: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

118: /* Set the success staus to success inititally*/
119: x_return_status := fnd_api.g_ret_sts_success;
120:
121: /* Initialize output batch header*/
122: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
123: ,x_batch_header_rec) ) THEN
124: RAISE batch_header_fetch_error;
125: END IF;
126:

Line 215: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN

211: /* Set up the fields in output structure. */
212: x_batch_header_rec.batch_status := 4;
213:
214: /* Update the batch step to the database */
215: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN
216: RAISE batch_header_upd_err;
217: END IF;
218:
219: /* Insert the event into the batch history table */

Line 241: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header

237: FOR l_rec IN cur_get_phant LOOP
238: l_batch_header.batch_id := l_rec.phantom_id;
239:
240: /* Initialize batch header*/
241: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header
242: ,l_in_batch_header) ) THEN
243: RAISE batch_header_fetch_error;
244: END IF;
245:

Line 414: FUNCTION create_history (p_batch_header_rec IN gme_batch_header%ROWTYPE)

410:
411: Parameters
412: p_batch_header_rec Batch header row
413: ==================================================================================*/
414: FUNCTION create_history (p_batch_header_rec IN gme_batch_header%ROWTYPE)
415: RETURN BOOLEAN
416: IS
417: /* Local variable definitions */
418: l_return_status VARCHAR2 (1);

Line 457: FUNCTION check_close_date (p_batch_header_rec IN gme_batch_header%ROWTYPE)

453: Parameters
454: p_batch_header_rec Batch header row
455: History
456: ==================================================================================*/
457: FUNCTION check_close_date (p_batch_header_rec IN gme_batch_header%ROWTYPE)
458: RETURN BOOLEAN
459: IS
460: CURSOR cur_batch_steps (v_batch_id NUMBER)
461: IS

Line 481: x_batch_row gme_batch_header%ROWTYPE;

477: START WITH batch_id = v_batch_id
478: CONNECT BY batch_id = PRIOR phantom_id;
479:
480: x_batch_tbl gme_common_pvt.number_tab;
481: x_batch_row gme_batch_header%ROWTYPE;
482: x_mat_cnt NUMBER;
483: x_rsrc_cnt NUMBER;
484: x_status VARCHAR2 (10);
485: x_date DATE;

Line 545: FROM gme_batch_header

541:
542: CURSOR cur_batch_cmplt_date (v_batch_id NUMBER)
543: IS
544: SELECT actual_cmplt_date
545: FROM gme_batch_header
546: WHERE batch_id IN (
547: SELECT DISTINCT batch_id
548: FROM gme_material_details
549: START WITH batch_id =

Line 583: IF NOT gme_batch_header_dbl.fetch_row (x_batch_row, x_batch_row) THEN

579:
580: FOR i IN 1 .. x_batch_tbl.COUNT LOOP
581: x_batch_row.batch_id := x_batch_tbl (i);
582:
583: IF NOT gme_batch_header_dbl.fetch_row (x_batch_row, x_batch_row) THEN
584: RETURN FALSE;
585: END IF;
586:
587: gme_trans_engine_util.load_rsrc_trans

Line 679: FROM gme_batch_header

675: =====================*/
676: CURSOR cur_get_routing (v_batch_id NUMBER)
677: IS
678: SELECT routing_id
679: FROM gme_batch_header
680: WHERE batch_id = v_batch_id;
681:
682: CURSOR cur_get_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
683: IS