APPS.QP_MODIFIER_UPGRADE_UTIL_PVT dependencies on DUAL

Line 60: FROM DUAL;

56:
57: IF (p_new_flag = TRUE) THEN
58: SELECT SO_PRICE_LISTS_S.nextval
59: INTO v_seq_num
60: FROM DUAL;
61: v_seq_num := v_seq_num + 5000;
62: ELSE
63: v_seq_num := p_seq_num + 1;
64: END IF;

Line 85: FROM DUAL;

81:
82: -- Store the current list header id
83: SELECT QP_LIST_HEADERS_B_S.currval
84: INTO x_list_header_id
85: FROM DUAL;
86:
87: --x_list_header_id := v_seq_num;
88:
89: v_name := p_name;

Line 191: FROM DUAL;

187: BEGIN
188: IF (p_new_flag = TRUE) THEN
189: SELECT SO_PRICE_LIST_LINES_S.nextval
190: INTO v_seq_num
191: FROM DUAL;
192: v_seq_num := v_seq_num + 5000;
193: ELSE
194: v_seq_num := p_seq_num + 1;
195: END IF;

Line 199: FROM DUAL;

195: END IF;
196:
197: SELECT QP_LIST_LINES_S.nextval
198: INTO v_list_line_seq
199: FROM DUAL;
200:
201: INSERT INTO QP_LIST_LINES (
202: LIST_LINE_ID,LIST_LINE_NO, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
203: LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID,

Line 234: FROM DUAL;

230: -- Store the new list line id
231:
232: SELECT QP_LIST_LINES_S.currval
233: INTO x_list_line_id
234: FROM DUAL;
235:
236: --x_list_line_id := v_seq_num;
237:
238:

Line 303: FROM DUAL;

299: -- Create new grouping no
300: IF (p_qualifier_grouping_no = 0) THEN
301: SELECT QP.QP_QUALIFIER_GROUP_NO_S.nextval
302: INTO x_qualifier_grouping_no
303: FROM DUAL;
304: ELSE
305: x_qualifier_grouping_no := p_qualifier_grouping_no;
306: END IF;
307:

Line 412: FROM DUAL; */

408:
409:
410: /* SELECT QP_PRICING_ATTRIBUTES_S.currval
411: INTO x_pricing_attribute_id
412: FROM DUAL; */
413: x_pricing_attribute_id :=1;
414:
415:
416: EXCEPTION

Line 493: FROM DUAL;

489: );
490:
491: SELECT QP_PRICING_ATTRIBUTES_S.currval
492: INTO x_pricing_attribute_id
493: FROM DUAL;
494:
495:
496: EXCEPTION
497: WHEN OTHERS THEN

Line 540: FROM DUAL;

536: p_from_rltd_modifier_id,p_to_rltd_modifier_id,p_rltd_modifier_grp_type);
537:
538: SELECT QP_RLTD_MODIFIERS_S.currval
539: INTO x_rltd_modifier_id
540: FROM DUAL;
541:
542:
543: EXCEPTION
544: WHEN OTHERS THEN