DBA Data[Home] [Help]

APPS.FEM_HELPER_RULE_UTIL_PKG dependencies on FEM_OBJDEF_HELPER_RULES

Line 215: insert into fem_objdef_helper_rules (OBJECT_DEFINITION_ID,

211:
212: END;
213:
214:
215: insert into fem_objdef_helper_rules (OBJECT_DEFINITION_ID,
216: HELPER_OBJECT_TYPE_CODE,
217: OBJECT_ID,
218: HELPER_OBJ_DEF_ID,
219: HELPER_OBJECT_ID,

Line 417: FROM fem_objdef_helper_rules

413: BEGIN
414:
415: SELECT helper_obj_def_id
416: INTO x_helper_obj_def_id
417: FROM fem_objdef_helper_rules
418: WHERE object_definition_id = p_rule_obj_def_id
419: AND helper_object_type_code = p_helper_object_type_code;
420:
421: EXCEPTION

Line 427: FROM fem_objdef_helper_rules H, fem_object_definition_b D

423: /* Does helper exist for this Object ID */
424: BEGIN
425: SELECT min(helper_obj_def_id)
426: INTO x_helper_obj_def_id
427: FROM fem_objdef_helper_rules H, fem_object_definition_b D
428: WHERE D.object_id = H.object_id
429: AND D.object_definition_id = p_rule_obj_def_id
430: AND helper_object_type_code = p_helper_object_type_code;
431: