APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on JMF_SUBCONTRACT_ORDERS

Line 1393: FROM JMF_SUBCONTRACT_ORDERS sco

1389: , pol.cancel_flag pol_cancel_flag
1390: , poh.cancel_flag poh_cancel_flag
1391: , poll.cancel_flag poll_cancel_flag
1392: , trunc( wdj.SCHEDULED_START_DATE) SCHEDULED_START_DATE
1393: FROM JMF_SUBCONTRACT_ORDERS sco
1394: , po_headers_all poh
1395: , po_lines_all pol
1396: , po_line_locations_all poll
1397: , wip_discrete_jobs wdj

Line 1782: UPDATE JMF_SUBCONTRACT_ORDERS

1778: , SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1779: END IF;
1780:
1781:
1782: UPDATE JMF_SUBCONTRACT_ORDERS
1783: SET interlock_status = 'T'
1784: WHERE SUBCONTRACT_PO_SHIPMENT_ID =
1785: SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID
1786: and ( SHIKYU_reconcile_rec.pol_cancel_flag = 'Y' OR

Line 2045: 'UPDATE JMF_SUBCONTRACT_ORDERS '

2041: IF (FND_LOG.LEVEL_PROCEDURE >=
2042: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2043: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2044: , 'JMFVRKSB: '||
2045: 'UPDATE JMF_SUBCONTRACT_ORDERS '
2046: , SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
2047: END IF;
2048:
2049:

Line 2050: UPDATE JMF_SUBCONTRACT_ORDERS

2046: , SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
2047: END IF;
2048:
2049:
2050: UPDATE JMF_SUBCONTRACT_ORDERS
2051: SET quantity = SHIKYU_reconcile_rec.quantity
2052: , need_by_date = SHIKYU_reconcile_rec.pol_need_by_date
2053: , last_update_date = sysdate
2054: , last_updated_by = FND_GLOBAL.user_id

Line 2069: 'AFTER UPDATE JMF_SUBCONTRACT_ORDERS '

2065: IF (FND_LOG.LEVEL_PROCEDURE >=
2066: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2068: , 'JMFVRKSB: '||
2069: 'AFTER UPDATE JMF_SUBCONTRACT_ORDERS '
2070: , SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
2071: END IF;
2072:
2073: