APPS.EGO_AG_BULKLOAD_PVT dependencies on FND_FLEX_VALUE_SETS

Line 2607: FROM fnd_flex_value_sets ffvs

2603:
2604: /*Sets the value set id when the value set name is given*/
2605: UPDATE ego_attr_group_cols_intf eagci
2606: SET eagci.flex_value_set_id = (SELECT ffvs.flex_value_set_id
2607: FROM fnd_flex_value_sets ffvs
2608: WHERE ffvs.flex_value_set_name = eagci.flex_value_set_name)
2609: WHERE eagci.flex_value_set_id IS NULL
2610: AND eagci.flex_value_set_name IS NOT NULL
2611: AND eagci.process_status = G_PROCESS_RECORD

Line 2917: FROM fnd_flex_value_sets ffvs

2913:
2914: /*Sets the value set name when the value set id is given*/
2915: UPDATE ego_attr_group_cols_intf eagci
2916: SET eagci.flex_value_set_name = (SELECT ffvs.flex_value_set_name
2917: FROM fnd_flex_value_sets ffvs
2918: WHERE ffvs.flex_value_set_id = eagci.flex_value_set_id)
2919: WHERE eagci.flex_value_set_id IS NOT NULL
2920: AND eagci.process_status = G_PROCESS_RECORD
2921: AND ((G_SET_PROCESS_ID IS NULL)

Line 4263: FROM fnd_flex_value_sets ffvs

4259: AND P_attr_tbl(i).flex_value_set_name <> G_NULL_CHAR) THEN
4260: BEGIN
4261: SELECT ffvs.flex_value_set_id
4262: INTO P_attr_tbl(i).flex_value_set_id
4263: FROM fnd_flex_value_sets ffvs
4264: WHERE ffvs.flex_value_set_name = P_attr_tbl(i).flex_value_set_name;
4265: EXCEPTION
4266: WHEN no_data_found THEN
4267: x_return_status := G_RET_STS_ERROR;

Line 6067: FROM fnd_flex_value_sets ffvs

6063: AND P_attr_tbl(i).flex_value_set_name IS NULL) THEN
6064: BEGIN
6065: SELECT ffvs.flex_value_set_name
6066: INTO P_attr_tbl(i).flex_value_set_name
6067: FROM fnd_flex_value_sets ffvs
6068: WHERE ffvs.flex_value_set_id = P_attr_tbl(i).flex_value_set_id;
6069: EXCEPTION
6070: WHEN no_data_found THEN
6071: x_return_status := G_RET_STS_ERROR;