DBA Data[Home] [Help]

APPS.QP_LIMITS_UTIL dependencies on FND_PROFILE

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

1211: WHERE LIMIT_ID = p_LIMITS_rec.limit_id
1212: ;
1213: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_update;
1214:
1215: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1216: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1217:
1218: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1219: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN

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

1393: );
1394: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_create;
1395: Update_List_Header_And_Line(l_LIMITS_rec);
1396: --dbms_output.put_line('End Insert Row');
1397: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1398: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1399: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1400: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN
1401: UPDATE qp_pte_segments SET used_in_setup='Y'