[Home] [Help]
264: oe_debug_pub.add('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
265: -- 13638721
266: IF (L_MAINT_DYN_SRC_VER='Y') THEN
267: BEGIN
268: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_FORMULA_ACTV_VER' AND ROWNUM=1;
269:
270: IF (l_pkg_ver='5') THEN
271: l_new_pkg_name := l_new_pkg_name || '1';
272: ELSE
355:
356: PUT_LINE('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
357:
358: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
359: UPDATE qp_parameters_b
360: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,
363: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
363: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
364: WHERE parameter_code='BLD_FORMULA_ACTV_VER';
365: -- do not add any statements(even debug statements) in this area
366: IF SQL%ROWCOUNT = 0 THEN
367: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,
368: ADVANCED_PRICING_ONLY,SEEDED_VALUE,CREATION_DATE,CREATED_BY,
369: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
370: VALUES (-8888,'CONC','BLD_FORMULA_ACTV_VER',-8888,
371: 'N','1',SYSDATE,
377: ELSE
378: PUT_LINE('insert row flag is Y ' );
379:
380: oe_debug_pub.add('insert row flag is Y ');
381: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,
382: ADVANCED_PRICING_ONLY,SEEDED_VALUE,CREATION_DATE,CREATED_BY,
383: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
384: VALUES (-8888,'CONC','BLD_FORMULA_ACTV_VER',-8888,
385: 'N','1',SYSDATE,