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:
19: --constant for sql_stmt_type
590:
591: l_last_row := l_created_by_object_id_tbl.COUNT;
592:
593: FOR i IN 1 .. l_last_row LOOP
594: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
595: -- the specified chain.
596: FEM_PL_PKG.Register_Chain (
597: p_api_version => 1.0
598: ,p_commit => FND_API.G_FALSE
592:
593: FOR i IN 1 .. l_last_row LOOP
594: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
595: -- the specified chain.
596: FEM_PL_PKG.Register_Chain (
597: p_api_version => 1.0
598: ,p_commit => FND_API.G_FALSE
599: ,p_request_id => l_request_id
600: ,p_object_id => p_rule_obj_id
646:
647: l_last_row := l_created_by_object_id_tbl.COUNT;
648:
649: FOR i IN 1 .. l_last_row LOOP
650: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
651: -- the specified chain.
652: FEM_PL_PKG.Register_Chain (
653: p_api_version => 1.0
654: ,p_commit => FND_API.G_FALSE
648:
649: FOR i IN 1 .. l_last_row LOOP
650: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
651: -- the specified chain.
652: FEM_PL_PKG.Register_Chain (
653: p_api_version => 1.0
654: ,p_commit => FND_API.G_FALSE
655: ,p_request_id => l_request_id
656: ,p_object_id => p_rule_obj_id
1167: | Update_Num_Of_Output_Rows
1168: |
1169: | DESCRIPTION
1170: | Updates the rows successfully processed by calling
1171: | fem_pl_pkg.Update_Num_Of_Output_Rows in fem_pl_tables.
1172: |
1173: | SCOPE - PRIVATE
1174: |
1175: +============================================================================*/
1196: ,p_module => G_BLOCK||'.'||l_api_name
1197: ,p_msg_text => 'BEGIN');
1198:
1199: -- Set the number of output rows for the output table.
1200: FEM_PL_PKG.Update_Num_Of_Output_Rows(
1201: p_api_version => 1.0
1202: ,p_commit => FND_API.G_TRUE
1203: ,p_request_id => p_request_id
1204: ,p_object_id => p_rule_obj_id
1249: | Update_Obj_Exec_Step_Status
1250: |
1251: | DESCRIPTION
1252: | Updates the status of the executuon of the object by calling
1253: | fem_pl_pkg.Update_obj_exec_step_status in fem_pl_obj_steps.
1254: |
1255: | SCOPE - PRIVATE
1256: |
1257: +============================================================================*/
1276: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1277: ,p_module => G_BLOCK||'.'||l_api_name
1278: ,p_msg_text => 'BEGIN');
1279:
1280: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure
1281: --to update step staus in fem_pl_obj_steps.
1282: FEM_PL_PKG.Update_obj_Exec_Step_Status(
1283: p_api_version => 1.0
1284: ,p_commit => FND_API.G_TRUE
1278: ,p_msg_text => 'BEGIN');
1279:
1280: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure
1281: --to update step staus in fem_pl_obj_steps.
1282: FEM_PL_PKG.Update_obj_Exec_Step_Status(
1283: p_api_version => 1.0
1284: ,p_commit => FND_API.G_TRUE
1285: ,p_request_id => p_request_id
1286: ,p_object_id => p_rule_obj_id
1461: ,p_tbl_name => p_tbl_name
1462: ,p_stmt_type => g_update );
1463:
1464: -----------------------------------------------------------------------
1465: -- Call FEM_PL_PKG.update_num_of_input_rows();
1466: -----------------------------------------------------------------------
1467: FEM_ENGINES_PKG.TECH_MESSAGE(
1468: p_severity => g_log_level_1,
1469: p_module => G_BLOCK||'.'||l_api_name,
1927: ,p_module => G_BLOCK||'.'||l_api_name
1928: ,p_msg_text => 'BEGIN');
1929:
1930: -- Set the number of output rows for the output table.
1931: FEM_PL_PKG.register_updated_column(
1932: p_api_version => 1.0
1933: ,p_commit => FND_API.G_TRUE
1934: ,p_request_id => p_request_id
1935: ,p_object_id => p_object_id
2021: ,p_module => G_BLOCK||'.'||l_api_name
2022: ,p_msg_text => 'BEGIN');
2023:
2024: -- Set the number of output rows for the output table.
2025: FEM_PL_PKG.Update_Num_Of_Input_Rows(
2026: p_api_version => 1.0
2027: ,p_commit => FND_API.G_TRUE
2028: ,p_request_id => p_request_id
2029: ,p_object_id => p_rule_obj_id