APPS.INV_MINMAX_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 1310: -- po_requisitions_interface_all

1306: RETURN(l_total);
1307: END IF;
1308:
1309: --
1310: -- po_requisitions_interface_all
1311: --
1312: -- Bug: 2320752
1313: -- Do not include records in error status
1314: -- kkoothan Bug Fix 2891818

Line 1320: of quantities in po_requisitions_interface_all if uom_code is different than

1316: -- so that the interface records with NULL value for process_flag
1317: -- are considered as Interface Supply.
1318: --
1319: /* Bug 3894347 -- Added the following section of code to consider conversion
1320: of quantities in po_requisitions_interface_all if uom_code is different than
1321: primary uom code */
1322:
1323: SELECT uom_code
1324: INTO l_puom

Line 1335: FROM po_requisitions_interface_all

1331: l_puom,quantity,
1332: INV_CONVERT.INV_UM_CONVERT(p_item_id,null,quantity,uom_code,l_puom,null,null)
1333: )),0)
1334: INTO l_qty
1335: FROM po_requisitions_interface_all
1336: WHERE destination_organization_id = p_org_id
1337: AND item_id = p_item_id
1338: AND p_include_po = 1
1339: AND (p_level = 1 or destination_subinventory = p_subinv)

Line 1364: print_debug('Supply from po_requisitions_interface_all: ' || to_char(l_qty)

1360: 1,sub2.availability_type,1)) OR
1361: p_level = 2);
1362:
1363: IF G_TRACE_ON = 1 THEN
1364: print_debug('Supply from po_requisitions_interface_all: ' || to_char(l_qty)
1365: , 'get_supply_qty'
1366: , 9);
1367: END IF;
1368: l_total := l_total + NVL(l_qty,0);

Line 4024: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);

4020: END IF;
4021: /* End of Changes for Bug 3894347 */
4022:
4023: IF G_TRACE_ON = 1 THEN
4024: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);
4025: END IF;
4026:
4027: INSERT INTO po_requisitions_interface_all(
4028: LAST_UPDATE_DATE,

Line 4027: INSERT INTO po_requisitions_interface_all(

4023: IF G_TRACE_ON = 1 THEN
4024: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);
4025: END IF;
4026:
4027: INSERT INTO po_requisitions_interface_all(
4028: LAST_UPDATE_DATE,
4029: LAST_UPDATED_BY,
4030: ITEM_DESCRIPTION,
4031: CREATION_DATE,