DBA Data[Home] [Help]

APPS.FEM_BR_RULE_SET_PVT dependencies on FEM_RULE_SETS

Line 148: -- FEM_RULE_SETS table.

144: -- CopyRuleSetRec
145: --
146: -- DESCRIPTION
147: -- Creates a new Rule Set Definition by copying records in the
148: -- FEM_RULE_SETS table.
149: --
150: -- IN
151: -- p_source_obj_def_id - Source Object Definition ID.
152: -- p_target_obj_def_id - Target Object Definition ID.

Line 167: INSERT INTO FEM_RULE_SETS (

163: --------------------------------------------------------------------------------
164: IS
165: BEGIN
166:
167: INSERT INTO FEM_RULE_SETS (
168: RULE_SET_OBJ_DEF_ID
169: ,RULE_SET_OBJECT_TYPE_CODE
170: ,OBJECT_VERSION_NUMBER
171: ,CREATION_DATE

Line 185: FROM FEM_RULE_SETS

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

Line 249: -- in the FEM_RULE_SETS table.

245: -- DeletRuleSetRec
246: --
247: -- DESCRIPTION
248: -- Deletes a Rule Set Definition by performing deletes on records
249: -- in the FEM_RULE_SETS table.
250: --
251: -- IN
252: -- p_obj_def_id - Object Definition ID.
253: --

Line 262: DELETE FROM FEM_RULE_SETS

258: --------------------------------------------------------------------------------
259: IS
260: BEGIN
261:
262: DELETE FROM FEM_RULE_SETS
263: WHERE RULE_SET_OBJ_DEF_ID = p_obj_def_id;
264:
265: END DeleteRuleSetRec;
266: