[Home] [Help]
363: PUT_LINE('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
364: oe_debug_pub.add('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
365: IF (L_MAINT_DYN_SRC_VER='Y') THEN
366: BEGIN
367: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
368: IF (l_pkg_ver='5') THEN
369: l_new_pkg_name := l_new_pkg_name || '1';
370: ELSE
371: l_new_pkg_name := l_new_pkg_name || To_Char(To_Number(l_pkg_ver)+1);
494:
495: PUT_LINE('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
496:
497: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
498: UPDATE qp_parameters_b
499: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)) ,
500: LAST_UPDATE_DATE = sysdate,
501: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,
502: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
502: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
503: WHERE parameter_code='BLD_SRC_ATTR_ACTV_VER';
504: -- do not add any statements(even debug statements) in this area
505: IF SQL%ROWCOUNT = 0 THEN
506: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,
507: ADVANCED_PRICING_ONLY,SEEDED_VALUE,CREATION_DATE,CREATED_BY,
508: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
509: VALUES (-9999,'CONC','BLD_SRC_ATTR_ACTV_VER',-9999,
510: 'N','1',SYSDATE,
516: ELSE
517: PUT_LINE('insert row flag is Y ' );
518:
519: oe_debug_pub.add('insert row flag is Y ');
520: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,
521: ADVANCED_PRICING_ONLY,SEEDED_VALUE,CREATION_DATE,CREATED_BY,
522: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
523: VALUES (-9999,'CONC','BLD_SRC_ATTR_ACTV_VER',-9999,
524: 'N','1',SYSDATE,
2391: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2392: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2393: ELSE
2394: BEGIN
2395: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
2396: oe_debug_pub.add('1. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: l_pkg_ver:='0';
2777: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2778: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2779: ELSE
2780: BEGIN
2781: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
2782: oe_debug_pub.add('2. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
2783: EXCEPTION
2784: WHEN OTHERS THEN
2785: l_pkg_ver:='0';
3092: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3093: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3094: ELSE
3095: BEGIN
3096: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
3097: oe_debug_pub.add('3. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: l_pkg_ver:='0';