DBA Data[Home] [Help]

APPS.GME_FPL_PVT dependencies on GME_BATCH_HEADER

Line 39: FROM gme_batch_header b, gmd_recipe_validity_rules a

35: CURSOR cur_get_info (v_batch_id NUMBER)
36: IS
37: SELECT b.recipe_validity_rule_id, a.recipe_id, b.organization_id
38: ,b.routing_id, b.formula_id
39: FROM gme_batch_header b, gmd_recipe_validity_rules a
40: WHERE b.batch_id = v_batch_id
41: AND b.recipe_validity_rule_id = a.recipe_validity_rule_id;
42:
43: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)

Line 211: p_batch_header_rec IN gme_batch_header%ROWTYPE

207:
208: /******* Procedure to apply fixed process loss **********/
209:
210: PROCEDURE apply_fixed_process_loss (
211: p_batch_header_rec IN gme_batch_header%ROWTYPE
212: ,p_material_tbl IN gme_common_pvt.material_details_tab
213: ,p_organization_id IN NUMBER DEFAULT NULL
214: ,p_creation_mode IN VARCHAR2
215: ,p_called_from IN NUMBER DEFAULT 1 /*1 = Create Batch, 2 = Batch details */

Line 216: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

212: ,p_material_tbl IN gme_common_pvt.material_details_tab
213: ,p_organization_id IN NUMBER DEFAULT NULL
214: ,p_creation_mode IN VARCHAR2
215: ,p_called_from IN NUMBER DEFAULT 1 /*1 = Create Batch, 2 = Batch details */
216: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
217: ,x_material_tbl OUT NOCOPY gme_common_pvt.material_details_tab
218: ,x_return_status OUT NOCOPY VARCHAR2
219: )
220: IS

Line 530: p_batch_header_rec IN gme_batch_header%ROWTYPE

526: APP_EXCEPTION.RAISE_EXCEPTION;
527: END;
528:
529: PROCEDURE FPL_batch_details (
530: p_batch_header_rec IN gme_batch_header%ROWTYPE
531: ,p_called_from IN NUMBER DEFAULT 1 /*1 = Create Batch, 2 = Batch details */
532: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
533: ,x_message_count OUT NOCOPY NUMBER
534: ,x_message_list OUT NOCOPY VARCHAR2

Line 544: x_batch_header_rec gme_batch_header%ROWTYPE;

540: FROM gme_material_details
541: WHERE batch_id = v_batch_id
542: ORDER BY line_no;
543: l_api_name CONSTANT VARCHAR2 (30) := 'FPL_batch_details';
544: x_batch_header_rec gme_batch_header%ROWTYPE;
545: l_material_tbl gme_common_pvt.material_details_tab;
546: x_material_tbl gme_common_pvt.material_details_tab;
547: i NUMBER := 0;
548: l_row_count NUMBER;

Line 605: IF NOT gme_batch_header_dbl.update_row

601: END IF;
602: END IF;
603: gme_common_pvt.set_timestamp;
604: -- Update the batch header
605: IF NOT gme_batch_header_dbl.update_row
606: (p_batch_header => x_batch_header_rec) THEN
607: RAISE error_update_batch;
608: END IF;
609: