APPS.CSP_PARTS_ORDER dependencies on MTL_SUPPLY

Line 550: -- update mtl_supply data for the requisition

546: cancel_reason = l_line_tbl(I).change_reason,
547: cancel_date = sysdate
548: where requisition_line_id = l_line_tbl(I).requisition_line_id;
549:
550: -- update mtl_supply data for the requisition
551: IF NOT po_supply.po_req_supply(
552: p_docid => null,
553: p_lineid => l_line_Tbl(I).requisition_line_id,
554: p_shipid => null,

Line 843: -- update mtl_supply data for the requisition

839: cancel_date = sysdate
840: where requisition_line_id = lx_oe_line_tbl(I).source_document_line_id;
841:
842:
843: -- update mtl_supply data for the requisition
844: /* IF NOT po_supply.po_req_supply(
845: p_docid => null,
846: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
847: p_shipid => null,

Line 855: UPDATE mtl_supply

851: p_receipt_date => NULL) THEN
852: */
853:
854: BEGIN
855: UPDATE mtl_supply
856: SET quantity = 0
857: , change_flag = 'Y'
858: WHERE supply_type_code = 'REQ'
859: AND req_line_id = lx_oe_line_Tbl(I).source_document_line_id;

Line 998: update mtl_supply

994:
995: -- Bug 13417397. Setting the change_flag back to NULL
996: FOR I in 1..lx_oe_line_tbl.count LOOP
997: BEGIN
998: update mtl_supply
999: set change_flag = NULL
1000: where supply_type_code = 'REQ'
1001: and req_line_id = lx_oe_line_Tbl(I).source_document_line_id;
1002: EXCEPTION

Line 3647: -- update mtl_supply data for the requisition

3643: update po_req_distributions
3644: set req_line_quantity = l_line_tbl(i).ordered_quantity
3645: where requisition_line_id = l_line_tbl(i).requisition_line_id;
3646:
3647: -- update mtl_supply data for the requisition
3648: IF NOT po_supply.po_req_supply(
3649: p_docid => null,
3650: p_lineid => l_line_Tbl(I).requisition_line_id,
3651: p_shipid => null,

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

3716:
3717: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3719: 'csp.plsql.csp_parts_order.process_order',
3720: 'Deleting record from mtl_supply...');
3721: end if;
3722:
3723: DELETE FROM mtl_supply ms1
3724: WHERE ms1.supply_source_id IN

Line 3723: DELETE FROM mtl_supply ms1

3719: 'csp.plsql.csp_parts_order.process_order',
3720: 'Deleting record from mtl_supply...');
3721: end if;
3722:
3723: DELETE FROM mtl_supply ms1
3724: WHERE ms1.supply_source_id IN
3725: (
3726: SELECT pl.requisition_line_id
3727: FROM po_requisition_lines pl

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

3735:
3736: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3738: 'csp.plsql.csp_parts_order.process_order',
3739: 'Inserting data into mtl_supply...');
3740: end if;
3741:
3742: INSERT INTO mtl_supply
3743: (supply_type_code,

Line 3742: INSERT INTO mtl_supply

3738: 'csp.plsql.csp_parts_order.process_order',
3739: 'Inserting data into mtl_supply...');
3740: end if;
3741:
3742: INSERT INTO mtl_supply
3743: (supply_type_code,
3744: supply_source_id,
3745: last_updated_by,
3746: last_update_date,

Line 3799: FROM mtl_supply ms

3795: AND prl.matching_basis <> 'AMOUNT'
3796: AND prl.line_location_id is null
3797: AND not exists
3798: (SELECT 'supply exists'
3799: FROM mtl_supply ms
3800: WHERE ms.supply_type_code = 'REQ'
3801: AND ms.supply_source_id = prl.requisition_line_id);
3802: EXCEPTION
3803: when no_data_found THEN

Line 3818: update mtl_supply

3814:
3815:
3816: END IF;
3817: BEGIN
3818: update mtl_supply
3819: set expected_delivery_date = nvl(l_header_rec.need_by_date, sysdate),
3820: need_by_date = nvl(l_header_rec.need_by_date, sysdate)
3821: where req_header_id = l_header_rec.requisition_header_id;
3822: EXCEPTION

Line 4204: -- update mtl_supply data for the requisition

4200: set req_line_quantity = lx_oe_line_tbl(I).ordered_quantity
4201: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
4202:
4203:
4204: -- update mtl_supply data for the requisition
4205: IF NOT po_supply.po_req_supply(
4206: p_docid => null,
4207: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
4208: p_shipid => null,

Line 4240: update mtl_supply

4236: END If;
4237:
4238: -- Bug 13417397. Setting the change_flag back to NULL
4239: BEGIN
4240: update mtl_supply
4241: set change_flag = NULL
4242: where req_header_id = l_header_rec.requisition_header_id;
4243: EXCEPTION
4244: WHEN no_data_found THEN