APPS.IEU_WP_ACTION_PVT dependencies on DBMS_SQL

Line 193: DBMS_SQL.CLOSE_CURSOR(v_CursorID);

189: null;
190:
191: WHEN OTHERS THEN
192: ROLLBACK;
193: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195:
196:
197: commit;

Line 1171: --DBMS_SQL.CLOSE_CURSOR(v_cursor);

1167: l_max_action_param_set_id := l_action_temp_id;
1168: end if;
1169:
1170: end loop; --for v_cursor
1171: --DBMS_SQL.CLOSE_CURSOR(v_cursor);
1172: CLOSE c_ref2;
1173:
1174: --get property_id, property_value, VALUE_OVERRIDE_FLAG, NOT_VALID_FLAG
1175: If l_max_action_param_set_id IS NOT NULL then

Line 1218: --DBMS_SQL.CLOSE_CURSOR(v_cursor2);

1214: param_props_rec.NOT_VALID_FLAG :=l_not_valid_flag;
1215: param_props_rec.owner := 1;
1216: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);
1217: end loop;-- for v_cursor2
1218: --DBMS_SQL.CLOSE_CURSOR(v_cursor2);
1219: CLOSE c_ref2;
1220: END IF ; -- for max action param set is not null
1221: end LOOP;-- for v_cursor1
1222: -- DBMS_SQL.CLOSE_CURSOR(v_cursor1);

Line 1222: -- DBMS_SQL.CLOSE_CURSOR(v_cursor1);

1218: --DBMS_SQL.CLOSE_CURSOR(v_cursor2);
1219: CLOSE c_ref2;
1220: END IF ; -- for max action param set is not null
1221: end LOOP;-- for v_cursor1
1222: -- DBMS_SQL.CLOSE_CURSOR(v_cursor1);
1223: CLOSE c_ref;
1224:
1225:
1226: end LOOP; -- for c_cur

Line 1237: --v_cursor := DBMS_SQL.OPEN_CURSOR;

1233: FETCH c_cur2 INTO c_rec2;
1234: EXIT WHEN c_cur2%NOTFOUND;
1235: l_temp := c_rec2.action_param_set_id;
1236: l_ptemp := c_rec2.param_id;
1237: --v_cursor := DBMS_SQL.OPEN_CURSOR;
1238: sql_stmt1 :=' select param_property_id '||
1239: ' from ieu_wp_param_props_b '||
1240: ' where action_param_set_id = :temp '||
1241: ' and property_id = 10003'||