APPS.GME_CLOSE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 39: p_batch_header_rec IN gme_batch_header%ROWTYPE

35: Do not remove invisible move order line records if they exist.
36: This will be done in GMF code at the time the batch is final posted.
37: ================================================================================*/
38: PROCEDURE close_batch (
39: p_batch_header_rec IN gme_batch_header%ROWTYPE
40: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
41: ,x_return_status OUT NOCOPY VARCHAR2)
42: IS
43: /* Miscellaneous */

Line 40: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

36: This will be done in GMF code at the time the batch is final posted.
37: ================================================================================*/
38: PROCEDURE close_batch (
39: p_batch_header_rec IN gme_batch_header%ROWTYPE
40: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
41: ,x_return_status OUT NOCOPY VARCHAR2)
42: IS
43: /* Miscellaneous */
44: l_api_name CONSTANT VARCHAR2 (30) := 'close_batch';

Line 53: l_batch_header gme_batch_header%ROWTYPE;

49: l_return_status VARCHAR2 (1);
50: l_ins_history gme_batch_history%ROWTYPE;
51: l_batch_step gme_batch_steps%ROWTYPE;
52: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
53: l_batch_header gme_batch_header%ROWTYPE;
54: l_in_batch_header gme_batch_header%ROWTYPE;
55: l_material_detail_ids gme_common_pvt.number_tab;
56: l_message_count NUMBER;
57: l_message_list VARCHAR2 (2000);

Line 54: l_in_batch_header gme_batch_header%ROWTYPE;

50: l_ins_history gme_batch_history%ROWTYPE;
51: l_batch_step gme_batch_steps%ROWTYPE;
52: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
53: l_batch_header gme_batch_header%ROWTYPE;
54: l_in_batch_header gme_batch_header%ROWTYPE;
55: l_material_detail_ids gme_common_pvt.number_tab;
56: l_message_count NUMBER;
57: l_message_list VARCHAR2 (2000);
58: l_step_count NUMBER;

Line 59: l_batch_header_rec gme_batch_header%ROWTYPE;

55: l_material_detail_ids gme_common_pvt.number_tab;
56: l_message_count NUMBER;
57: l_message_list VARCHAR2 (2000);
58: l_step_count NUMBER;
59: l_batch_header_rec gme_batch_header%ROWTYPE;
60:
61: /*siva FPbug#4684029*/
62: l_gmf_cost_alloc_calc NUMBER;
63: l_total_plan_output NUMBER;

Line 107: FROM gme_material_details d, gme_batch_header h

103: /* Get only the phantom ingredients which are not close already */
104: CURSOR cur_get_phant
105: IS
106: SELECT phantom_id
107: FROM gme_material_details d, gme_batch_header h
108: WHERE d.batch_id = x_batch_header_rec.batch_id
109: AND phantom_id IS NOT NULL
110: AND h.batch_id = d.phantom_id
111: AND h.batch_status <> 4;

Line 143: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

139: /* Set the success staus to success inititally*/
140: x_return_status := fnd_api.g_ret_sts_success;
141:
142: /* Initialize output batch header*/
143: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
144: ,x_batch_header_rec) ) THEN
145: RAISE batch_header_fetch_error;
146: END IF;
147:

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

296: /* Set up the fields in output structure. */
297: x_batch_header_rec.batch_status := 4;
298:
299: /* Update the batch step to the database */
300: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN
301: RAISE batch_header_upd_err;
302: END IF;
303:
304: /* Insert the event into the batch history table */

Line 326: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header

322: FOR l_rec IN cur_get_phant LOOP
323: l_batch_header.batch_id := l_rec.phantom_id;
324:
325: /* Initialize batch header*/
326: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header
327: ,l_in_batch_header) ) THEN
328: RAISE batch_header_fetch_error;
329: END IF;
330:

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

514:
515: Parameters
516: p_batch_header_rec Batch header row
517: ==================================================================================*/
518: FUNCTION create_history (p_batch_header_rec IN gme_batch_header%ROWTYPE)
519: RETURN BOOLEAN
520: IS
521: /* Local variable definitions */
522: l_return_status VARCHAR2 (1);

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

557: Parameters
558: p_batch_header_rec Batch header row
559: History
560: ==================================================================================*/
561: FUNCTION check_close_date (p_batch_header_rec IN gme_batch_header%ROWTYPE)
562: RETURN BOOLEAN
563: IS
564: CURSOR cur_batch_steps (v_batch_id NUMBER)
565: IS

Line 585: x_batch_row gme_batch_header%ROWTYPE;

581: START WITH batch_id = v_batch_id
582: CONNECT BY batch_id = PRIOR phantom_id;
583:
584: x_batch_tbl gme_common_pvt.number_tab;
585: x_batch_row gme_batch_header%ROWTYPE;
586: x_mat_cnt NUMBER;
587: x_rsrc_cnt NUMBER;
588: x_status VARCHAR2 (10);
589: x_date DATE;

Line 649: FROM gme_batch_header

645:
646: CURSOR cur_batch_cmplt_date (v_batch_id NUMBER)
647: IS
648: SELECT actual_cmplt_date
649: FROM gme_batch_header
650: WHERE batch_id IN (
651: SELECT DISTINCT batch_id
652: FROM gme_material_details
653: START WITH batch_id =

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

683:
684: FOR i IN 1 .. x_batch_tbl.COUNT LOOP
685: x_batch_row.batch_id := x_batch_tbl (i);
686:
687: IF NOT gme_batch_header_dbl.fetch_row (x_batch_row, x_batch_row) THEN
688: RETURN FALSE;
689: END IF;
690:
691: gme_trans_engine_util.load_rsrc_trans

Line 783: FROM gme_batch_header

779: =====================*/
780: CURSOR cur_get_routing (v_batch_id NUMBER)
781: IS
782: SELECT routing_id
783: FROM gme_batch_header
784: WHERE batch_id = v_batch_id;
785:
786: CURSOR cur_get_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
787: IS