APPS.GME_PHANTOM_PVT dependencies on GME_BATCH_HEADER

Line 48: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

44: 11-JAN-2007 Swapna K Bug#6738476 Added parameter,p_batch_header_rec
45: =============================================================================================*/
46: PROCEDURE create_phantom (
47: p_material_detail_rec IN gme_material_details%ROWTYPE
48: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
49: ,p_batch_no IN VARCHAR2 DEFAULT NULL
50: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
51: ,p_validity_rule_id IN NUMBER
52: ,p_use_workday_cal IN VARCHAR2

Line 78: l_batch_header gme_batch_header%ROWTYPE;

74: l_msg_list VARCHAR2 (2000);
75: l_plan_qty NUMBER;
76: l_return_status VARCHAR2 (1);
77: l_prod_mtl_dtl_id NUMBER;
78: l_batch_header gme_batch_header%ROWTYPE;
79: l_phant_batch gme_batch_header%ROWTYPE;
80: l_in_phant_batch gme_batch_header%ROWTYPE;
81: l_material_detail gme_material_details%ROWTYPE;
82: l_in_material_detail gme_material_details%ROWTYPE;

Line 79: l_phant_batch gme_batch_header%ROWTYPE;

75: l_plan_qty NUMBER;
76: l_return_status VARCHAR2 (1);
77: l_prod_mtl_dtl_id NUMBER;
78: l_batch_header gme_batch_header%ROWTYPE;
79: l_phant_batch gme_batch_header%ROWTYPE;
80: l_in_phant_batch gme_batch_header%ROWTYPE;
81: l_material_detail gme_material_details%ROWTYPE;
82: l_in_material_detail gme_material_details%ROWTYPE;
83: l_validity_tbl gmd_validity_rules.recipe_validity_tbl;

Line 80: l_in_phant_batch gme_batch_header%ROWTYPE;

76: l_return_status VARCHAR2 (1);
77: l_prod_mtl_dtl_id NUMBER;
78: l_batch_header gme_batch_header%ROWTYPE;
79: l_phant_batch gme_batch_header%ROWTYPE;
80: l_in_phant_batch gme_batch_header%ROWTYPE;
81: l_material_detail gme_material_details%ROWTYPE;
82: l_in_material_detail gme_material_details%ROWTYPE;
83: l_validity_tbl gmd_validity_rules.recipe_validity_tbl;
84:

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

116: END IF;
117:
118: l_batch_header.batch_id := x_material_detail_rec.batch_id;
119:
120: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
121: RAISE batch_header_fetch_error;
122: END IF;
123:
124: --Bug#6738476 This is just to assign the attirbute information of the flexfields

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

254:
255: l_phant_batch.parentline_id := p_material_detail_rec.material_detail_id;
256: l_phant_batch.last_update_date := gme_common_pvt.g_timestamp;
257:
258: IF NOT gme_batch_header_dbl.update_row (p_batch_header => l_phant_batch) THEN
259: RAISE batch_upd_error;
260: END IF;
261:
262: OPEN cur_get_phantom_prod (l_phant_batch.batch_id

Line 328: p_batch_header IN gme_batch_header%ROWTYPE

324: E - Error
325: U - Unexpected error
326: =============================================================================================*/
327: FUNCTION is_phantom (
328: p_batch_header IN gme_batch_header%ROWTYPE
329: ,x_return_status OUT NOCOPY VARCHAR2)
330: RETURN BOOLEAN
331: IS
332: l_batch_header gme_batch_header%ROWTYPE;

Line 332: l_batch_header gme_batch_header%ROWTYPE;

328: p_batch_header IN gme_batch_header%ROWTYPE
329: ,x_return_status OUT NOCOPY VARCHAR2)
330: RETURN BOOLEAN
331: IS
332: l_batch_header gme_batch_header%ROWTYPE;
333: error_fetch_header EXCEPTION;
334: l_api_name CONSTANT VARCHAR2 (30) := 'IS_PHANTOM';
335: BEGIN
336: IF g_debug <= gme_debug.g_log_procedure THEN

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

339: END IF;
340:
341: x_return_status := fnd_api.g_ret_sts_success;
342:
343: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => p_batch_header
344: ,x_batch_header => l_batch_header) THEN
345: RAISE error_fetch_header;
346: END IF;
347: