APPS.QP_COPY_MODIFIERS_PVT dependencies on FND_PROFILE

Line 207: IF (fnd_profile.value('QP_ALLOW_DUPLICATE_MODIFIERS') <> 'Y'

203: --fix for bug 4673872
204: SELECT GSA_INDICATOR INTO l_gsa_indicator FROM QP_LIST_HEADERS_ALL_B
205: WHERE list_header_id=p_new_list_header_id;
206:
207: IF (fnd_profile.value('QP_ALLOW_DUPLICATE_MODIFIERS') <> 'Y'
208: AND (l_qp_status = 'S' OR l_gsa_indicator = 'Y')) THEN
209:
210: /* Modified for 2222562 */
211: IF p_effective_dates_flag = 'N' THEN

Line 416: --if fnd_profile.value('QP_ATTRIBUTE_MANAGER_INSTALLED') = 'Y' then

412: FROM dual;
413:
414: --Discount Header Information
415:
416: --if fnd_profile.value('QP_ATTRIBUTE_MANAGER_INSTALLED') = 'Y' then
417: if QP_UTIL.Attrmgr_Installed = 'Y' then
418: INSERT INTO qp_list_headers_all_b
419: (
420: list_header_id,

Line 523: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),

519: discount_lines_flag,
520: gsa_indicator,
521: prorate_flag,
522: --source_system_code,
523: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),
524: DECODE(l_qp_status,'S','Y','N'), --2707484
525: --active_flag, -- bug 2180582 Was harcoded to N earlier
526: parent_list_header_id,
527: start_date_active_first,

Line 538: fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),

534: --decode(p_start_date_active,null,null,start_date_active_second),
535: --decode(p_end_date_active,null,null,end_date_active_second),
536: active_date_second_type,
537: ask_for_flag,
538: fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),
539: p_global_flag,
540: --added for MOAC
541: p_org_id
542: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 652: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),

648: discount_lines_flag,
649: gsa_indicator,
650: prorate_flag,
651: --source_system_code,
652: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),
653: --active_flag, -- bug 2180582 Was harcoded to N earlier
654: DECODE(l_qp_status,'S','Y','N'), --2707484
655: parent_list_header_id,
656: start_date_active_first,

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

1122: l_qp_discount_lines_rec.net_amount_flag,
1123: l_qp_discount_lines_rec.accum_context,
1124: l_qp_discount_lines_rec.accum_attribute,
1125: l_qp_discount_lines_rec.accum_attr_run_src_flag,
1126: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598
1127: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1128: --,to_char(l_new_discount_line_id)
1129: --,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1130: );

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

1599: end if;
1600:
1601: --Upgrade Non-Continuous Price Breaks
1602:
1603: IF (l_non_cont_pbh_id_tbl.COUNT > 0) and (nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y')= 'Y') THEN
1604: fnd_file.put_line(FND_FILE.LOG,'New List Name : '||p_new_price_list_name);
1605:
1606: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
1607: LOOP

Line 1655: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

1651: l_min_list_line_id,l_max_list_line_id);
1652: END IF;
1653: --- jagan PL/SQL pattern engine
1654: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1655: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1656: select min(list_line_id), max(list_line_id)
1657: into l_min_list_line_id, l_max_list_line_id
1658: from qp_list_lines
1659: where list_header_id = l_new_discount_header_id; --bug12784298