APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_PDOI_PARAMS

Line 436: PO_PDOI_PARAMS.g_sys.master_inv_org_id)

432: (SELECT MIC.category_id
433: FROM MTL_ITEM_CATEGORIES MIC
434: WHERE MIC.inventory_item_id = p_item_id_tbl(i)
435: AND MIC.organization_id =
436: PO_PDOI_PARAMS.g_sys.master_inv_org_id)
437: )
438: AND vendor_id = p_vendor_id_tbl(i)
439: AND using_organization_id IN (-1, PO_PDOI_PARAMS.g_sys.master_inv_org_id);
440:

Line 439: AND using_organization_id IN (-1, PO_PDOI_PARAMS.g_sys.master_inv_org_id);

435: AND MIC.organization_id =
436: PO_PDOI_PARAMS.g_sys.master_inv_org_id)
437: )
438: AND vendor_id = p_vendor_id_tbl(i)
439: AND using_organization_id IN (-1, PO_PDOI_PARAMS.g_sys.master_inv_org_id);
440:
441: d_position := 20;
442:
443: DELETE FROM po_session_gt

Line 500: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);

496: IF (x_price_update_tolerance_tbl(l_index) IS NULL) THEN
497: IF (PO_LOG.d_stmt) THEN
498: PO_LOG.stmt(d_module, d_position, 'index', l_index);
499: PO_LOG.stmt(d_module, d_position, 'price tolerance from profile',
500: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
501: END IF;
502:
503: x_price_update_tolerance_tbl(l_index) :=
504: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance;

Line 504: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance;

500: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
501: END IF;
502:
503: x_price_update_tolerance_tbl(l_index) :=
504: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance;
505: END IF;
506:
507: l_index := p_index_tbl.NEXT(l_index);
508: END LOOP;