DBA Data[Home] [Help]

APPS.PFT_PPROFCAL_MASTER_PUB dependencies on FEM_PL_OBJECT_EXECUTIONS

Line 210: fem_pl_object_executions x

206: select rs.child_obj_id
207: ,rs.child_obj_def_id
208: ,x.exec_status_code
209: from fem_ruleset_process_data rs,
210: fem_pl_object_executions x
211: where rs.request_id = p_request_id
212: and rs.rule_set_obj_id = p_ruleset_obj_id
213: and x.request_id(+) = rs.request_id
214: and x.object_id(+) = rs.child_obj_id

Line 1309: -- to register the rollup object execution in FEM_PL_OBJECT_EXECUTIONS,

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;
1313:

Line 1785: fem_pl_object_executions x

1781: ,p_msg_text => 'BEGIN');
1782: SELECT COUNT(*)
1783: INTO l_count
1784: FROM fem_ruleset_process_data p,
1785: fem_pl_object_executions x
1786: WHERE p.request_id = p_request_id AND
1787: p.request_id = x.request_id(+) AND
1788: p.rule_set_obj_id = p_rule_set_obj_id
1789: ORDER BY p.engine_execution_sequence;