APPS.CSP_PARTS_ORDER dependencies on MTL_SUPPLY

Line 527: -- update mtl_supply data for the requisition

523: cancel_reason = l_line_tbl(I).change_reason,
524: cancel_date = sysdate
525: where requisition_line_id = l_line_tbl(I).requisition_line_id;
526:
527: -- update mtl_supply data for the requisition
528: IF NOT po_supply.po_req_supply(
529: p_docid => null,
530: p_lineid => l_line_Tbl(I).requisition_line_id,
531: p_shipid => null,

Line 764: -- update mtl_supply data for the requisition

760: cancel_date = sysdate
761: where requisition_line_id = lx_oe_line_tbl(I).source_document_line_id;
762:
763:
764: -- update mtl_supply data for the requisition
765: /* IF NOT po_supply.po_req_supply(
766: p_docid => null,
767: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
768: p_shipid => null,

Line 776: UPDATE mtl_supply

772: p_receipt_date => NULL) THEN
773: */
774:
775: BEGIN
776: UPDATE mtl_supply
777: SET quantity = 0
778: , change_flag = 'Y'
779: WHERE supply_type_code = 'REQ'
780: AND req_line_id = lx_oe_line_Tbl(I).source_document_line_id;

Line 2382: -- update mtl_supply data for the requisition

2378: update po_req_distributions
2379: set req_line_quantity = l_line_tbl(i).ordered_quantity
2380: where requisition_line_id = l_line_tbl(i).requisition_line_id;
2381:
2382: -- update mtl_supply data for the requisition
2383: IF NOT po_supply.po_req_supply(
2384: p_docid => null,
2385: p_lineid => l_line_Tbl(I).requisition_line_id,
2386: p_shipid => null,

Line 2455: 'Deleting record from mtl_supply...');

2451:
2452: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2454: 'csp.plsql.csp_parts_order.process_order',
2455: 'Deleting record from mtl_supply...');
2456: end if;
2457:
2458: DELETE FROM mtl_supply ms1
2459: WHERE ms1.supply_source_id IN

Line 2458: DELETE FROM mtl_supply ms1

2454: 'csp.plsql.csp_parts_order.process_order',
2455: 'Deleting record from mtl_supply...');
2456: end if;
2457:
2458: DELETE FROM mtl_supply ms1
2459: WHERE ms1.supply_source_id IN
2460: (
2461: SELECT pl.requisition_line_id
2462: FROM po_requisition_lines pl

Line 2474: 'Inserting data into mtl_supply...');

2470:
2471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2473: 'csp.plsql.csp_parts_order.process_order',
2474: 'Inserting data into mtl_supply...');
2475: end if;
2476:
2477: INSERT INTO mtl_supply
2478: (supply_type_code,

Line 2477: INSERT INTO mtl_supply

2473: 'csp.plsql.csp_parts_order.process_order',
2474: 'Inserting data into mtl_supply...');
2475: end if;
2476:
2477: INSERT INTO mtl_supply
2478: (supply_type_code,
2479: supply_source_id,
2480: last_updated_by,
2481: last_update_date,

Line 2534: FROM mtl_supply ms

2530: AND prl.matching_basis <> 'AMOUNT'
2531: AND prl.line_location_id is null
2532: AND not exists
2533: (SELECT 'supply exists'
2534: FROM mtl_supply ms
2535: WHERE ms.supply_type_code = 'REQ'
2536: AND ms.supply_source_id = prl.requisition_line_id);
2537: EXCEPTION
2538: when no_data_found THEN

Line 2553: update mtl_supply

2549:
2550:
2551: END IF;
2552: BEGIN
2553: update mtl_supply
2554: set expected_delivery_date = nvl(l_header_rec.need_by_date, sysdate),
2555: need_by_date = nvl(l_header_rec.need_by_date, sysdate)
2556: where req_header_id = l_header_rec.requisition_header_id;
2557: EXCEPTION

Line 2740: -- update mtl_supply data for the requisition

2736: set req_line_quantity = lx_oe_line_tbl(I).ordered_quantity
2737: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
2738:
2739:
2740: -- update mtl_supply data for the requisition
2741: IF NOT po_supply.po_req_supply(
2742: p_docid => null,
2743: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
2744: p_shipid => null,