DBA Data[Home] [Help]

APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on FND_PROFILE

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

696: END IF;
697: --pattern
698: -- jagan's PL/SQL pattern
699: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
700: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
701: IF(p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
702: qp_delayed_requests_pvt.log_request(
703: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
704: p_entity_id => p_PRICING_ATTR_rec.list_header_id,

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

1236: , QUALIFICATION_IND = p_PRICING_ATTR_rec.qualification_ind
1237: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
1238: ;
1239:
1240: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1241: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1242:
1243: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1244: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN

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

1434: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_PRICING_ATTR_rec.list_line_id)
1435: ,(select h.ORIG_SYSTEM_HEADER_REF from QP_LIST_HEADERS_ALL_B h where h.list_header_id=p_PRICING_ATTR_rec.list_header_id)
1436: );
1437:
1438: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1439: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1440: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1441: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1442:

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

2430: END IF; --Java Engine Installed
2431: -- pattern
2432: -- jagan's PL/SQL pattern
2433: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
2434: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
2435: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2436: qp_delayed_requests_pvt.log_request(
2437: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2438: p_entity_id => p_PRICING_ATTR_rec.list_header_id,