APPS.GME_PHANTOM_PVT dependencies on GME_BATCH_HEADER

Line 60: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

56: No need to timestamp batch header record when updating the parentline_id as it was just created.
57: =============================================================================================*/
58: PROCEDURE create_phantom (
59: p_material_detail_rec IN gme_material_details%ROWTYPE
60: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
61: ,p_batch_no IN VARCHAR2 DEFAULT NULL
62: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
63: ,p_validity_rule_id IN NUMBER
64: ,p_use_workday_cal IN VARCHAR2

Line 90: l_batch_header gme_batch_header%ROWTYPE;

86: l_msg_list VARCHAR2 (2000);
87: l_plan_qty NUMBER;
88: l_return_status VARCHAR2 (1);
89: l_prod_mtl_dtl_id NUMBER;
90: l_batch_header gme_batch_header%ROWTYPE;
91: l_phant_batch gme_batch_header%ROWTYPE;
92: l_in_phant_batch gme_batch_header%ROWTYPE;
93: l_material_detail gme_material_details%ROWTYPE;
94: l_in_material_detail gme_material_details%ROWTYPE;

Line 91: l_phant_batch gme_batch_header%ROWTYPE;

87: l_plan_qty NUMBER;
88: l_return_status VARCHAR2 (1);
89: l_prod_mtl_dtl_id NUMBER;
90: l_batch_header gme_batch_header%ROWTYPE;
91: l_phant_batch gme_batch_header%ROWTYPE;
92: l_in_phant_batch gme_batch_header%ROWTYPE;
93: l_material_detail gme_material_details%ROWTYPE;
94: l_in_material_detail gme_material_details%ROWTYPE;
95: l_validity_tbl gmd_validity_rules.recipe_validity_tbl;

Line 92: l_in_phant_batch gme_batch_header%ROWTYPE;

88: l_return_status VARCHAR2 (1);
89: l_prod_mtl_dtl_id NUMBER;
90: l_batch_header gme_batch_header%ROWTYPE;
91: l_phant_batch gme_batch_header%ROWTYPE;
92: l_in_phant_batch gme_batch_header%ROWTYPE;
93: l_material_detail gme_material_details%ROWTYPE;
94: l_in_material_detail gme_material_details%ROWTYPE;
95: l_validity_tbl gmd_validity_rules.recipe_validity_tbl;
96:

Line 132: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN

128: END IF;
129:
130: l_batch_header.batch_id := x_material_detail_rec.batch_id;
131:
132: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
133: RAISE batch_header_fetch_error;
134: END IF;
135:
136: --Bug#6738476 This is just to assign the attirbute information of the flexfields

Line 272: IF NOT (gme_batch_header_dbl.fetch_row (l_phant_batch, l_phant_batch)) THEN

268: gme_debug.put_line ('Update batch_id '|| l_phant_batch.batch_id||' with parentline_id '||p_material_detail_rec.material_detail_id);
269: END IF;
270:
271: -- Bug 14681911 - Refresh the variable data before the next update.
272: IF NOT (gme_batch_header_dbl.fetch_row (l_phant_batch, l_phant_batch)) THEN
273: RAISE batch_header_fetch_error;
274: END IF;
275:
276: l_phant_batch.parentline_id := p_material_detail_rec.material_detail_id;

Line 283: IF NOT gme_batch_header_dbl.update_row (p_batch_header => l_phant_batch) THEN

279: -- This leads to problems if a customized call is made in the interim and timestamp is
280: -- changed. Also, the update_row function stamps it properly so this is redundant.
281: -- l_phant_batch.last_update_date := gme_common_pvt.g_timestamp;
282:
283: IF NOT gme_batch_header_dbl.update_row (p_batch_header => l_phant_batch) THEN
284: RAISE batch_upd_error;
285: END IF;
286:
287: OPEN cur_get_phantom_prod (l_phant_batch.batch_id

Line 363: p_batch_header IN gme_batch_header%ROWTYPE

359: E - Error
360: U - Unexpected error
361: =============================================================================================*/
362: FUNCTION is_phantom (
363: p_batch_header IN gme_batch_header%ROWTYPE
364: ,x_return_status OUT NOCOPY VARCHAR2)
365: RETURN BOOLEAN
366: IS
367: l_batch_header gme_batch_header%ROWTYPE;

Line 367: l_batch_header gme_batch_header%ROWTYPE;

363: p_batch_header IN gme_batch_header%ROWTYPE
364: ,x_return_status OUT NOCOPY VARCHAR2)
365: RETURN BOOLEAN
366: IS
367: l_batch_header gme_batch_header%ROWTYPE;
368: error_fetch_header EXCEPTION;
369: l_api_name CONSTANT VARCHAR2 (30) := 'IS_PHANTOM';
370: BEGIN
371: IF g_debug <= gme_debug.g_log_procedure THEN

Line 378: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => p_batch_header

374: END IF;
375:
376: x_return_status := fnd_api.g_ret_sts_success;
377:
378: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => p_batch_header
379: ,x_batch_header => l_batch_header) THEN
380: RAISE error_fetch_header;
381: END IF;
382: