APPS.EGO_TA_BULKLOAD_PVT dependencies on FND_FLEX_VALUE_SETS

Line 643: FROM fnd_flex_value_sets ffvs

639: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT
640: WHERE value_set_id IS NOT NULL
641: AND NOT EXISTS (
642: SELECT 1
643: FROM fnd_flex_value_sets ffvs
644: WHERE ffvs.flex_value_set_id = ETAVT.value_set_id)
645: AND transaction_type IN (G_CREATE,G_UPDATE,G_SYNC)
646: AND ETAVT.transaction_id IS NOT NULL
647: AND ETAVT.process_status = G_PROCESS_RECORD

Line 659: FROM fnd_flex_value_sets

655: ETAVT.last_update_login = G_LOGIN_ID
656: WHERE ETAVT.value_set_id IS NOT NULL
657: AND NOT EXISTS (
658: SELECT 1
659: FROM fnd_flex_value_sets
660: WHERE flex_value_set_id = ETAVT.value_set_id)
661: AND transaction_type IN (G_CREATE,G_UPDATE,G_SYNC)
662: AND ETAVT.transaction_id IS NOT NULL
663: AND ETAVT.process_status = G_PROCESS_RECORD

Line 1695: FROM fnd_flex_value_sets

1691: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Value set name to value set id');
1692: /*Value set name to value set id conversion*/
1693: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1694: SET value_set_id = ( SELECT flex_value_set_id
1695: FROM fnd_flex_value_sets
1696: WHERE Upper(flex_value_set_name) = Upper(ETAVT.value_set_name)
1697: )
1698: WHERE ETAVT.value_set_name IS NOT NULL
1699: AND ETAVT.value_set_id IS NULL

Line 2059: FROM fnd_flex_value_sets

2055: AND p_ta_intf_tbl(i).value_set_id IS NULL
2056: AND p_ta_intf_tbl(i).value_set_name IS NOT NULL) THEN
2057: BEGIN
2058: SELECT flex_value_set_id INTO p_ta_intf_tbl(i).value_set_id
2059: FROM fnd_flex_value_sets
2060: WHERE Upper(flex_value_set_name) = Upper(p_ta_intf_tbl(i).value_set_name);
2061: EXCEPTION
2062: WHEN no_data_found THEN
2063: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value Set '

Line 2282: FROM fnd_flex_value_sets ffvs

2278: /* if given value_set_id not exists */
2279: IF (p_ta_intf_tbl(i).value_set_id IS NOT NULL) THEN
2280: BEGIN
2281: SELECT flex_value_set_id INTO l_id_exists
2282: FROM fnd_flex_value_sets ffvs
2283: WHERE ffvs.flex_value_set_id = p_ta_intf_tbl(i).value_set_id ;
2284:
2285: EXCEPTION
2286: WHEN no_data_found THEN