DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_MOVE_ORDERS_PVT

Line 134: gme_move_orders_pvt.create_move_order_lines

130: p_batch_header_rec.update_inventory_ind = 'Y' THEN
131: l_material_detail_tbl (1) := x_material_detail_rec;
132:
133: -- add material line into invisible move order
134: gme_move_orders_pvt.create_move_order_lines
135: (p_move_order_header_id => p_batch_header_rec.move_order_header_id
136: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
137: ,p_material_details_tbl => l_material_detail_tbl
138: ,x_material_details_tbl => l_out_material_detail_tbl

Line 143: l_proc := 'gme_move_orders_pvt.create_move_order_lines';

139: ,x_trolin_tbl => l_trolin_tbl
140: ,x_return_status => x_return_status);
141:
142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
143: l_proc := 'gme_move_orders_pvt.create_move_order_lines';
144: RAISE error_processing;
145: END IF;
146:
147: x_material_detail_rec := l_out_material_detail_tbl(1);

Line 3517: gme_move_orders_pvt.update_move_order_lines

3513:
3514: END IF; -- IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3515:
3516: IF l_factor <> 1 THEN -- will only be for pending and WIP
3517: gme_move_orders_pvt.update_move_order_lines
3518: (p_batch_id => l_mtl_dtl_rec.batch_id
3519: ,p_material_detail_id => l_mtl_dtl_rec.material_detail_id
3520: ,p_new_qty => l_qty
3521: ,p_new_date => l_mtl_dtl_rec.material_requirement_date

Line 3526: l_proc := 'gme_move_orders_pvt.update_move_order_lines';

3522: ,p_invis_move_line_id => NULL
3523: ,x_return_status => x_return_status);
3524:
3525: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3526: l_proc := 'gme_move_orders_pvt.update_move_order_lines';
3527: RAISE error_processing;
3528: END IF;
3529: END IF;
3530:

Line 3533: gme_move_orders_pvt.delete_move_order_lines

3529: END IF;
3530:
3531: IF l_mtl_dtl_rec.phantom_type <> l_db_mtl_dtl_rec.phantom_type THEN
3532: IF l_mtl_dtl_rec.phantom_type IN (1,2) THEN -- phantom ing should not have invisible mo line
3533: gme_move_orders_pvt.delete_move_order_lines
3534: (p_organization_id => p_batch_header_rec.organization_id
3535: ,p_batch_id => p_batch_header_rec.batch_id
3536: ,p_material_detail_id => l_mtl_dtl_rec.material_detail_id
3537: ,p_invis_move_line_id => l_mtl_dtl_rec.move_order_line_id

Line 3541: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';

3537: ,p_invis_move_line_id => l_mtl_dtl_rec.move_order_line_id
3538: ,x_return_status => x_return_status);
3539:
3540: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3541: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';
3542: RAISE error_processing;
3543: END IF;
3544:
3545: l_mtl_dtl_rec.move_order_line_id := NULL;

Line 3551: gme_move_orders_pvt.create_move_order_lines

3547: ELSE -- phantom type is changed to 0 -> not a phantom, so the invisible mo line must be created
3548: l_material_detail_tbl (1) := l_mtl_dtl_rec;
3549:
3550: -- add material line into invisible move order
3551: gme_move_orders_pvt.create_move_order_lines
3552: (p_move_order_header_id => p_batch_header_rec.move_order_header_id
3553: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
3554: ,p_material_details_tbl => l_material_detail_tbl
3555: ,x_material_details_tbl => l_out_material_detail_tbl

Line 3560: l_proc := 'gme_move_orders_pvt.create_move_order_lines';

3556: ,x_trolin_tbl => l_trolin_tbl
3557: ,x_return_status => x_return_status);
3558:
3559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3560: l_proc := 'gme_move_orders_pvt.create_move_order_lines';
3561: RAISE error_processing;
3562: END IF;
3563:
3564: l_mtl_dtl_rec := l_out_material_detail_tbl(1);

Line 4380: IF gme_move_orders_pvt.pending_move_orders_exist

4376: gme_common_pvt.log_message ('GME_PENDING_RSRV_EXIST');
4377: RAISE val_error;
4378: END IF;
4379:
4380: IF gme_move_orders_pvt.pending_move_orders_exist
4381: (p_organization_id => p_material_detail_rec.organization_id
4382: ,p_batch_id => p_material_detail_rec.batch_id
4383: ,p_material_detail_id => p_material_detail_rec.material_detail_id) THEN
4384: gme_common_pvt.log_message ('GME_PENDING_MO_EXIST');

Line 4450: gme_move_orders_pvt.delete_move_order_lines

4446: l_proc := 'gme_pending_product_lots.delete_pending_product_lot';
4447: RAISE error_processing;
4448: END IF;
4449:
4450: gme_move_orders_pvt.delete_move_order_lines
4451: (p_organization_id => p_batch_header_rec.organization_id
4452: ,p_batch_id => p_batch_header_rec.batch_id
4453: ,p_material_detail_id => p_material_detail_rec.material_detail_id
4454: ,p_invis_move_line_id => p_material_detail_rec.move_order_line_id

Line 4458: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';

4454: ,p_invis_move_line_id => p_material_detail_rec.move_order_line_id
4455: ,x_return_status => x_return_status);
4456:
4457: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4458: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';
4459: RAISE error_processing;
4460: END IF;
4461:
4462: gme_reservations_pvt.delete_material_reservations (