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_FACTOR_TABLE_FCTRS

Line 79: --- Entering dimension members and factor value in the fem_factor_table_fctrs.

75:
76: ----------------------------------------------------- PART 2 ENDS -----------------------------------------------------------------------------
77:
78: --------------------------------------------------------- PART 3 ------------------------------------------------------------------------------
79: --- Entering dimension members and factor value in the fem_factor_table_fctrs.
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:

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

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,
93: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
94: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,0,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
95:
96: else

Line 97: select row_num into l_row_num from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num = 0;

93: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
94: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,0,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
95:
96: else
97: select row_num into l_row_num from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num = 0;
98: end if;
99:
100: l_parent_row_num := l_row_num;
101: l_level_num := l_level_num + 1;

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

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,
116: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
117: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,0,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
118: else
119: select row_num into l_row_num 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;

Line 119: select row_num into l_row_num 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;

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,
116: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
117: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,0,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
118: else
119: select row_num into l_row_num 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;
120: end if;
121:
122: l_parent_row_num := l_row_num;
123: l_level_num := l_level_num + 1;

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

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,
139: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
140: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,0,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
141: else
142: select row_num into l_row_num 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;

Line 142: select row_num into l_row_num 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;

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,
139: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
140: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,0,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
141: else
142: select row_num into l_row_num 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;
143: end if;
144:
145: l_parent_row_num := l_row_num;
146: l_level_num := l_level_num + 1;

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

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,
156: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
157: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,p_amount,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
158:
159: --------------------------------------------------------- END PART 3 --------------------------------------------------------------------------

Line 242: --- Entering dimension members and factor value in the fem_factor_table_fctrs.

238:
239: ----------------------------------------------------- PART 2 ENDS -----------------------------------------------------------------------------
240:
241: --------------------------------------------------------- PART 3 ------------------------------------------------------------------------------
242: --- Entering dimension members and factor value in the fem_factor_table_fctrs.
243: -----------------------------------------------------------------------------------------------------------------------------------------------
244:
245: --------------- Entering values for the first matching dimension member.
246:

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

257: else
258: l_amount := 0;
259: end if;
260:
261: 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,
262: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
263: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,l_amount,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
264: else
265: select row_num into l_row_num from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num = 0;

Line 265: select row_num into l_row_num from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num = 0;

261: 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,
262: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
263: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,l_amount,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
264: else
265: select row_num into l_row_num from fem_factor_table_fctrs where object_definition_id = g_object_definition_id and dim_member = p_matching_dim1_mem and level_num = 0;
266: end if;
267:
268: l_parent_row_num := l_row_num;
269: l_level_num := l_level_num + 1;

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

285: else
286: l_amount := 0;
287: end if;
288:
289: 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,
290: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
291: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,l_amount,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
292: else
293: select row_num into l_row_num 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;

Line 293: select row_num into l_row_num 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;

289: 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,
290: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
291: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,l_amount,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
292: else
293: select row_num into l_row_num 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;
294: end if;
295:
296: l_parent_row_num := l_row_num;
297: l_level_num := l_level_num + 1;

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

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,
313: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
314: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,p_amount,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
315:
316: end if;

Line 381: --- Entering dimension members and factor value in the fem_factor_table_fctrs.

377:
378: ----------------------------------------------------- PART 2 ENDS -----------------------------------------------------------------------------
379:
380: --------------------------------------------------------- PART 3 ------------------------------------------------------------------------------
381: --- Entering dimension members and factor value in the fem_factor_table_fctrs.
382: -----------------------------------------------------------------------------------------------------------------------------------------------
383:
384: --------------- Entering values for the distribution dimension member.
385:

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

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,
391: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER)
392: values(G_OBJECT_DEFINITION_ID,l_row_num,l_parent_row_num,l_level_num,l_dimension_member,P_AMOUNT,sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
393:
394: