DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on JMF_SHIKYU_ALLOCATION_PVT

Line 1: PACKAGE BODY JMF_SHIKYU_ALLOCATION_PVT AS

1: PACKAGE BODY JMF_SHIKYU_ALLOCATION_PVT AS
2: --$Header: JMFVSKAB.pls 120.29.12020000.3 2012/07/26 09:00:37 abhissri ship $
3: --+===========================================================================+
4: --| Copyright (c) 2005 Oracle Corporation |
5: --| Redwood Shores, California, USA |

Line 3683: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

3679: IF p_excess_qty >= l_allocable_primary_qty
3680: THEN
3681:
3682: -- Remove all allocations of the Replenishment SO Line
3683: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
3684: ( P_API_VERSION => 1.0
3685: , P_INIT_MSG_LIST => p_init_msg_list
3686: , X_RETURN_STATUS => x_return_status
3687: , X_MSG_COUNT => x_msg_count

Line 4029: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;

4025: l_primary_uom
4026: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
4027:
4028: l_reduced_allocations_tbl
4029: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;
4030:
4031: l_deleted_allocations_tbl
4032: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;
4033:

Line 4032: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;

4028: l_reduced_allocations_tbl
4029: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;
4030:
4031: l_deleted_allocations_tbl
4032: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;
4033:
4034: --Bugfix 14078692
4035: --1. There should be an outer join between jsa and jsr. If a RPO/RSO pair is not allocated to any
4036: --SPO, and the RSO is cancelled, this cursor would not pick up that RSO in absence of an outer join.

Line 4345: , 'JMFVSKAB :Invoke JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '

4341: THEN
4342: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4343: THEN
4344: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4345: , 'JMFVSKAB :Invoke JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '
4346: , C_SHIKYU_REPLENISHMENT_rec.subcontract_po_shipment_id);
4347: END IF;
4348:
4349: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

Line 4349: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

4345: , 'JMFVSKAB :Invoke JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '
4346: , C_SHIKYU_REPLENISHMENT_rec.subcontract_po_shipment_id);
4347: END IF;
4348:
4349: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
4350: ( p_api_version => 1.0
4351: , p_init_msg_list => NULL
4352: , x_return_status => l_return_status
4353: , x_msg_count => l_msg_count

Line 4450: , 'JMFVSKAB :1Cal JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations '

4446: THEN
4447: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4448: THEN
4449: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4450: , 'JMFVSKAB :1Cal JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations '
4451: , l_deleted_qty );
4452: END IF;
4453:
4454: Create_New_Allocations

Line 4543: JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations

4539: --This would be a scenario where you have a RPO/RSO pair which is not allocated to any
4540: --SPO. In case you split the line in the RSO, you need to just change the record in JSR.
4541: if C_SHIKYU_REPLENISHMENT_rec.subcontract_po_shipment_id is not null
4542: then
4543: JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations
4544: ( p_api_version => 1.0
4545: , p_init_msg_list => NULL
4546: , x_return_status => l_return_status
4547: , x_msg_count => l_msg_count

Line 4782: , 'JMFVSKAB :2after JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations '

4778:
4779: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4780: THEN
4781: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4782: , 'JMFVSKAB :2after JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations '
4783: , l_decreased_qty );
4784: END IF;
4785:
4786: END IF; -- l_decreased_qty

Line 5701: l_deleted_allocations_tbl JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;

5697: l_line_id OE_ORDER_LINES_ALL.line_id%type;
5698: l_cnt NUMBER;
5699: l_deleted_qty NUMBER;
5700: l_deletion_failed NUMBER := 0;
5701: l_deleted_allocations_tbl JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;
5702:
5703: cursor c_so_date_changes_cur is
5704: select jsr.replenishment_so_line_id line_id,
5705: jsr.schedule_ship_date jmf_schedule_ship_date,

Line 5811: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations(p_api_version => 1.0

5807:
5808: if l_final_ship_date > l_allocation_date
5809: then
5810: --shipment cannot reach the MP in time. So deallocate the SPO, RSO and component combination
5811: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations(p_api_version => 1.0
5812: , p_init_msg_list => NULL
5813: , x_return_status => l_return_status
5814: , x_msg_count => l_msg_count
5815: , x_msg_data => l_msg_data

Line 5878: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations(p_api_version => 1.0

5874: ':Deleted Quantity:' || l_deleted_qty);
5875: end if;
5876:
5877: if l_deleted_qty > 0 then
5878: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations(p_api_version => 1.0
5879: , p_init_msg_list => NULL
5880: , x_return_status => l_return_status
5881: , x_msg_count => l_msg_count
5882: , x_msg_data => l_msg_data

Line 5994: END JMF_SHIKYU_ALLOCATION_PVT;

5990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5991:
5992: end reconcile_rso_date_changes;
5993:
5994: END JMF_SHIKYU_ALLOCATION_PVT;