eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on MTL_SUPPLY

Line 12183: = update mtl_supply

12179: = rollback to save point
12180: - for successful lines update the change request as accepted
12181: = adjust encumbrance
12182: = update po req tables
12183: = update mtl_supply
12184:
12185: */
12186: SAVEPOINT convertintosochange_sp;
12187: l_progress := '001';

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

12514: BEGIN
12515: /*
12516: Algorithm : Step 1: ADJUST the encumberance only if req encumbrance is ON
12517: Step 2: Update the req line and dist with the quantity changes
12518: Step 3: Update the mtl_supply by the PO API
12519: */
12520:
12521: -- Step 1: ADJUST the encumberance
12522: l_progress := '001';

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

12709: WHERE requisition_line_id = p_req_line_id ;
12710:
12711: l_progress := '014';
12712:
12713: -- Step 3: Update the mtl_supply by the PO API
12714: select quantity into l_mtl_quantity
12715: from mtl_supply
12716: where supply_type_code = 'REQ'
12717: and req_line_id = p_req_line_id;

Line 12715: from mtl_supply

12711: l_progress := '014';
12712:
12713: -- Step 3: Update the mtl_supply by the PO API
12714: select quantity into l_mtl_quantity
12715: from mtl_supply
12716: where supply_type_code = 'REQ'
12717: and req_line_id = p_req_line_id;
12718:
12719: l_mtl_quantity := l_mtl_quantity +p_delta_quantity;

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

12733: IF NOT l_bool_ret_sts THEN
12734: RAISE fnd_api.g_exc_unexpected_error;
12735: END IF;
12736: IF g_debug_stmt THEN
12737: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
12738: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');
12739: END IF;
12740: END IF;
12741: END IF; -- IF( p_req_line_id is not null)

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

12765:
12766: BEGIN
12767: /*
12768: Algorithm : Step 1: Update the req line and dist with the need by date changes
12769: Step 2: Update the mtl_supply by the PO API
12770:
12771: */
12772:
12773: IF (p_need_by_date IS NOT NULL) THEN

Line 12913: 4. delete mtl_supply

12909: - update cancel_flag to I
12910: - do cancel encumbrance
12911: - if return success, then update to Y else rollback and raise exception
12912: 3. if no, update cancel flag to Y
12913: 4. delete mtl_supply
12914: 5. update authorization status for req header*/
12915:
12916: l_is_req_encumbrance := PO_CORE_S.is_encumbrance_on(
12917: p_doc_type => PO_DOCUMENT_FUNDS_PVT.g_doc_type_REQUISITION

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

12955:
12956: IF g_debug_stmt THEN
12957: po_debug.debug_var(l_log_head,x_progress,'l_return_status', l_return_status );
12958: po_debug.debug_var(l_log_head,x_progress,'x_po_return_code ', l_po_return_code );
12959: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds after call');
12960: END IF;
12961:
12962: IF (l_return_status =FND_API.G_RET_STS_SUCCESS) then
12963:

Line 13030: -- delete the record in mtl_supply

13026: WHERE prl.requisition_header_id = l_document_id
13027: AND NVL(prl.cancel_flag,'N') = 'N'
13028: );
13029:
13030: -- delete the record in mtl_supply
13031:
13032: x_progress := '014';
13033:
13034: l_bool_ret_sts := po_supply.po_req_supply(

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

13044: IF NOT l_bool_ret_sts THEN
13045: RAISE fnd_api.g_exc_unexpected_error;
13046: END IF;
13047: IF g_debug_stmt THEN
13048: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');
13049: END IF;
13050:
13051:
13052:

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

13382: BEGIN
13383: /*
13384: Algorithm : Step 1: ADJUST the encumberance only if req encumbrance is ON
13385: Step 2: Update the req line and dist with the quantity changes
13386: Step 3: Update the mtl_supply by the PO API
13387: */
13388:
13389: -- Step 1: ADJUST the encumberance
13390: l_progress := '001';

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

13623: SET req_line_quantity = req_line_quantity + p_delta_prim_quantity
13624: WHERE requisition_line_id = p_req_line_id ;
13625:
13626: l_progress := '018';
13627: -- Step 3: Update the mtl_supply by the PO API
13628: select quantity into l_mtl_quantity
13629: from mtl_supply
13630: where supply_type_code = 'REQ'
13631: and req_line_id = p_req_line_id;

Line 13629: from mtl_supply

13625:
13626: l_progress := '018';
13627: -- Step 3: Update the mtl_supply by the PO API
13628: select quantity into l_mtl_quantity
13629: from mtl_supply
13630: where supply_type_code = 'REQ'
13631: and req_line_id = p_req_line_id;
13632:
13633: l_mtl_quantity := l_mtl_quantity +p_delta_prim_quantity;

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

13648: IF NOT l_bool_ret_sts THEN
13649: RAISE fnd_api.g_exc_unexpected_error;
13650: END IF;
13651: IF g_debug_stmt THEN
13652: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
13653: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');
13654: END IF;
13655: END IF;
13656: END IF; -- IF( p_req_line_id is not null)