[Home] [Help]
1: PACKAGE BODY Fem_DataX_Loader_Pkg AS
2: -- $Header: fem_data_loader.plb 120.2 2005/08/23 12:13:04 appldev ship $
3:
4: ----------------------------------------------------
5: -- Dev Modes: 'D'=development 'P'=production
125: v_status NUMBER;
126: v_message VARCHAR2(4000);
127:
128: v_block CONSTANT VARCHAR2(80) :=
129: 'fem.plsql.fem_datax_loader_pkg.master';
130:
131: ---------------------
132: -- Execution Block --
133: ---------------------
212: p_rule_id => g_object_id,
213: p_eng_step => 'ALL',
214: p_data_table => g_data_t_table,
215: p_eng_sql => g_select_stmt,
216: p_eng_prg => 'FEM_DATAX_LOADER_PKG.Process_Rows',
217: p_condition => g_condition,
218: p_failed_req_id => null,
219: p_arg1 => g_data_table,
220: p_arg2 => g_object_id,
582: v_return_status VARCHAR2(1);
583: v_msg_count NUMBER;
584:
585: v_block CONSTANT VARCHAR2(80) :=
586: 'fem.plsql.fem_datax_loader_pkg.validation';
587:
588: ----------------------
589: -- Cursor Variables --
590: ----------------------
1331: v_return_status VARCHAR2(1);
1332: v_prev_req_id NUMBER;
1333:
1334: v_block CONSTANT VARCHAR2(80) :=
1335: 'fem.plsql.fem_datax_loader_pkg.registration';
1336:
1337: BEGIN
1338:
1339: FEM_ENGINES_PKG.TECH_MESSAGE
1620: v_user_dim10_dc_col VARCHAR2(30);
1621: v_user_dim10_b_tab VARCHAR2(30);
1622:
1623: v_block CONSTANT VARCHAR2(80) :=
1624: 'fem.plsql.fem_datax_loader_pkg.pre_process';
1625:
1626: BEGIN
1627:
1628: FEM_ENGINES_PKG.TECH_MESSAGE
2300: BEGIN
2301:
2302: -- DBMS_SESSION.SET_SQL_TRACE (sql_trace => TRUE);
2303:
2304: v_block := 'fem.plsql.fem_datax_loader_pkg.process_rows'||
2305: '{p'||p_proc_num||'}';
2306:
2307: FEM_ENGINES_PKG.TECH_MESSAGE
2308: (p_severity => c_log_level_3,
3271: v_msg_data VARCHAR2(4196);
3272: v_return_status VARCHAR2(1);
3273:
3274: v_block CONSTANT VARCHAR2(80) :=
3275: 'fem.plsql.fem_datax_loader_pkg.post_process_rows';
3276:
3277: BEGIN
3278:
3279: FEM_ENGINES_PKG.TECH_MESSAGE
3479: v_msg_out NUMBER;
3480: v_message VARCHAR2(4196);
3481:
3482: v_block CONSTANT VARCHAR2(80) :=
3483: 'fem.plsql.fem_datax_loader_pkg.get_put_messages';
3484:
3485: BEGIN
3486:
3487: FEM_ENGINES_PKG.TECH_MESSAGE
3530: END Get_Put_Messages;
3531:
3532: /***************************************************************************/
3533:
3534: END Fem_DataX_Loader_Pkg;