11: -- Constants for p_exec_status_code
12: g_exec_status_error_rerun CONSTANT VARCHAR2(30) := 'ERROR_RERUN';
13: g_exec_status_success CONSTANT VARCHAR2(30) := 'SUCCESS';
14:
15: --Constants for output table names being registered with fem_pl_pkg
16: -- API register_table method.
17: g_fem_customer_profit CONSTANT VARCHAR2(30) := 'FEM_CUSTOMER_PROFIT';
18: g_fem_customer_percentile_gt CONSTANT VARCHAR2(30) := 'FEM_CUSTOMER_PERCENTILE_GT';
19:
321: | Update_Num_Of_Output_Rows
322: |
323: | DESCRIPTION
324: | Updates the rows successfully processed by calling
325: | fem_pl_pkg.Update_Num_Of_Output_Rows in fem_pl_tables.
326: |
327: | SCOPE - PRIVATE
328: |
329: +============================================================================*/
350: ,p_module => G_BLOCK||'.'||l_api_name
351: ,p_msg_text => 'BEGIN');
352:
353: -- Set the number of output rows for the output table.
354: FEM_PL_PKG.Update_Num_Of_Output_Rows(
355: p_api_version => 1.0
356: ,p_commit => FND_API.G_TRUE
357: ,p_request_id => p_request_id
358: ,p_object_id => p_rule_obj_id
404: | Update_Obj_Exec_Step_Status
405: |
406: | DESCRIPTION
407: | Updates the status of the executuon of the object by calling
408: | fem_pl_pkg.Update_obj_exec_step_status in fem_pl_obj_steps.
409: |
410: | SCOPE - PRIVATE
411: |
412: +============================================================================*/
431: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
432: ,p_module => G_BLOCK||'.'||l_api_name
433: ,p_msg_text => 'BEGIN');
434:
435: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure
436: --to update step staus in fem_pl_obj_steps.
437: FEM_PL_PKG.Update_Obj_Exec_Step_Status(
438: p_api_version => 1.0
439: ,p_commit => FND_API.G_TRUE
433: ,p_msg_text => 'BEGIN');
434:
435: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure
436: --to update step staus in fem_pl_obj_steps.
437: FEM_PL_PKG.Update_Obj_Exec_Step_Status(
438: p_api_version => 1.0
439: ,p_commit => FND_API.G_TRUE
440: ,p_request_id => p_request_id
441: ,p_object_id => p_rule_obj_id
548: ,p_tbl_name => p_tbl_name
549: ,p_stmt_type => g_update );
550:
551: -----------------------------------------------------------------------
552: -- Call FEM_PL_PKG.update_num_of_input_rows();
553: -----------------------------------------------------------------------
554:
555: FEM_ENGINES_PKG.TECH_MESSAGE(
556: p_severity => g_log_level_1,
850: ,p_module => G_BLOCK||'.'||l_api_name
851: ,p_msg_text => 'BEGIN');
852:
853: -- Set the number of output rows for the output table.
854: FEM_PL_PKG.Update_Num_Of_Input_Rows(
855: p_api_version => 1.0
856: ,p_commit => FND_API.G_TRUE
857: ,p_request_id => p_request_id
858: ,p_object_id => p_rule_obj_id