APPS.PFT_ACCTRELCONS_PUB dependencies on FEM_PL_OBJECT_EXECUTIONS

Line 242: fem_pl_object_executions x

238: p.engine_execution_sequence,
239: p.child_obj_id,
240: x.exec_status_code
241: FROM fem_ruleset_process_data p,
242: fem_pl_object_executions x
243: WHERE p.request_id = p_request_id AND
244: p.request_id = x.request_id(+) AND
245: p.rule_set_obj_id = p_rule_set_obj_id*/
246: select rs.child_obj_id

Line 250: fem_pl_object_executions x

246: select rs.child_obj_id
247: ,rs.child_obj_def_id
248: ,x.exec_status_code
249: from fem_ruleset_process_data rs,
250: fem_pl_object_executions x
251: where rs.request_id = p_request_id
252: and rs.rule_set_obj_id = p_ruleset_obj_id
253: and x.request_id(+) = rs.request_id
254: and x.object_id(+) = rs.child_obj_id

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

1846: END;
1847:
1848: BEGIN
1849: -- Call the FEM_PL_PKG.Register_Object_Execution API procedure
1850: -- to register the rollup object execution in FEM_PL_OBJECT_EXECUTIONS,
1851: -- thus obtaining an execution lock.
1852:
1853: SAVEPOINT register_rule_pub;
1854:

Line 2248: fem_pl_object_executions x

2244: ,p_msg_text => 'BEGIN');
2245: SELECT COUNT(*)
2246: INTO l_count
2247: FROM fem_ruleset_process_data p,
2248: fem_pl_object_executions x
2249: WHERE p.request_id = p_request_id AND
2250: p.request_id = x.request_id(+) AND
2251: p.rule_set_obj_id = p_rule_set_obj_id
2252: ORDER BY p.engine_execution_sequence;