DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on FND_FLEX_KEYVAL

Line 1528: IF FND_FLEX_KEYVAL.Validate_Segs

1524: l_temp := l_org_id_table.COUNT; --Bug:4211498
1525: -------------------------------------------------------------
1526: -- If Inventory Item ID found, then update in EBI.
1527: -------------------------------------------------------------
1528: IF FND_FLEX_KEYVAL.Validate_Segs
1529: ( operation => 'FIND_COMBINATION'
1530: , appl_short_name => 'INV'
1531: , key_flex_code => 'MSTK'
1532: , structure_number => 101

Line 1537: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;

1533: , concat_segments => l_item_number_table(i)
1534: , data_set => l_org_id_table(i)
1535: )
1536: THEN
1537: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
1538:
1539: Write_Debug('Inv Item ID : '||To_char(l_inventory_item_id));
1540:
1541: l_dyn_sql := ' UPDATE EGO_BULKLOAD_INTF ';

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

1549: EXECUTE IMMEDIATE l_dyn_sql USING l_item_number_table(i), p_resultfmt_usage_id;
1550: END IF;
1551:
1552:
1553: --l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
1554:
1555: -------------------------------------------------------------
1556: --Determining if Item Creation.
1557: -------------------------------------------------------------

Line 3575: IF FND_FLEX_KEYVAL.Validate_Segs

3571: -------------------------------------------------------------
3572: -- Invoke FND Key Flex API to fetch the Inventory Item ID.
3573: -- If Inventory Item ID found, then update in EBI.
3574: -------------------------------------------------------------
3575: IF FND_FLEX_KEYVAL.Validate_Segs
3576: ( operation => 'FIND_COMBINATION'
3577: , appl_short_name => 'INV'
3578: , key_flex_code => 'MSTK'
3579: , structure_number => 101

Line 3584: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;

3580: , concat_segments => l_item_number_table(i)
3581: , data_set => l_org_id_table(i)
3582: )
3583: THEN
3584: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
3585:
3586: Write_Debug('Inv Item ID : '||To_char(l_inventory_item_id));
3587:
3588: l_dyn_sql := ' UPDATE EGO_BULKLOAD_INTF ';

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

3594:
3595: Write_Debug(l_dyn_sql);
3596: EXECUTE IMMEDIATE l_dyn_sql USING l_item_number_table(i), p_resultfmt_usage_id;
3597:
3598: END IF; --IF FND_FLEX_KEYVAL..
3599:
3600: Write_Debug('G_CATALOG_GROUP_ID => '||G_CATALOG_GROUP_ID);
3601: -----------------------------------------------------------------
3602: -- Setting Category ID for Item Revision Flow.