DBA Data[Home] [Help]

APPS.PFT_PROFCAL_RGNCNT_PUB dependencies on FEM_PL_PKG

Line 15: --Constants for output table names being registered with fem_pl_pkg

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_region_info CONSTANT VARCHAR2(30) := 'FEM_REGION_INFO';
19:

Line 540: | fem_pl_pkg.Update_Num_Of_Output_Rows in fem_pl_tables.

536: | Update_Num_Of_Output_Rows
537: |
538: | DESCRIPTION
539: | Updates the rows successfully processed by calling
540: | fem_pl_pkg.Update_Num_Of_Output_Rows in fem_pl_tables.
541: |
542: | SCOPE - PRIVATE
543: |
544: +============================================================================*/

Line 569: FEM_PL_PKG.Update_Num_Of_Output_Rows(

565: ,p_module => G_BLOCK||'.'||l_api_name
566: ,p_msg_text => 'BEGIN');
567:
568: -- Set the number of output rows for the output table.
569: FEM_PL_PKG.Update_Num_Of_Output_Rows(
570: p_api_version => 1.0
571: ,p_commit => FND_API.G_TRUE
572: ,p_request_id => p_request_id
573: ,p_object_id => p_rule_obj_id

Line 623: | fem_pl_pkg.Update_obj_exec_step_status in fem_pl_obj_steps.

619: | Update_Obj_Exec_Step_Status
620: |
621: | DESCRIPTION
622: | Updates the status of the executuon of the object by calling
623: | fem_pl_pkg.Update_obj_exec_step_status in fem_pl_obj_steps.
624: |
625: | SCOPE - PRIVATE
626: |
627: +============================================================================*/

Line 650: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure

646: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
647: ,p_module => G_BLOCK||'.'||l_api_name
648: ,p_msg_text => 'BEGIN');
649:
650: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure
651: --to update step staus in fem_pl_obj_steps.
652: FEM_PL_PKG.Update_Obj_Exec_Step_Status(
653: p_api_version => 1.0
654: ,p_commit => FND_API.G_TRUE

Line 652: FEM_PL_PKG.Update_Obj_Exec_Step_Status(

648: ,p_msg_text => 'BEGIN');
649:
650: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure
651: --to update step staus in fem_pl_obj_steps.
652: FEM_PL_PKG.Update_Obj_Exec_Step_Status(
653: p_api_version => 1.0
654: ,p_commit => FND_API.G_TRUE
655: ,p_request_id => p_request_id
656: ,p_object_id => p_rule_obj_id

Line 828: -- Call FEM_PL_PKG.update_num_of_input_rows();

824: ,p_tbl_name => g_fem_region_info
825: ,p_stmt_type => g_insert );
826:
827: -----------------------------------------------------------------------
828: -- Call FEM_PL_PKG.update_num_of_input_rows();
829: -----------------------------------------------------------------------
830: FEM_ENGINES_PKG.TECH_MESSAGE(
831: p_severity => g_log_level_1,
832: p_module => G_BLOCK||'.'||l_api_name,

Line 1073: FEM_PL_PKG.Update_Num_Of_Input_Rows(

1069: ,p_module => G_BLOCK||'.'||l_api_name
1070: ,p_msg_text => 'BEGIN');
1071:
1072: -- Set the number of output rows for the output table.
1073: FEM_PL_PKG.Update_Num_Of_Input_Rows(
1074: p_api_version => 1.0
1075: ,p_commit => FND_API.G_TRUE
1076: ,p_request_id => p_request_id
1077: ,p_object_id => p_rule_obj_id