DBA Data[Home] [Help]

APPS.QP_COPY_PRICELIST_PVT dependencies on FND_PROFILE

Line 2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598

2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,
2574: l_qp_list_lines_rec.qualification_ind,
2575: l_qp_list_lines_rec.recurring_value, -- block pricing
2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598
2577: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2578: --,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2579: --,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2580: ,to_char(l_new_list_line_id) --bug#12423441

Line 2886: IF (l_non_cont_pbh_id_tbl.COUNT > 0) and (nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y')= 'Y') THEN -- 14103598

2882:
2883:
2884: --Upgrade Non-Continuous Price Breaks
2885:
2886: IF (l_non_cont_pbh_id_tbl.COUNT > 0) and (nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y')= 'Y') THEN -- 14103598
2887: fnd_file.put_line(FND_FILE.LOG,'New List Name : '||p_new_price_list_name);
2888:
2889: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
2890: LOOP

Line 2936: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

2932: l_min_list_line_id,l_max_list_line_id);
2933: END IF;
2934: --- jagan PL/SQL pattern engine
2935: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
2936: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
2937: for l_list_header_id in l_new_list_header_id..NVL(l_new_discount_header_id,l_new_list_header_id)
2938: loop
2939: begin
2940: