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 FEM_FACTORS_ROW_NUM_SEQ

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 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 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 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 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 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,