APPS.GME_PHANTOM_PVT dependencies on GME_MATERIAL_DETAILS

Line 47: p_material_detail_rec IN gme_material_details%ROWTYPE

43: 07-Sep-2006 Namit S. Bug#5436643 Pass Revision Number during create batch
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

Line 50: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

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
53: ,p_contiguity_override IN VARCHAR2
54: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

Line 81: l_material_detail gme_material_details%ROWTYPE;

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:
85: CURSOR cur_step_matl_detail (v_material_detail_id NUMBER)

Line 82: l_in_material_detail gme_material_details%ROWTYPE;

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:
85: CURSOR cur_step_matl_detail (v_material_detail_id NUMBER)
86: IS

Line 99: FROM gme_material_details

95: v_batch_id NUMBER
96: ,v_inventory_item_id NUMBER)
97: IS
98: SELECT material_detail_id
99: FROM gme_material_details
100: WHERE batch_id = v_batch_id
101: AND inventory_item_id = v_inventory_item_id
102: AND line_type = gme_common_pvt.g_line_type_prod
103: ORDER BY line_no;

Line 113: IF NOT (gme_material_details_dbl.fetch_row (p_material_detail_rec

109:
110: /* Set the return status to success initially */
111: x_return_status := fnd_api.g_ret_sts_success;
112:
113: IF NOT (gme_material_details_dbl.fetch_row (p_material_detail_rec
114: ,x_material_detail_rec) ) THEN
115: RAISE material_detail_fetch_error;
116: END IF;
117:

Line 270: UPDATE gme_material_details

266: INTO l_prod_mtl_dtl_id;
267:
268: CLOSE cur_get_phantom_prod;
269:
270: UPDATE gme_material_details
271: SET phantom_line_id = p_material_detail_rec.material_detail_id
272: ,release_type = x_material_detail_rec.release_type
273: ,subinventory = x_material_detail_rec.subinventory
274: ,locator_id = x_material_detail_rec.locator_id

Line 283: UPDATE gme_material_details

279:
280: x_material_detail_rec.phantom_id := l_phant_batch.batch_id;
281: x_material_detail_rec.phantom_line_id := l_prod_mtl_dtl_id;
282:
283: UPDATE gme_material_details
284: SET phantom_line_id = l_prod_mtl_dtl_id
285: ,phantom_id = l_phant_batch.batch_id
286: ,last_update_date = gme_common_pvt.g_timestamp
287: ,last_updated_by = gme_common_pvt.g_user_ident

Line 403: FROM gme_batch_step_items i, gme_material_details d

399: v_batch_id NUMBER
400: ,v_batchstep_id NUMBER)
401: IS
402: SELECT d.phantom_id
403: FROM gme_batch_step_items i, gme_material_details d
404: WHERE d.batch_id = v_batch_id
405: AND i.material_detail_id = d.material_detail_id
406: AND batchstep_id = v_batchstep_id
407: AND ( d.release_type = gme_common_pvt.g_mtl_autobystep_release

Line 483: FROM gme_material_details d

479:
480: CURSOR cur_matl_phant_ids (v_batch_id NUMBER, v_release_type NUMBER)
481: IS
482: SELECT d.phantom_id
483: FROM gme_material_details d
484: WHERE d.batch_id = v_batch_id
485: AND d.release_type <= v_release_type
486: AND NVL (d.phantom_id, 0) > 0;
487: