eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_WEBADI_FACT_TAB_UTILS_PVT dependencies on DUAL

Line 84: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num =0),'Y','N','Y') into l_insert_m1 from dual;

80: -----------------------------------------------------------------------------------------------------------------------------------------------
81:
82: --------------- Entering values for the first matching dimension member. The factor_value will go with distribution dimension as that shall be the leaf dimension member.
83:
84: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num =0),'Y','N','Y') into l_insert_m1 from dual;
85:
86: if(l_insert_m1 = 'Y') then
87:
88: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

Line 88: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

84: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num =0),'Y','N','Y') into l_insert_m1 from dual;
85:
86: if(l_insert_m1 = 'Y') then
87:
88: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
89:
90: l_dimension_member := p_matching_dim1_mem;
91:
92: insert into FEM_FACTOR_TABLE_FCTRS(OBJECT_DEFINITION_ID,ROW_NUM,PARENT_ROW_NUM,LEVEL_NUM,DIM_MEMBER,FACTOR_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 107: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim2_mem and level_num = 1 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m2 from dual;

103: --------------- Entering values for the second matching dimension member. The factor_value will go with distribution dimension as that shall be the leaf dimension member.
104:
105: if(p_matching_dim2_mem is not NULL AND length(trim(p_matching_dim2_mem)) <> 0) then
106:
107: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim2_mem and level_num = 1 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m2 from dual;
108:
109: if(l_insert_m2 = 'Y') then
110:
111: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

Line 111: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

107: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim2_mem and level_num = 1 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m2 from dual;
108:
109: if(l_insert_m2 = 'Y') then
110:
111: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
112:
113: l_dimension_member := p_matching_dim2_mem;
114:
115: insert into FEM_FACTOR_TABLE_FCTRS(OBJECT_DEFINITION_ID,ROW_NUM,PARENT_ROW_NUM,LEVEL_NUM,DIM_MEMBER,FACTOR_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 130: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim3_mem and level_num =2 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m3 from dual;

126: --------------- Entering values for the third matching dimension member. The factor_value will go with distribution dimension as that shall be the leaf dimension member.
127:
128: if(p_matching_dim3_mem is not NULL AND length(trim(p_matching_dim3_mem)) <> 0) then
129:
130: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim3_mem and level_num =2 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m3 from dual;
131:
132: if(l_insert_m3 = 'Y') then
133:
134: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

Line 134: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

130: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim3_mem and level_num =2 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m3 from dual;
131:
132: if(l_insert_m3 = 'Y') then
133:
134: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
135:
136: l_dimension_member := p_matching_dim3_mem;
137:
138: insert into FEM_FACTOR_TABLE_FCTRS(OBJECT_DEFINITION_ID,ROW_NUM,PARENT_ROW_NUM,LEVEL_NUM,DIM_MEMBER,FACTOR_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 151: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

147: end if;
148:
149: --------------- Entering values for the distribution dimension. The factor_value will go with distribution dimension as that shall be the leaf dimension member.
150:
151: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
152:
153: l_dimension_member := p_distribution_dim_mem;
154:
155: insert into FEM_FACTOR_TABLE_FCTRS(OBJECT_DEFINITION_ID,ROW_NUM,PARENT_ROW_NUM,LEVEL_NUM,DIM_MEMBER,FACTOR_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 247: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num =0),'Y','N','Y') into l_insert_m1 from dual;

243: -----------------------------------------------------------------------------------------------------------------------------------------------
244:
245: --------------- Entering values for the first matching dimension member.
246:
247: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num =0),'Y','N','Y') into l_insert_m1 from dual;
248:
249: if(l_insert_m1 = 'Y') then
250:
251: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

Line 251: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

247: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num =0),'Y','N','Y') into l_insert_m1 from dual;
248:
249: if(l_insert_m1 = 'Y') then
250:
251: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
252:
253: l_dimension_member := p_matching_dim1_mem;
254:
255: if((p_matching_dim2_mem is null OR length(trim(p_matching_dim2_mem)) = 0) AND (p_matching_dim3_mem is null OR length(trim(p_matching_dim3_mem)) = 0)) then

Line 275: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim2_mem and level_num = 1 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m2 from dual;

271: --------------- Entering values for the second matching dimension member. The factor_value will go with distribution dimension as that shall be the leaf dimension member.
272:
273: if(p_matching_dim2_mem is not NULL AND length(trim(p_matching_dim2_mem)) <> 0) then
274:
275: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim2_mem and level_num = 1 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m2 from dual;
276:
277: if(l_insert_m2 = 'Y') then
278:
279: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

Line 279: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

