DBA Data[Home] [Help]

APPS.PFT_PROFCAL_VALIDX_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:
19: --constant for sql_stmt_type

Line 594: -- Call the FEM_PL_PKG.Register_Chain API procedure to register

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

Line 596: FEM_PL_PKG.Register_Chain (

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

Line 650: -- Call the FEM_PL_PKG.Register_Chain API procedure to register

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

Line 652: FEM_PL_PKG.Register_Chain (

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

Line 1171: | fem_pl_pkg.Update_Num_Of_Output_Rows in fem_pl_tables.

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: +============================================================================*/

Line 1200: FEM_PL_PKG.Update_Num_Of_Output_Rows(

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

Line 1253: | fem_pl_pkg.Update_obj_exec_step_status in fem_pl_obj_steps.

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: +============================================================================*/

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

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

Line 1282: FEM_PL_PKG.Update_obj_Exec_Step_Status(

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

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

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,

Line 1931: FEM_PL_PKG.register_updated_column(

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

Line 2025: FEM_PL_PKG.Update_Num_Of_Input_Rows(

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