DBA Data[Home] [Help]

APPS.ENI_ITEMS_STAR_PKG dependencies on ENI_DENORM_HRCHY

Line 148: l_vbh_category_set := ENI_DENORM_HRCHY.get_category_set_id;

144: IF c%NOTFOUND THEN l_inv_category_set := null; END IF;
145: CLOSE c;
146:
147: -- BIS_COLLECTION_UTILITIES.log('Fetching VBH category set...');
148: l_vbh_category_set := ENI_DENORM_HRCHY.get_category_set_id;
149:
150: -- BIS_COLLECTION_UTILITIES.log('Fetching PO category set...');
151: OPEN get_po_catset;
152: FETCH get_po_catset INTO l_po_category_set;

Line 788: l_vbh_category_set := ENI_DENORM_HRCHY.get_category_set_id;

784: l_inv_category_set := null;
785: END IF;
786: CLOSE category_rec;
787:
788: l_vbh_category_set := ENI_DENORM_HRCHY.get_category_set_id;
789:
790: OPEN get_po_catset;
791: FETCH get_po_catset INTO l_po_category_set;
792: CLOSE get_po_catset;

Line 1325: l_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;

1321:
1322: exception
1323: when no_data_found then
1324: begin
1325: l_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
1326:
1327: select 'VBH_CATEGORY' into which_category_set
1328: from mtl_category_Sets_b
1329: where structure_id = p_structure_id

Line 1461: l_VBH_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;

1457: INTO l_INV_category_set_id
1458: FROM mtl_default_category_sets
1459: WHERE functional_area_id = 1;
1460:
1461: l_VBH_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
1462:
1463: OPEN get_po_catset;
1464: FETCH get_po_catset INTO l_po_category_set_id;
1465: CLOSE get_po_catset;

Line 1639: l_vbh_category_set := ENI_DENORM_HRCHY.get_category_set_id;

1635: end if;
1636:
1637: l_child_set_id := p_set_process_id + 1000000000000;
1638:
1639: l_vbh_category_set := ENI_DENORM_HRCHY.get_category_set_id;
1640: OPEN get_po_catset;
1641: FETCH get_po_catset INTO l_po_category_set;
1642: CLOSE get_po_catset;
1643:

Line 2071: l_vbh_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;

2067: X_RETURN_STATUS := 'S';
2068: return;
2069: end if;
2070:
2071: l_vbh_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
2072: OPEN get_po_catset;
2073: FETCH get_po_catset INTO l_po_category_set_id;
2074: CLOSE get_po_catset;
2075: l_user_id := FND_GLOBAL.USER_ID;