275: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim2_mem and level_num = 1 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m2 from dual;
276:
277: if(l_insert_m2 = 'Y') then
278:
279: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
280:
281: l_dimension_member := p_matching_dim2_mem;
282:
283: if(p_matching_dim3_mem is null OR length(trim(p_matching_dim3_mem)) = 0) then

Line 304: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim3_mem and level_num =2 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m3 from dual;

300: --------------- Entering values for the third matching dimension member. The factor_value will go with distribution dimension as that shall be the leaf dimension member.
301:
302: if(p_matching_dim3_mem is not NULL AND length(trim(p_matching_dim3_mem)) <> 0) then
303:
304: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim3_mem and level_num =2 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m3 from dual;
305:
306: if(l_insert_m3 = 'Y') then
307:
308: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

Line 308: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

304: select decode((select 'Y' from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim3_mem and level_num =2 and parent_row_num = l_parent_row_num),'Y','N','Y') into l_insert_m3 from dual;
305:
306: if(l_insert_m3 = 'Y') then
307:
308: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
309:
310: l_dimension_member := p_matching_dim3_mem;
311:
312: insert into FEM_FACTOR_TABLE_FCTRS(OBJECT_DEFINITION_ID,ROW_NUM,PARENT_ROW_NUM,LEVEL_NUM,DIM_MEMBER,FACTOR_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 386: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;

382: -----------------------------------------------------------------------------------------------------------------------------------------------
383:
384: --------------- Entering values for the distribution dimension member.
385:
386: select FEM_FACTORS_ROW_NUM_SEQ.NEXTVAL into l_row_num from dual;
387:
388: l_dimension_member := p_distribution_dim_mem;
389:
390: insert into FEM_FACTOR_TABLE_FCTRS(OBJECT_DEFINITION_ID,ROW_NUM,PARENT_ROW_NUM,LEVEL_NUM,DIM_MEMBER,FACTOR_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 433: select decode((select 'Y' from fem_object_catalog_vl where object_name = p_rule_name),'Y','Y',NULL) into l_old_rule from dual;

429: select folder_id into l_folder_id from fem_folders_vl where folder_name = P_FOLDER_NAME;
430:
431: select lookup_code into l_object_access_code from fem_lookups where lookup_type = 'FEM_EDIT_PERMISSION_DSC' and meaning = p_object_access_code;
432:
433: select decode((select 'Y' from fem_object_catalog_vl where object_name = p_rule_name),'Y','Y',NULL) into l_old_rule from dual;
434:
435: IF(l_old_rule is NULL) THEN
436: select FEM_OBJECT_ID_SEQ.NEXTVAL into G_OBJECT_ID from dual;
437:

Line 436: select FEM_OBJECT_ID_SEQ.NEXTVAL into G_OBJECT_ID from dual;

432:
433: select decode((select 'Y' from fem_object_catalog_vl where object_name = p_rule_name),'Y','Y',NULL) into l_old_rule from dual;
434:
435: IF(l_old_rule is NULL) THEN
436: select FEM_OBJECT_ID_SEQ.NEXTVAL into G_OBJECT_ID from dual;
437:
438: INSERT INTO FEM_OBJECT_CATALOG_B(OBJECT_ID,OBJECT_TYPE_CODE,FOLDER_ID,LOCAL_VS_COMBO_ID,CREATION_DATE,CREATED_BY,OBJECT_ACCESS_CODE,OBJECT_ORIGIN_CODE,LAST_UPDATED_BY,
439: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
440: VALUES(G_OBJECT_ID,l_object_type_code,l_folder_id,l_local_vs_combo_id,sysdate,l_user_id,l_object_access_code,

Line 448: select FEM_OBJECT_DEFINITION_ID_SEQ.NEXTVAL into G_OBJECT_DEFINITION_ID from dual;

444: SELECT G_OBJECT_ID,P_RULE_NAME,LANGUAGE_CODE,'US',P_RULE_DESCRIPTION,l_user_id,sysdate,l_user_id,sysdate,l_update_login
445: FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B');
446:
447:
448: select FEM_OBJECT_DEFINITION_ID_SEQ.NEXTVAL into G_OBJECT_DEFINITION_ID from dual;
449:
450: INSERT INTO FEM_OBJECT_DEFINITION_B(OBJECT_DEFINITION_ID,OBJECT_ID,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,OBJECT_ORIGIN_CODE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,
451: LAST_UPDATE_DATE,APPROVAL_STATUS_CODE,OLD_APPROVED_COPY_FLAG,OLD_APPROVED_COPY_OBJ_DEF_ID,APPROVED_BY,APPROVAL_DATE,LAST_UPDATE_LOGIN,
452: OBJECT_VERSION_NUMBER)