DBA Data[Home] [Help]

APPS.QP_LIMITS_UTIL dependencies on FND_PROFILE

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

122: END IF;
123: END IF;
124: -- jagan's PL/SQL pattern
125: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
126: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
127: IF (p_LIMITS_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
128: IF l_updated = 1 then
129: qp_delayed_requests_pvt.log_request(
130: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

1242: WHERE LIMIT_ID = p_LIMITS_rec.limit_id
1243: ;
1244: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_update;
1245:
1246: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1247: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1248:
1249: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1250: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN

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

1424: );
1425: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_create;
1426: Update_List_Header_And_Line(l_LIMITS_rec);
1427: --dbms_output.put_line('End Insert Row');
1428: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1429: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1430: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1431: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN
1432: UPDATE qp_pte_segments SET used_in_setup='Y'