[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
947: --If line has rltd modifiers, then increment qual_ind by 1.
948: BEGIN
949: select 1
950: into l_count
951: from dual where exists
952: (select 'x'
953: from qp_rltd_modifiers
954: where to_rltd_modifier_id = l_list_line_id_tbl(i)
955: and rltd_modifier_grp_type <> 'COUPON');
974: IF l_list_header_id_tbl(i) <> l_list_header_id THEN
975: BEGIN
976: select 1
977: into l_count
978: from dual where exists
979: (select 'x'
980: from qp_qualifiers
981: where list_header_id = l_list_header_id_tbl(i)
982: and NOT (qualifier_context = 'MODLIST' and
1002: --increment qual ind by 2
1003: BEGIN
1004: select 1
1005: into l_count
1006: from dual where exists
1007: (select 'x'
1008: from qp_qualifiers
1009: where list_header_id = l_list_header_id_tbl(i)
1010: and nvl(list_line_id,-1) = -1);
1021: --increment qual ind by 8
1022: BEGIN
1023: select 1
1024: into l_count
1025: from dual where exists
1026: (select 'x'
1027: from qp_qualifiers
1028: where list_header_id = l_list_header_id_tbl(i)
1029: and list_line_id = l_list_line_id_tbl(i));
1041: --If line has product attributes, then increment qual_ind by 4.
1042: BEGIN
1043: select 1
1044: into l_count
1045: from dual where exists
1046: (select 'x'
1047: from qp_pricing_attributes
1048: where list_line_id = l_list_line_id_tbl(i)
1049: and excluder_flag = 'N');
1059: --If line has pricing attributes, then increment qual_ind by 16.
1060: BEGIN
1061: select 1
1062: into l_count
1063: from dual where exists
1064: (select 'x'
1065: from qp_pricing_attributes
1066: where list_line_id = l_list_line_id_tbl(i)
1067: and pricing_attribute_context is not null