62: CURSOR c IS
63: SELECT
64: rowid
65: FROM
66: MTL_MVT_STATS_RULE_SETS_B
67: WHERE Rule_Set_code = p_rule_set_code;
68: BEGIN
69: INSERT INTO MTL_MVT_STATS_RULE_SETS_B
70: ( Rule_Set_code
65: FROM
66: MTL_MVT_STATS_RULE_SETS_B
67: WHERE Rule_Set_code = p_rule_set_code;
68: BEGIN
69: INSERT INTO MTL_MVT_STATS_RULE_SETS_B
70: ( Rule_Set_code
71: , Rule_set_type
72: , Seeded_Flag
73: , Category_Set_Id
144:
145: --=========================================================================
146: --PRECEDURE : Lock_Row Public
147: --PARAMETERS: see below
148: --COMMENT : table handler for locking table mtl_mvt_stats_rule_sets_b and
149: -- table mtl_mvt_stats_rule_sets_tl
150: --EXCEPTION : record_changed;
151: --==========================================================================
152: PROCEDURE Lock_Row
157: IS
158: CURSOR c IS
159: SELECT *
160: FROM
161: MTL_MVT_STATS_RULE_SETS_B
162: WHERE Rule_Set_code = p_rule_set_code
163: FOR UPDATE OF Rule_Set_code NOWAIT;
164: recinfo c%ROWTYPE;
165:
229: , p_last_update_login IN NUMBER
230: )
231: IS
232: BEGIN
233: UPDATE MTL_MVT_STATS_RULE_SETS_B
234: SET
235: last_update_date = p_last_update_date
236: , last_updated_by = p_last_updated_by
237: , last_update_login = p_last_update_login
288: THEN
289: RAISE NO_DATA_FOUND;
290: END IF;
291:
292: DELETE FROM MTL_MVT_STATS_RULE_SETS_B
293: WHERE Rule_Set_code = p_rule_set_code;
294:
295: IF (SQL%NOTFOUND)
296: THEN
320: WHERE NOT EXISTS
321: (SELECT
322: NULL
323: FROM
324: MTL_MVT_STATS_RULE_SETS_B B
325: WHERE B.Rule_Set_code = T.Rule_Set_code
326: );
327:
328: UPDATE MTL_MVT_STATS_RULE_SETS_TL T