DBA Data[Home] [Help]

APPS.QP_LIMIT_ATTRS_UTIL dependencies on FND_PROFILE

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

857: , REQUEST_ID = p_LIMIT_ATTRS_rec.request_id
858: WHERE LIMIT_ATTRIBUTE_ID = p_LIMIT_ATTRS_rec.limit_attribute_id
859: ;
860:
861: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
862: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
863:
864: IF(p_LIMIT_ATTRS_rec.limit_attribute_context IS NOT NULL)
865: AND (p_LIMIT_ATTRS_rec.limit_attribute IS NOT NULL) THEN

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

977: , p_LIMIT_ATTRS_rec.program_update_date
978: , p_LIMIT_ATTRS_rec.request_id
979: );
980:
981: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
982: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
983: IF(p_LIMIT_ATTRS_rec.limit_attribute_context IS NOT NULL)
984: AND (p_LIMIT_ATTRS_rec.limit_attribute IS NOT NULL) THEN
985: UPDATE qp_pte_segments SET used_in_setup='Y'