DBA Data[Home] [Help]

APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_ASL_ATTRIBUTES

Line 422: -- first, the value is fetched from po_asl_attributes table

418: x_price_update_tolerance_tbl.EXTEND(p_po_header_id_tbl.COUNT);
419:
420: l_key := PO_CORE_S.get_session_gt_nextval;
421:
422: -- first, the value is fetched from po_asl_attributes table
423: FORALL i IN INDICES OF p_index_tbl
424: INSERT INTO po_session_gt(key, num1, num2)
425: SELECT l_key,
426: p_index_tbl(i),

Line 428: FROM po_asl_attributes

424: INSERT INTO po_session_gt(key, num1, num2)
425: SELECT l_key,
426: p_index_tbl(i),
427: price_update_tolerance
428: FROM po_asl_attributes
429: WHERE (item_id = p_item_id_tbl(i) OR
430: category_id = p_category_id_tbl(i) OR
431: category_id IN
432: (SELECT MIC.category_id