DBA Data[Home] [Help]

APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on FND_PROFILE

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

1220: , QUALIFICATION_IND = p_PRICING_ATTR_rec.qualification_ind
1221: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
1222: ;
1223:
1224: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1225: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1226:
1227: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1228: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN

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

1418: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_PRICING_ATTR_rec.list_line_id)
1419: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICING_ATTR_rec.list_header_id)
1420: );
1421:
1422: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1423: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1424: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1425: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1426: