DBA Data[Home] [Help]

APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FEM_INTG_PL_PKG

Line 2698: -- 7. Call routine FEM_INTG_PL_PKG.Final_Process_Logging( ) to complete

2694: -- Call DELETE statement to delete existing hierarchy structure
2695: -- for the hierarchy object definition.
2696: -- Call INSERT statement to copy hierarchy structure from the
2697: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table
2698: -- 7. Call routine FEM_INTG_PL_PKG.Final_Process_Logging( ) to complete
2699: -- final process logging. Message name to print will be
2700: -- FEM_INTG_PROC_SUCCESS and the number of output rows will be the
2701: -- return row count from the hierarchy building routine
2702: -- 8. Call the Concurrent Program DHMHVFLW to flatten out every hierarchy

Line 2757: FEM_INTG_PL_PKG.Register_Process_Execution

2753: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
2754: p_msg_text => 'pv_hier_rule_obj_id:' || pv_hier_rule_obj_id
2755: ||' pv_hier_rule_obj_def_id:'|| pv_hier_rule_obj_def_id);
2756:
2757: FEM_INTG_PL_PKG.Register_Process_Execution
2758: (p_obj_id => pv_hier_rule_obj_id,
2759: p_obj_def_id => pv_hier_rule_obj_def_id,
2760: p_req_id => pv_req_id,
2761: p_user_id => pv_user_id,

Line 3309: -- Call routine FEM_INTG_PL_PKG.Final_Process_Logging( ) to complete

3305: ' pv_hier_rule_obj_def_id:' ||pv_hier_rule_obj_def_id ||
3306: ' pv_req_id:' ||pv_req_id ||
3307: ' pv_user_id:' ||pv_user_id ||
3308: ' pv_login_id:' || pv_login_id);
3309: -- Call routine FEM_INTG_PL_PKG.Final_Process_Logging( ) to complete
3310: -- final process logging. Message name to print will be
3311: -- FEM_INTG_PROC_SUCCESS and the number of output rows will be the
3312: -- return row count from the hierarchy building routine
3313: FEM_INTG_PL_PKG.Final_Process_Logging

Line 3313: FEM_INTG_PL_PKG.Final_Process_Logging

3309: -- Call routine FEM_INTG_PL_PKG.Final_Process_Logging( ) to complete
3310: -- final process logging. Message name to print will be
3311: -- FEM_INTG_PROC_SUCCESS and the number of output rows will be the
3312: -- return row count from the hierarchy building routine
3313: FEM_INTG_PL_PKG.Final_Process_Logging
3314: (p_obj_id => pv_hier_rule_obj_id,
3315: p_obj_def_id => pv_hier_rule_obj_def_id,
3316: p_req_id => pv_req_id,
3317: p_user_id => pv_user_id,

Line 3373: FEM_INTG_PL_PKG.Final_Process_Logging

3369: END IF;
3370: EXCEPTION
3371: WHEN FEM_INTG_fatal_err THEN
3372: ROLLBACk;
3373: FEM_INTG_PL_PKG.Final_Process_Logging
3374: (p_obj_id => pv_hier_rule_obj_id,
3375: p_obj_def_id => pv_hier_rule_obj_def_id,
3376: p_req_id => pv_req_id,
3377: p_user_id => pv_user_id,

Line 3411: FEM_INTG_PL_PKG.Final_Process_Logging

3407: (p_app_name => 'FEM',
3408: p_msg_name => 'FEM_GL_POST_215',
3409: p_token1 => 'ERR_MSG',
3410: p_value1 => SQLERRM);
3411: FEM_INTG_PL_PKG.Final_Process_Logging
3412: (p_obj_id => pv_hier_rule_obj_id,
3413: p_obj_def_id => pv_hier_rule_obj_def_id,
3414: p_req_id => pv_req_id,
3415: p_user_id => pv_user_id,