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 305: FROM DUAL;*/

301: --bug 11826293
302:
303: /*SELECT QP.QP_QUALIFIER_GROUP_NO_S.nextval
304: INTO x_qualifier_grouping_no
305: FROM DUAL;*/
306:
307: SELECT QP_QUALIFIER_GROUP_NO_S.nextval
308: INTO x_qualifier_grouping_no
309: FROM DUAL;

Line 309: FROM DUAL;

305: FROM DUAL;*/
306:
307: SELECT QP_QUALIFIER_GROUP_NO_S.nextval
308: INTO x_qualifier_grouping_no
309: FROM DUAL;
310: ELSE
311: x_qualifier_grouping_no := p_qualifier_grouping_no;
312: END IF;
313:

Line 418: FROM DUAL; */

414:
415:
416: /* SELECT QP_PRICING_ATTRIBUTES_S.currval
417: INTO x_pricing_attribute_id
418: FROM DUAL; */
419: x_pricing_attribute_id :=1;
420:
421:
422: EXCEPTION

Line 499: FROM DUAL;

495: );
496:
497: SELECT QP_PRICING_ATTRIBUTES_S.currval
498: INTO x_pricing_attribute_id
499: FROM DUAL;
500:
501:
502: EXCEPTION
503: WHEN OTHERS THEN

Line 546: FROM DUAL;

542: p_from_rltd_modifier_id,p_to_rltd_modifier_id,p_rltd_modifier_grp_type);
543:
544: SELECT QP_RLTD_MODIFIERS_S.currval
545: INTO x_rltd_modifier_id
546: FROM DUAL;
547:
548:
549: EXCEPTION
550: WHEN OTHERS THEN