[Home] [Help]
1163: ;
1164:
1165:
1166:
1167: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1168:
1169: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND p_QUALIFIERS_rec.active_flag='Y') THEN
1170:
1171: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND
1431: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_QUALIFIERS_rec.list_line_id)
1432: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_QUALIFIERS_rec.list_header_id)
1433: );
1434:
1435: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1436: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1437: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND
1438: (p_QUALIFIERS_rec.qualifier_attribute IS NOT NULL) THEN
1439: /* USed the cursor update_pte_cur instead of a nested subquery for the update statement
1450: end loop;
1451:
1452: END IF;
1453: END IF;
1454: /*l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1455: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1456: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND
1457: (p_QUALIFIERS_rec.qualifier_attribute IS NOT NULL) THEN
1458:
1987:
1988: END IF;
1989:
1990: /*
1991: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1992: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_qualifiers_rec.active_flag='Y') THEN
1993: IF(l_qualifiers_rec.qualifier_context IS NOT NULL) AND
1994: (l_qualifiers_rec.qualifier_attribute IS NOT NULL) THEN
1995: l_status:=QP_UTIL.Is_Used('QUALIFIER',
3052: --Header Level Qualifier Count
3053: l_llq_count NUMBER := 0;
3054: --Line Level Qualifier Count
3055: l_list_type_code VARCHAR2(30);
3056: l_denormalize_qual varchar2(1) := nvl(fnd_profile.value('QP_DENORMALIZE_QUALIFIERS'),'Y');
3057: --7120399
3058:
3059: BEGIN
3060: