APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_VALUE_SETS_B

Line 705: SELECT FEM_VALUE_SETS_B_S.nextval

701: --
702: -- Create FEM Value Set
703: --
704:
705: SELECT FEM_VALUE_SETS_B_S.nextval
706: INTO pv_fem_vs_id
707: FROM DUAL;
708:
709: pv_progress := 'insert fem vs into aol mapping table';

Line 969: SELECT FEM_VALUE_SETS_B_S.nextval

965: -- Create FEM Value Set
966: --
967: pv_progress := 'insert newly created company vset into aol mapping table';
968:
969: SELECT FEM_VALUE_SETS_B_S.nextval
970: INTO pv_com_vs_id
971: FROM DUAL;
972:
973: INSERT INTO FEM_INTG_AOL_VALSET_MAP

Line 1070: SELECT FEM_VALUE_SETS_B_S.nextval

1066: IF pv_cc_vs_id = -1
1067: THEN
1068:
1069:
1070: SELECT FEM_VALUE_SETS_B_S.nextval
1071: INTO pv_cc_vs_id
1072: FROM DUAL;
1073:
1074: pv_progress := 'insert newly created cc vset into aol mapping table';

Line 1191: SELECT FEM_VALUE_SETS_B_S.nextval

1187: INTO pv_com_vs_id
1188: FROM fem_xdim_dimensions
1189: WHERE dimension_id = pv_com_dim_id;
1190: ELSE
1191: SELECT FEM_VALUE_SETS_B_S.nextval
1192: INTO pv_com_vs_id
1193: FROM DUAL;
1194: END IF;
1195:

Line 1272: SELECT FEM_VALUE_SETS_B_S.nextval

1268: INTO pv_cc_vs_id
1269: FROM fem_xdim_dimensions
1270: WHERE dimension_id = pv_cc_dim_id;
1271: ELSE
1272: SELECT FEM_VALUE_SETS_B_S.nextval
1273: INTO pv_cc_vs_id
1274: FROM DUAL;
1275: END IF;
1276:

Line 1899: FROM FEM_VALUE_SETS_B

1895: -- Check to see if the valueset already exists
1896: --
1897: SELECT count(*)
1898: INTO v_vs_count
1899: FROM FEM_VALUE_SETS_B
1900: WHERE value_set_id = p_fem_value_set_id;
1901:
1902: IF length(v_vs_name) > 140
1903: THEN

Line 2654: delete from fem_value_sets_b where value_set_id = l_value_set_id;

2650: (p_severity => pc_log_level_statement,
2651: p_module => pc_module_name || l_func_name ,
2652: p_msg_text => 'removing the rows for value sets');
2653:
2654: delete from fem_value_sets_b where value_set_id = l_value_set_id;
2655: delete from fem_value_sets_tl where value_set_id = l_value_set_id;
2656:
2657: IF (l_dim_id = 8) THEN
2658:

Line 2673: delete from fem_value_sets_b where value_set_id = comp_val_set_id;

2669: DELETE FROM FEM_COMPANIES_ATTR WHERE value_set_id = comp_val_set_id;
2670:
2671: -- deleting the company value sets
2672:
2673: delete from fem_value_sets_b where value_set_id = comp_val_set_id;
2674:
2675: END IF;
2676:
2677: -- retriveing cost center value set_id for the retrieved global_value_set_id

Line 2690: delete from fem_value_sets_b where value_set_id = cctr_val_set_id;

2686: DELETE FROM FEM_COST_CENTERS_TL WHERE value_set_id = cctr_val_set_id;
2687: DELETE FROM FEM_COST_CENTERS_ATTR WHERE value_set_id = cctr_val_set_id;
2688:
2689: -- deleting the cost center value sets
2690: delete from fem_value_sets_b where value_set_id = cctr_val_set_id;
2691:
2692: END IF;
2693:
2694: END IF;