eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on FND_PROFILE

Line 1167: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');

1163: ;
1164:
1165:
1166:
1167: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1168:
1169: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND p_QUALIFIERS_rec.active_flag='Y') THEN
1170:
1171: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND

Line 1434: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');

1430: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_QUALIFIERS_rec.list_line_id)
1431: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_QUALIFIERS_rec.list_header_id)
1432: );
1433:
1434: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1435: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1436: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND
1437: (p_QUALIFIERS_rec.qualifier_attribute IS NOT NULL) THEN
1438: /* USed the cursor update_pte_cur instead of a nested subquery for the update statement

Line 1453: /*l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');

1449: end loop;
1450:
1451: END IF;
1452: END IF;
1453: /*l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1454: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1455: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND
1456: (p_QUALIFIERS_rec.qualifier_attribute IS NOT NULL) THEN
1457:

Line 1990: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');

1986:
1987: END IF;
1988:
1989: /*
1990: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1991: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_qualifiers_rec.active_flag='Y') THEN
1992: IF(l_qualifiers_rec.qualifier_context IS NOT NULL) AND
1993: (l_qualifiers_rec.qualifier_attribute IS NOT NULL) THEN
1994: l_status:=QP_UTIL.Is_Used('QUALIFIER',

Line 3102: l_denormalize_qual varchar2(1) := nvl(fnd_profile.value('QP_DENORMALIZE_QUALIFIERS'),'Y');

3098: --Header Level Qualifier Count
3099: l_llq_count NUMBER := 0;
3100: --Line Level Qualifier Count
3101: l_list_type_code VARCHAR2(30);
3102: l_denormalize_qual varchar2(1) := nvl(fnd_profile.value('QP_DENORMALIZE_QUALIFIERS'),'Y');
3103: --7120399
3104:
3105: BEGIN
3106:

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

3662: END IF; --Java Engine Installed
3663: --pattern
3664: -- jagan's PL/SQL pattern
3665: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
3666: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' THEN
3667:
3668: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3669: p_QUALIFIERS_rec.list_line_id = -1 THEN
3670: -- header qualifier is added to price list/modifier