6161: --Locks:
6162: -- None.
6163: --Function:
6164: -- To get the IP_CATEGORY_IF from PO's category_id using the iProc view
6165: -- ICX_CAT_PURCHASING_CAT_MAP_V.
6166: --
6167: --Parameters:
6168: --IN:
6169: --p_po_category_id
6193: -- SQL Why : To insert the correct default value of IP_CATEGORY ID
6194: -- SQL Join: PO_CATEGORY_ID
6195: SELECT NVL(shopping_category_id, -2)
6196: INTO x_ip_category_id
6197: FROM ICX_CAT_PURCHASING_CAT_MAP_V
6198: WHERE po_category_id = p_po_category_id;
6199:
6200: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_ip_category_id='||x_ip_category_id); END IF;
6201: