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_GL_POST_BAL_PKG dependencies on FEM_GL_POST_PROCESS_PKG

Line 167: fem_gl_post_process_pkg.get_proc_key_info(p_process_slice, v_completion_code);

163: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
164: p_msg_text => 'BEGIN FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
165:
166: IF p_load_type = 'OGL' THEN
167: fem_gl_post_process_pkg.get_proc_key_info(p_process_slice, v_completion_code);
168: IF v_completion_code = 2 THEN
169: x_completion_code := 2;
170: raise PROC_KEY_ERROR;
171: END IF;

Line 174: -- Retrive package variables from FEM_GL_POST_PROCESS_PKG and find

170: raise PROC_KEY_ERROR;
171: END IF;
172: END IF;
173: -----------------------------------------------------------------------
174: -- Retrive package variables from FEM_GL_POST_PROCESS_PKG and find
175: -- out some attribute information before we insert/merge data into
176: -- the FEM_BALANCES table
177: -----------------------------------------------------------------------
178: pv_req_id := FEM_GL_POST_PROCESS_PKG.pv_req_id;

Line 178: pv_req_id := FEM_GL_POST_PROCESS_PKG.pv_req_id;

174: -- Retrive package variables from FEM_GL_POST_PROCESS_PKG and find
175: -- out some attribute information before we insert/merge data into
176: -- the FEM_BALANCES table
177: -----------------------------------------------------------------------
178: pv_req_id := FEM_GL_POST_PROCESS_PKG.pv_req_id;
179: pv_rule_obj_id := FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id;
180: pv_proc_key_dim_num := FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num;
181: pv_ledger_id := FEM_GL_POST_PROCESS_PKG.pv_ledger_id;
182:

Line 179: pv_rule_obj_id := FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id;

175: -- out some attribute information before we insert/merge data into
176: -- the FEM_BALANCES table
177: -----------------------------------------------------------------------
178: pv_req_id := FEM_GL_POST_PROCESS_PKG.pv_req_id;
179: pv_rule_obj_id := FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id;
180: pv_proc_key_dim_num := FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num;
181: pv_ledger_id := FEM_GL_POST_PROCESS_PKG.pv_ledger_id;
182:
183: -----------------------------------------------------------------------

Line 180: pv_proc_key_dim_num := FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num;

176: -- the FEM_BALANCES table
177: -----------------------------------------------------------------------
178: pv_req_id := FEM_GL_POST_PROCESS_PKG.pv_req_id;
179: pv_rule_obj_id := FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id;
180: pv_proc_key_dim_num := FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num;
181: pv_ledger_id := FEM_GL_POST_PROCESS_PKG.pv_ledger_id;
182:
183: -----------------------------------------------------------------------
184: -- IF the executaion mode is Snapshot mode, we will insert data from

Line 181: pv_ledger_id := FEM_GL_POST_PROCESS_PKG.pv_ledger_id;

177: -----------------------------------------------------------------------
178: pv_req_id := FEM_GL_POST_PROCESS_PKG.pv_req_id;
179: pv_rule_obj_id := FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id;
180: pv_proc_key_dim_num := FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num;
181: pv_ledger_id := FEM_GL_POST_PROCESS_PKG.pv_ledger_id;
182:
183: -----------------------------------------------------------------------
184: -- IF the executaion mode is Snapshot mode, we will insert data from
185: -- the interim table to FEM_BALANCES.

Line 313: ' AND dl.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' ' ||

309: ' WHERE dl.ledger_id = bpi.ledger_id ' ||
310: ' AND dl.dataset_code = bpi.dataset_code ' ||
311: ' AND dl.cal_period_id = bpi.cal_period_id ' ||
312: ' AND dl.delta_run_id = bpi.delta_run_id ' ||
313: ' AND dl.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' ' ||
314: ' AND dl.loaded_flag = ''N'')';
315: END IF;
316:
317: v_sql_stmt := v_sql_stmt ||

Line 392: pv_col := FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name;

388: v_first_time := 'Y';
389: v_key_stmt := '';
390:
391: FOR v IN 1..pv_proc_key_dim_num LOOP
392: pv_col := FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name;
393:
394: IF (v_first_time = 'N') THEN
395: v_key_stmt := v_key_stmt || ' AND ';
396: END IF;

Line 447: ' AND dl.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' ' ||

443: ' WHERE dl.ledger_id = pi.ledger_id ' ||
444: ' AND dl.dataset_code = pi.dataset_code ' ||
445: ' AND dl.cal_period_id = pi.cal_period_id ' ||
446: ' AND dl.delta_run_id = pi.delta_run_id ' ||
447: ' AND dl.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' ' ||
448: ' AND dl.loaded_flag = ''N'') ' ||
449: 'GROUP BY param.request_id, pi.bal_post_type_code, ' ||
450: 'pi.dataset_code, pi.cal_period_id, pi.ledger_id, pi.currency_type_code, ' ||
451: 'pi.currency_code, pi.company_cost_center_org_id, pi.source_system_code, ' ||

Line 690: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_id,

686: x_ver_id => v_xat_bat_v_id,
687: x_err_code => v_error_code);
688:
689: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
690: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_id,
691: p_attr_label => 'GL_PERIOD_NUM',
692: x_attr_id => v_cp_period_num_attr_id,
693: x_ver_id => v_cp_period_num_v_id,
694: x_err_code => v_error_code);

Line 697: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_id,

693: x_ver_id => v_cp_period_num_v_id,
694: x_err_code => v_error_code);
695:
696: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
697: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_id,
698: p_attr_label => 'ACCOUNTING_YEAR',
699: x_attr_id => v_cp_year_attr_id,
700: x_ver_id => v_cp_year_v_id,
701: x_err_code => v_error_code);

Line 848: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := SQLERRM;

844: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
845:
846: WHEN OTHERS THEN
847:
848: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := SQLERRM;
849:
850: IF p_load_type = 'XGL' THEN
851: ROLLBACK;
852: END IF;