APPS.QP_MODIFIER_UPGRADE_UTIL_PVT dependencies on QP_LIST_LINES

Line 197: SELECT QP_LIST_LINES_S.nextval

193: ELSE
194: v_seq_num := p_seq_num + 1;
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 (

Line 201: INSERT INTO QP_LIST_LINES (

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,
204: LIST_HEADER_ID, LIST_LINE_TYPE_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE,
205: AUTOMATIC_FLAG, MODIFIER_LEVEL_CODE, ARITHMETIC_OPERATOR, OPERAND,PRICING_PHASE_ID,

Line 232: SELECT QP_LIST_LINES_S.currval

228: );
229:
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;

Line 338: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)

334: p_attribute8,p_attribute9,p_attribute10, p_attribute11,p_attribute12,p_attribute13,
335: p_attribute14,p_attribute15
336: --ENH Upgrade BOAPI for orig_sys...ref RAVI
337: ,to_char(QP_QUALIFIERS_S.currval)
338: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
339: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)
340: );
341: EXCEPTION
342: WHEN OTHERS THEN

Line 411: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)

407: 1 , p_comparision_operator_code,
408: p_pricing_attr_datatype, p_product_attr_datatype
409: --ENH Upgrade BOAPI for orig_sys...ref RAVI
410: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
411: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
412: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
413: );
414:
415:

Line 412: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)

408: p_pricing_attr_datatype, p_product_attr_datatype
409: --ENH Upgrade BOAPI for orig_sys...ref RAVI
410: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
411: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
412: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
413: );
414:
415:
416: /* SELECT QP_PRICING_ATTRIBUTES_S.currval

Line 493: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)

489: qp_number.number_to_canonical(p_pricing_attr_value_to), 1 ,
490: p_comparision_operator_code,p_pricing_attr_datatype, p_product_attr_datatype
491: --ENH Upgrade BOAPI for orig_sys...ref RAVI
492: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
493: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
494: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
495: );
496:
497: SELECT QP_PRICING_ATTRIBUTES_S.currval

Line 494: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)

490: p_comparision_operator_code,p_pricing_attr_datatype, p_product_attr_datatype
491: --ENH Upgrade BOAPI for orig_sys...ref RAVI
492: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
493: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
494: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
495: );
496:
497: SELECT QP_PRICING_ATTRIBUTES_S.currval
498: INTO x_pricing_attribute_id