APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on JMF_SUBCONTRACT_ORDERS

Line 1342: FROM JMF_SUBCONTRACT_ORDERS sco

1338: , pol.cancel_flag pol_cancel_flag
1339: , poh.cancel_flag poh_cancel_flag
1340: , poll.cancel_flag poll_cancel_flag
1341: , trunc( wdj.SCHEDULED_START_DATE) SCHEDULED_START_DATE
1342: FROM JMF_SUBCONTRACT_ORDERS sco
1343: , po_headers_all poh
1344: , po_lines_all pol
1345: , po_line_locations_all poll
1346: , wip_discrete_jobs wdj

Line 1715: UPDATE JMF_SUBCONTRACT_ORDERS

1711: , 'JMFVSKRB: UPDATE and COMMIT for SCO PO CANCEL flow ' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1712: END IF;
1713:
1714:
1715: UPDATE JMF_SUBCONTRACT_ORDERS
1716: SET interlock_status = 'T'
1717: WHERE SUBCONTRACT_PO_SHIPMENT_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID
1718: and ( SHIKYU_reconcile_rec.pol_cancel_flag = 'Y' OR
1719: SHIKYU_reconcile_rec.poh_cancel_flag = 'Y' OR

Line 1889: UPDATE JMF_SUBCONTRACT_ORDERS

1885:
1886:
1887: END IF; -- changes IF
1888:
1889: UPDATE JMF_SUBCONTRACT_ORDERS
1890: SET quantity = SHIKYU_reconcile_rec.quantity
1891: , need_by_date = SHIKYU_reconcile_rec.pol_need_by_date
1892: , last_update_date = sysdate
1893: , last_updated_by = FND_GLOBAL.user_id

Line 1904: , 'AFTER UPDATE JMF_SUBCONTRACT_ORDERS:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );

1900:
1901: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1903: , G_MODULE_PREFIX || l_api_name
1904: , 'AFTER UPDATE JMF_SUBCONTRACT_ORDERS:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1905: END IF;
1906:
1907: ELSE -- return status
1908: ROLLBACK;