DBA Data[Home] [Help]

APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_VALUE_SETS_B_S

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: