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: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;

931: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_SUBCONTRACT_PO_SHIPMENT_ID
932: order by SHIKYU_COMPONENT_ID ;
933:
934: l_deleted_allocations_tbl
935: 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 1145: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

1141: C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID
1142: , C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);
1143: END IF;
1144:
1145: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1146: ( p_api_version => 1.0
1147: , p_init_msg_list => NULL
1148: , x_return_status => l_return_status
1149: , x_msg_count => l_msg_count

Line 1268: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations

1264: 'Going to call Create new allocations for comp'
1265: , l_SHIKYU_component_id );
1266: END IF;
1267:
1268: JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations
1269: ( p_api_version => 1.0
1270: , p_init_msg_list => NULL
1271: , x_return_status => l_return_status
1272: , x_msg_count => l_msg_count

Line 1428: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;

1424:
1425: l_used_quantity NUMBER;
1426:
1427: l_deleted_allocations_tbl
1428: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;
1429: l_msg_data VARCHAR2(300);
1430: l_msg_count NUMBER ;
1431: l_return_status VARCHAR2(3);
1432: l_primary_quantity NUMBER ;

Line 1494: 'calling JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Partial_Shipments'

1490: THEN
1491: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1492: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1493: , 'JMFVSKRB' ||
1494: 'calling JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Partial_Shipments'
1495: , 'rajesh');
1496: END IF;
1497: END IF;
1498:

Line 1500: JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Partial_Shipments

1496: END IF;
1497: END IF;
1498:
1499: BEGIN
1500: JMF_SHIKYU_ALLOCATION_PVT.Reconcile_Partial_Shipments
1501: ( p_api_version => 1.0
1502: , p_init_msg_list => 'Y'
1503: , x_return_status => l_return_status
1504: , x_msg_count => l_msg_count

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

1669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1670: , 'JMFVSKRB: ' ||
1671: ' SHIKYU_reconcile_rec.scheduled_start_date => '||
1672: SHIKYU_reconcile_rec.scheduled_start_date
1673: ,' Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations ');
1674: END IF;
1675:
1676: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1677: ( p_api_version => 1.0

Line 1676: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

1672: SHIKYU_reconcile_rec.scheduled_start_date
1673: ,' Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations ');
1674: END IF;
1675:
1676: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1677: ( p_api_version => 1.0
1678: , p_init_msg_list => NULL
1679: , x_return_status => l_return_status
1680: , x_msg_count => l_msg_count

Line 1693: 'out JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '

1689:
1690: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1692: , 'JMFVSKRB ' ||
1693: 'out JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '
1694: ,' l_return_status => '|| l_return_status );
1695: END IF;
1696:
1697: ELSE

Line 1752: ' Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '

1748: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1749: THEN
1750: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1751: , 'JMFVSKRB: ' ||
1752: ' Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '
1753: ,C_shikyu_cancel_comp_rec.shikyu_component_id );
1754: END IF;
1755:
1756: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

Line 1756: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations

1752: ' Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations '
1753: ,C_shikyu_cancel_comp_rec.shikyu_component_id );
1754: END IF;
1755:
1756: JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations
1757: ( p_api_version => 1.0
1758: , p_init_msg_list => NULL
1759: , x_return_status => l_return_status
1760: , x_msg_count => l_msg_count