DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on JMF_SHIKYU_ALLOCATION_PVT

Line 92: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;

88: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_SUBCONTRACT_PO_SHIPMENT_ID
89: ;
90:
91: l_reduced_allocations_tbl
92: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;
93:
94: BEGIN
95:
96: -- The overall logic used in this api:

Line 199: --dbms_output.put_line(' Cazll JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations');

195:
196:
197: IF l_component_new_quantity > l_current_allocated_quantity
198: THEN
199: --dbms_output.put_line(' Cazll JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations');
200: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
202: , G_MODULE_PREFIX ||
203: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations SCO '

Line 203: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations SCO '

199: --dbms_output.put_line(' Cazll JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations');
200: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
202: , G_MODULE_PREFIX ||
203: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations SCO '
204: , p_SUBCONTRACT_PO_SHIPMENT_ID );
205: END IF;
206:
207: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations

Line 207: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations

203: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations SCO '
204: , p_SUBCONTRACT_PO_SHIPMENT_ID );
205: END IF;
206:
207: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations
208: ( p_api_version => 1.0
209: , p_init_msg_list => NULL
210: , x_return_status => l_return_status
211: , x_msg_count => l_msg_count

Line 227: --dbms_output.put_line(' Call JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations ');

223: -- l_return_status );
224:
225: ELSIF l_component_new_quantity < l_current_allocated_quantity
226: THEN
227: --dbms_output.put_line(' Call JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations ');
228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
229: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
230: , G_MODULE_PREFIX ||
231: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations '

Line 231: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations '

227: --dbms_output.put_line(' Call JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations ');
228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
229: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
230: , G_MODULE_PREFIX ||
231: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations '
232: , p_SUBCONTRACT_PO_SHIPMENT_ID );
233: END IF;
234:
235: JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations

Line 235: JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations

231: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations '
232: , p_SUBCONTRACT_PO_SHIPMENT_ID );
233: END IF;
234:
235: JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations
236: ( p_api_version => 1.0
237: , p_init_msg_list => NULL
238: , x_return_status => l_return_status
239: , x_msg_count => l_msg_count

Line 935: l_deleted_allocations_tbl JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;

931: FROM jmf_shikyu_components
932: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_SUBCONTRACT_PO_SHIPMENT_ID
933: order by SHIKYU_COMPONENT_ID ;
934:
935: l_deleted_allocations_tbl JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;
936: l_msg_data VARCHAR2(300);
937: l_msg_count NUMBER ;
938: l_final_ship_date DATE;
939: l_reschedule_date DATE;

Line 1130: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

1126: , 'Call Delete_Allocations for repl SO LINE ID '||
1127: C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);
1128: END IF;
1129:
1130: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1131: ( p_api_version => 1.0
1132: , p_init_msg_list => NULL
1133: , x_return_status => l_return_status
1134: , x_msg_count => l_msg_count

Line 1222: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations

1218: , G_MODULE_PREFIX || l_api_name
1219: , 'Going to call Create new allocations for comp' || l_SHIKYU_component_id );
1220: END IF;
1221:
1222: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations
1223: ( p_api_version => 1.0
1224: , p_init_msg_list => NULL
1225: , x_return_status => l_return_status
1226: , x_msg_count => l_msg_count

Line 1377: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;

1373:
1374: l_used_quantity NUMBER;
1375:
1376: l_deleted_allocations_tbl
1377: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;
1378: l_msg_data VARCHAR2(300);
1379: l_msg_count NUMBER ;
1380: l_return_status VARCHAR2(3);
1381: l_primary_quantity NUMBER ;

Line 1444: JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Partial_Shipments

1440: END IF;
1441: END IF;
1442:
1443: BEGIN
1444: JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Partial_Shipments
1445: ( p_api_version => 1.0
1446: , p_init_msg_list => 'Y'
1447: , x_return_status => l_return_status
1448: , x_msg_count => l_msg_count

Line 1493: JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Closed_Shipments

1489: , 'Calling Reconcile_Closed_Shipments');
1490: END IF;
1491: END IF;
1492:
1493: JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Closed_Shipments
1494: ( p_api_version => 1.0
1495: , p_init_msg_list => NULL
1496: , x_return_status => l_return_status
1497: , x_msg_count => l_msg_count

Line 1621: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations.');

1617: THEN
1618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1620: , G_MODULE_PREFIX || l_api_name
1621: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations.');
1622: END IF;
1623:
1624: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1625: ( p_api_version => 1.0

Line 1624: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

1620: , G_MODULE_PREFIX || l_api_name
1621: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations.');
1622: END IF;
1623:
1624: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1625: ( p_api_version => 1.0
1626: , p_init_msg_list => NULL
1627: , x_return_status => l_return_status
1628: , x_msg_count => l_msg_count

Line 1690: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations:' || C_shikyu_cancel_comp_rec.shikyu_component_id );

1686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1687: THEN
1688: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1689: , G_MODULE_PREFIX || l_api_name
1690: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations:' || C_shikyu_cancel_comp_rec.shikyu_component_id );
1691: END IF;
1692:
1693: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1694: ( p_api_version => 1.0

Line 1693: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

1689: , G_MODULE_PREFIX || l_api_name
1690: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations:' || C_shikyu_cancel_comp_rec.shikyu_component_id );
1691: END IF;
1692:
1693: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1694: ( p_api_version => 1.0
1695: , p_init_msg_list => NULL
1696: , x_return_status => l_return_status
1697: , x_msg_count => l_msg_count

Line 1939: JMF_SHIKYU_ALLOCATION_PVT.reconcile_rso_date_changes(x_return_status => l_return_status);

1935: , G_MODULE_PREFIX || l_api_name
1936: , '====Reconciling RSO date changes=======');
1937: END IF;
1938:
1939: JMF_SHIKYU_ALLOCATION_PVT.reconcile_rso_date_changes(x_return_status => l_return_status);
1940:
1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1942: THEN
1943: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL