DBA Data[Home] [Help]

APPS.PFT_PPROFCAL_MASTER_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: g_fem_customers_attr CONSTANT VARCHAR2(30) := 'FEM_CUSTOMERS_ATTR';

Line 869: -- Call the FEM_PL_PKG.Register_Request API procedure to register

865: ,p_msg_text => 'BEGIN');
866:
867: SAVEPOINT register_request_pub;
868:
869: -- Call the FEM_PL_PKG.Register_Request API procedure to register
870: -- the concurrent request in FEM_PL_REQUESTS.
871: FEM_PL_PKG.Register_Request(
872: p_api_version => G_CALLING_API_VERSION
873: ,p_commit => FND_API.G_FALSE

Line 871: FEM_PL_PKG.Register_Request(

867: SAVEPOINT register_request_pub;
868:
869: -- Call the FEM_PL_PKG.Register_Request API procedure to register
870: -- the concurrent request in FEM_PL_REQUESTS.
871: FEM_PL_PKG.Register_Request(
872: p_api_version => G_CALLING_API_VERSION
873: ,p_commit => FND_API.G_FALSE
874: ,p_cal_period_id => p_param_rec.output_cal_period_id
875: ,p_ledger_id => p_param_rec.ledger_id

Line 976: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register

972: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
973: ,p_module => G_BLOCK||'.'||l_api_name
974: ,p_msg_text => 'BEGIN');
975:
976: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register
977: -- the specified object definition in FEM_PL_OBJECT_DEFS, thus obtaining
978: -- an object definition lock.
979: FEM_PL_PKG.Register_Object_Def (
980: p_api_version => 1.0

Line 979: FEM_PL_PKG.Register_Object_Def (

975:
976: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register
977: -- the specified object definition in FEM_PL_OBJECT_DEFS, thus obtaining
978: -- an object definition lock.
979: FEM_PL_PKG.Register_Object_Def (
980: p_api_version => 1.0
981: ,p_commit => FND_API.G_FALSE
982: ,p_request_id => p_param_rec.request_id
983: ,p_object_id => p_object_id

Line 1049: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register step

1045: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1046: ,p_module => G_BLOCK||'.'||l_api_name
1047: ,p_msg_text => 'BEGIN');
1048:
1049: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register step
1050: -- in fem_pl_obj_steps.
1051: FEM_PL_PKG.Register_Obj_Exec_Step (
1052: p_api_version => 1.0
1053: ,p_commit => FND_API.G_FALSE

Line 1051: FEM_PL_PKG.Register_Obj_Exec_Step (

1047: ,p_msg_text => 'BEGIN');
1048:
1049: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register step
1050: -- in fem_pl_obj_steps.
1051: FEM_PL_PKG.Register_Obj_Exec_Step (
1052: p_api_version => 1.0
1053: ,p_commit => FND_API.G_FALSE
1054: ,p_request_id => p_param_rec.request_id
1055: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1308: -- Call the FEM_PL_PKG.Register_Object_Execution API procedure

1304: RAISE e_process_single_rule_error;
1305:
1306: END;
1307:
1308: -- Call the FEM_PL_PKG.Register_Object_Execution API procedure
1309: -- to register the rollup object execution in FEM_PL_OBJECT_EXECUTIONS,
1310: -- thus obtaining an execution lock.
1311: BEGIN
1312: SAVEPOINT register_rule_pub;

Line 1314: FEM_PL_PKG.Register_Object_Execution(

1310: -- thus obtaining an execution lock.
1311: BEGIN
1312: SAVEPOINT register_rule_pub;
1313:
1314: FEM_PL_PKG.Register_Object_Execution(
1315: p_api_version => G_CALLING_API_VERSION
1316: ,p_commit => FND_API.G_TRUE
1317: ,p_request_id => p_param_rec.request_id
1318: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1356: --call to FEM_PL_PKG.register_dependent_objdefs

1352: RAISE e_process_single_rule_error;
1353: END;
1354:
1355: --------------------------------------------------------------------------
1356: --call to FEM_PL_PKG.register_dependent_objdefs
1357: --------------------------------------------------------------------------
1358: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1359: ,p_module => G_BLOCK||'.'||l_api_name
1360: ,p_msg_text => 'Register_Dependent_Objects');

Line 1418: -- Call FEM_PL_PKG.Register_Table()

1414: END;
1415:
1416: IF l_region_percent = 0 THEN
1417: -----------------------------------------------------------------------
1418: -- Call FEM_PL_PKG.Register_Table()
1419: -----------------------------------------------------------------------
1420: FEM_ENGINES_PKG.Tech_Message(
1421: p_severity => g_log_level_3
1422: ,p_module => G_BLOCK||'.'||l_api_name

Line 1536: -- Call FEM_PL_PKG.Register_Table()

1532: -- End of Bug # 4906275
1533:
1534: IF l_profit_percentile = 0 THEN
1535: -----------------------------------------------------------------------
1536: -- Call FEM_PL_PKG.Register_Table()
1537: -----------------------------------------------------------------------
1538: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1539: ,p_module => G_BLOCK||'.'||l_api_name
1540: ,p_msg_text => 'Register table:CUST_PPTILE');

Line 1625: -- Call FEM_PL_PKG.Register_Table()

1621: --
1622: END IF;*/
1623:
1624: -----------------------------------------------------------------------
1625: -- Call FEM_PL_PKG.Register_Table()
1626: -----------------------------------------------------------------------
1627: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1628: ,p_module => G_BLOCK||'.'||l_api_name
1629: ,p_msg_text => 'Register table:Value Index');

Line 1685: -- Call FEM_PL_PKG.Register_Table()

1681:
1682: --Check whether Prospect Identification is selected
1683: /* IF (l_prospect_ident_flag = 'Y') THEN
1684: -----------------------------------------------------------------------
1685: -- Call FEM_PL_PKG.Register_Table()
1686: -----------------------------------------------------------------------
1687: FEM_ENGINES_PKG.Tech_Message(
1688: p_severity => g_log_level_3
1689: ,p_module => G_BLOCK||'.'||l_api_name

Line 1846: FEM_PL_PKG.Update_Obj_Exec_Status (

1842: p_severity => g_log_level_1
1843: ,p_module => G_BLOCK||'.'||l_api_name
1844: ,p_msg_text => 'Step 1: Update Object Execution Status');
1845:
1846: FEM_PL_PKG.Update_Obj_Exec_Status (
1847: p_api_version => 1.0
1848: ,p_commit => FND_API.G_FALSE
1849: ,p_request_id => p_param_rec.request_id
1850: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1874: FEM_PL_PKG.Update_Obj_Exec_Errors (

1870: p_severity => g_log_level_1
1871: ,p_module => G_BLOCK||'.'||l_api_name
1872: ,p_msg_text => 'Step 2: Update Object Execution Errors');
1873:
1874: FEM_PL_PKG.Update_Obj_Exec_Errors (
1875: p_api_version => 1.0
1876: ,p_commit => FND_API.G_FALSE
1877: ,p_request_id => p_param_rec.request_id
1878: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1903: FEM_PL_PKG.Update_Request_Status (

1899: p_severity => g_log_level_1
1900: ,p_module => G_BLOCK||'.'||l_api_name
1901: ,p_msg_text => 'Step 3: Update Request Status');
1902:
1903: FEM_PL_PKG.Update_Request_Status (
1904: p_api_version => 1.0
1905: ,p_commit => FND_API.G_FALSE
1906: ,p_request_id => p_param_rec.request_id
1907: ,p_exec_status_code => p_exec_status_code

Line 2101: FEM_PL_PKG.Register_Dependent_ObjDefs (

2097: ,p_module => G_BLOCK||'.'||l_api_name
2098: ,p_msg_text => 'BEGIN');
2099:
2100: -- Register all the Dependent Objects for CALC
2101: FEM_PL_PKG.Register_Dependent_ObjDefs (
2102: p_api_version => G_CALLING_API_VERSION
2103: ,p_commit => FND_API.G_TRUE
2104: ,p_request_id => p_param_rec.request_id
2105: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 2186: FEM_PL_PKG.Update_Num_Of_Input_Rows(

2182: ,p_module => G_BLOCK||'.'||l_api_name
2183: ,p_msg_text => 'BEGIN');
2184:
2185: -- Set the number of output rows for the output table.
2186: FEM_PL_PKG.Update_Num_Of_Input_Rows(
2187: p_api_version => 1.0
2188: ,p_commit => FND_API.G_TRUE
2189: ,p_request_id => p_param_rec.request_id
2190: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 2267: -- Call the FEM_PL_PKG.Register_Table API procedure to register

2263: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2264: ,p_module => G_BLOCK||'.'||l_api_name
2265: ,p_msg_text => 'BEGIN');
2266:
2267: -- Call the FEM_PL_PKG.Register_Table API procedure to register
2268: -- the specified output table and the statement type that will be used.
2269: FEM_PL_PKG.Register_Table(
2270: p_api_version => 1.0
2271: ,p_commit => FND_API.G_FALSE

Line 2269: FEM_PL_PKG.Register_Table(

2265: ,p_msg_text => 'BEGIN');
2266:
2267: -- Call the FEM_PL_PKG.Register_Table API procedure to register
2268: -- the specified output table and the statement type that will be used.
2269: FEM_PL_PKG.Register_Table(
2270: p_api_version => 1.0
2271: ,p_commit => FND_API.G_FALSE
2272: ,p_request_id => p_param_rec.request_id
2273: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 2352: FEM_PL_PKG.register_updated_column(

2348: ,p_module => G_BLOCK||'.'||l_api_name
2349: ,p_msg_text => 'BEGIN');
2350:
2351: -- Set the number of output rows for the output table.
2352: FEM_PL_PKG.register_updated_column(
2353: p_api_version => 1.0
2354: ,p_commit => FND_API.G_TRUE
2355: ,p_request_id => p_param_rec.request_id
2356: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 2432: which is executed by some other rule(say R1), we need to call 'fem_pl_pkg.register_chain' to register this chain

2428:
2429: Requirement :
2430: -------------
2431: If a new rule (say V1) is created with Value Index formula refers to 'Region Counting' and 'Profit Percentile'
2432: which is executed by some other rule(say R1), we need to call 'fem_pl_pkg.register_chain' to register this chain
2433: so that when ever R1 is undone (using 'UNDO UI'), V1 should also be undone.
2434:
2435: Logic:
2436: ------

Line 2437: Get the concurrent req Id and Object Id of Rule R1 and call fem_pl_pkg.register_chain.

2433: so that when ever R1 is undone (using 'UNDO UI'), V1 should also be undone.
2434:
2435: Logic:
2436: ------
2437: Get the concurrent req Id and Object Id of Rule R1 and call fem_pl_pkg.register_chain.
2438:
2439: EXCEPTION
2440:
2441: END Register_Chaining */