179: ,OBJECT_VERSION_NUMBER
180: ,NVL(p_creation_date,creation_date)
181: ,NVL(p_created_by,created_by)
182: ,SYSDATE
183: ,FND_GLOBAL.user_id
184: ,FND_GLOBAL.login_id
185: FROM FEM_RULE_SETS
186: WHERE RULE_SET_OBJ_DEF_ID = p_source_obj_def_id;
187:
180: ,NVL(p_creation_date,creation_date)
181: ,NVL(p_created_by,created_by)
182: ,SYSDATE
183: ,FND_GLOBAL.user_id
184: ,FND_GLOBAL.login_id
185: FROM FEM_RULE_SETS
186: WHERE RULE_SET_OBJ_DEF_ID = p_source_obj_def_id;
187:
188: END CopyRuleSetRec;
232: ,OBJECT_VERSION_NUMBER
233: ,NVL(p_creation_date,creation_date)
234: ,NVL(p_created_by,created_by)
235: ,SYSDATE
236: ,FND_GLOBAL.user_id
237: ,FND_GLOBAL.login_id
238: FROM FEM_RULE_SET_MEMBERS
239: WHERE RULE_SET_OBJ_DEF_ID = p_source_obj_def_id;
240:
233: ,NVL(p_creation_date,creation_date)
234: ,NVL(p_created_by,created_by)
235: ,SYSDATE
236: ,FND_GLOBAL.user_id
237: ,FND_GLOBAL.login_id
238: FROM FEM_RULE_SET_MEMBERS
239: WHERE RULE_SET_OBJ_DEF_ID = p_source_obj_def_id;
240:
241: END CopyMembersRec;