[Home] [Help]
1115: l_count PLS_INTEGER;
1116: l_migrate_count PLS_INTEGER;
1117:
1118: CURSOR c_opm_actions IS
1119: SELECT * FROM gmd_actions_b
1120: WHERE migrated_ind is NULL;
1121:
1122: CURSOR c_opm_actions_tl (p_action_code VARCHAR2) IS
1123: SELECT * FROM gmd_actions_tl
1220: action_code = gt.action_code AND
1221: language = gt.language;
1222: END LOOP;
1223:
1224: UPDATE gmd_actions_b
1225: SET migrated_ind = 1
1226: WHERE action_code = g.action_code;
1227:
1228: IF (p_commit <> FND_API.G_FALSE) THEN
1230: END IF;
1231: l_migrate_count := l_migrate_count + 1;
1232: EXCEPTION
1233: WHEN e_already_exists THEN
1234: UPDATE gmd_actions_b
1235: SET migrated_ind = 1
1236: WHERE action_code = g.action_code;
1237: END;
1238: END LOOP;