DBA Data[Home] [Help]

APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_PDOI_PARAMS

Line 442: PO_PDOI_PARAMS.g_sys.master_inv_org_id)

438: (SELECT MIC.category_id
439: FROM MTL_ITEM_CATEGORIES MIC
440: WHERE MIC.inventory_item_id = p_item_id_tbl(i)
441: AND MIC.organization_id =
442: PO_PDOI_PARAMS.g_sys.master_inv_org_id)
443: )
444: AND vendor_id = p_vendor_id_tbl(i)
445: AND using_organization_id IN (-1, PO_PDOI_PARAMS.g_sys.master_inv_org_id);
446:

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

441: AND MIC.organization_id =
442: PO_PDOI_PARAMS.g_sys.master_inv_org_id)
443: )
444: AND vendor_id = p_vendor_id_tbl(i)
445: AND using_organization_id IN (-1, PO_PDOI_PARAMS.g_sys.master_inv_org_id);
446:
447: d_position := 20;
448:
449: DELETE FROM po_session_gt

Line 506: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);

502: IF (x_price_update_tolerance_tbl(l_index) IS NULL) THEN
503: IF (PO_LOG.d_stmt) THEN
504: PO_LOG.stmt(d_module, d_position, 'index', l_index);
505: PO_LOG.stmt(d_module, d_position, 'price tolerance from profile',
506: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
507: END IF;
508:
509: x_price_update_tolerance_tbl(l_index) :=
510: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance;

Line 510: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance;

506: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
507: END IF;
508:
509: x_price_update_tolerance_tbl(l_index) :=
510: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance;
511: END IF;
512:
513: l_index := p_index_tbl.NEXT(l_index);
514: END LOOP;