APPS.EGO_ITEM_BULKLOAD_PKG dependencies on FND_FLEX_KEYVAL

Line 1570: IF FND_FLEX_KEYVAL.Validate_Segs

1566: l_temp := l_org_id_table.COUNT; --Bug:4211498
1567: -------------------------------------------------------------
1568: -- If Inventory Item ID found, then update in EBI.
1569: -------------------------------------------------------------
1570: IF FND_FLEX_KEYVAL.Validate_Segs
1571: ( operation => 'FIND_COMBINATION'
1572: , appl_short_name => 'INV'
1573: , key_flex_code => 'MSTK'
1574: , structure_number => 101

Line 1579: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;

1575: , concat_segments => l_item_number_table(i)
1576: , data_set => l_org_id_table(i)
1577: )
1578: THEN
1579: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
1580:
1581: --Start bug:15930715
1582: Select ITEM_CATALOG_GROUP_ID into l_catalog_group_id
1583: FROM MTL_SYSTEM_ITEMS_B

Line 1612: --l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;

1608: end if;
1609: END IF;
1610:
1611:
1612: --l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
1613:
1614: -------------------------------------------------------------
1615: --Determining if Item Creation.
1616: -------------------------------------------------------------

Line 3660: IF FND_FLEX_KEYVAL.Validate_Segs

3656: -------------------------------------------------------------
3657: -- Invoke FND Key Flex API to fetch the Inventory Item ID.
3658: -- If Inventory Item ID found, then update in EBI.
3659: -------------------------------------------------------------
3660: IF FND_FLEX_KEYVAL.Validate_Segs
3661: ( operation => 'FIND_COMBINATION'
3662: , appl_short_name => 'INV'
3663: , key_flex_code => 'MSTK'
3664: , structure_number => 101

Line 3669: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;

3665: , concat_segments => l_item_number_table(i)
3666: , data_set => l_org_id_table(i)
3667: )
3668: THEN
3669: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
3670:
3671: Write_Debug('Inv Item ID : '||To_char(l_inventory_item_id));
3672:
3673: l_dyn_sql := ' UPDATE EGO_BULKLOAD_INTF ';

Line 3683: END IF; --IF FND_FLEX_KEYVAL..

3679:
3680: Write_Debug(l_dyn_sql);
3681: EXECUTE IMMEDIATE l_dyn_sql USING l_item_number_table(i), p_resultfmt_usage_id;
3682:
3683: END IF; --IF FND_FLEX_KEYVAL..
3684:
3685: Write_Debug('G_CATALOG_GROUP_ID => '||G_CATALOG_GROUP_ID);
3686: -----------------------------------------------------------------
3687: -- Setting Category ID for Item Revision Flow.