[Home] [Help]
25: x_return_status_text OUT NOCOPY VARCHAR2)
26: Is
27:
28: Cursor l_basic_modifiers_cur Is
29: SELECT 'N' FROM dual WHERE
30: EXISTS(
31: SELECT 'Y'
32: FROM qp_list_headers_b qh,
33: qp_list_lines ql
210: , x_return_status_text OUT NOCOPY VARCHAR2) IS
211:
212: /* Changed the cursor below for the bug#2572053 */
213: CURSOR l_basic_modifiers_cur IS
214: SELECT 'Y' FROM DUAL WHERE
215: EXISTS(
216: SELECT 'Y'
217: FROM qp_list_headers_b qh,
218: qp_list_lines ql
430: and h.active_flag = 'Y'
431: and rownum = 1;
432: */
433: --fix for sql repository perf bug 3640054
434: select 'Y' into l_automatic_exists from dual
435: where exists (select 1 from qp_list_lines l
436: where l.automatic_flag = 'Y'
437: and l.pricing_phase_id = I.pricing_phase_id
438: and exists (select 'x' from qp_list_headers_b h
454: and h.active_flag = 'Y'
455: and rownum = 1;
456: */
457: --fix for sql repository perf bug 3640054
458: select 'Y' into l_manual_exists from dual
459: where exists (select 1 from qp_list_lines l
460: where l.automatic_flag = 'N'
461: and l.pricing_phase_id = I.pricing_phase_id
462: and exists (select 'x' from qp_list_headers_b h
958: --If line has rltd modifiers, then increment qual_ind by 1.
959: BEGIN
960: select 1
961: into l_count
962: from dual where exists
963: (select 'x'
964: from qp_rltd_modifiers
965: where to_rltd_modifier_id = l_list_line_id_tbl(i)
966: and rltd_modifier_grp_type <> 'COUPON');
985: IF l_list_header_id_tbl(i) <> l_list_header_id THEN
986: BEGIN
987: select 1
988: into l_count
989: from dual where exists
990: (select 'x'
991: from qp_qualifiers
992: where list_header_id = l_list_header_id_tbl(i)
993: and NOT (qualifier_context = 'MODLIST' and
1013: --increment qual ind by 2
1014: BEGIN
1015: select 1
1016: into l_count
1017: from dual where exists
1018: (select 'x'
1019: from qp_qualifiers
1020: where list_header_id = l_list_header_id_tbl(i)
1021: and nvl(list_line_id,-1) = -1);
1032: --increment qual ind by 8
1033: BEGIN
1034: select 1
1035: into l_count
1036: from dual where exists
1037: (select 'x'
1038: from qp_qualifiers
1039: where list_header_id = l_list_header_id_tbl(i)
1040: and list_line_id = l_list_line_id_tbl(i));
1052: --If line has product attributes, then increment qual_ind by 4.
1053: BEGIN
1054: select 1
1055: into l_count
1056: from dual where exists
1057: (select 'x'
1058: from qp_pricing_attributes
1059: where list_line_id = l_list_line_id_tbl(i)
1060: and excluder_flag = 'N');
1070: --If line has pricing attributes, then increment qual_ind by 16.
1071: BEGIN
1072: select 1
1073: into l_count
1074: from dual where exists
1075: (select 'x'
1076: from qp_pricing_attributes
1077: where list_line_id = l_list_line_id_tbl(i)
1078: and pricing_attribute_context is not null