APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on MTL_SUPPLY

Line 11755: = update mtl_supply

11751: = rollback to save point
11752: - for successful lines update the change request as accepted
11753: = adjust encumbrance
11754: = update po req tables
11755: = update mtl_supply
11756:
11757: */
11758: SAVEPOINT convertintosochange_sp;
11759: l_progress := '001';

Line 12079: Step 3: Update the mtl_supply by the PO API

12075: BEGIN
12076: /*
12077: Algorithm : Step 1: ADJUST the encumberance only if req encumbrance is ON
12078: Step 2: Update the req line and dist with the quantity changes
12079: Step 3: Update the mtl_supply by the PO API
12080: */
12081:
12082: -- Step 1: ADJUST the encumberance
12083: l_progress := '001';

Line 12273: -- Step 3: Update the mtl_supply by the PO API

12269: WHERE requisition_line_id = p_req_line_id ;
12270:
12271: l_progress := '014';
12272:
12273: -- Step 3: Update the mtl_supply by the PO API
12274: select quantity into l_mtl_quantity
12275: from mtl_supply
12276: where supply_type_code = 'REQ'
12277: and req_line_id = p_req_line_id;

Line 12275: from mtl_supply

12271: l_progress := '014';
12272:
12273: -- Step 3: Update the mtl_supply by the PO API
12274: select quantity into l_mtl_quantity
12275: from mtl_supply
12276: where supply_type_code = 'REQ'
12277: and req_line_id = p_req_line_id;
12278:
12279: l_mtl_quantity := l_mtl_quantity +p_delta_quantity;

Line 12297: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');

12293: IF NOT l_bool_ret_sts THEN
12294: RAISE fnd_api.g_exc_unexpected_error;
12295: END IF;
12296: IF g_debug_stmt THEN
12297: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
12298: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');
12299: END IF;
12300: END IF;
12301: END IF; -- IF( p_req_line_id is not null)

Line 12329: Step 2: Update the mtl_supply by the PO API

12325:
12326: BEGIN
12327: /*
12328: Algorithm : Step 1: Update the req line and dist with the need by date changes
12329: Step 2: Update the mtl_supply by the PO API
12330:
12331: */
12332:
12333: IF (p_need_by_date IS NOT NULL) THEN

Line 12414: -- delete the record in mtl_supply

12410: WHERE prl.requisition_header_id = l_document_id
12411: AND NVL(prl.cancel_flag,'N') = 'N'
12412: );
12413:
12414: -- delete the record in mtl_supply
12415:
12416: x_progress := '002';
12417:
12418: l_bool_ret_sts := po_supply.po_req_supply(

Line 12432: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');

12428: IF NOT l_bool_ret_sts THEN
12429: RAISE fnd_api.g_exc_unexpected_error;
12430: END IF;
12431: IF g_debug_stmt THEN
12432: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');
12433: END IF;
12434:
12435: -- cancel the encumbered funds
12436:

Line 12458: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');

12454:
12455: x_return_status := l_return_status;
12456: IF g_debug_stmt THEN
12457: po_debug.debug_var(l_log_head,x_progress,'l_return_status', l_return_status );
12458: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');
12459: END IF;
12460:
12461: END req_line_CANCEL;
12462: