APPS.QP_MODIFIER_UPGRADE_UTIL_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 381: INSERT INTO QP_PRICING_ATTRIBUTES

377: err_msg VARCHAR2(100);
378:
379: BEGIN
380:
381: INSERT INTO QP_PRICING_ATTRIBUTES
382: (PRICING_ATTRIBUTE_ID, CREATION_DATE, CREATED_BY,
383: LAST_UPDATE_DATE, LAST_UPDATED_BY,LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
384: PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, LIST_LINE_ID, EXCLUDER_FLAG,
385: ACCUMULATE_FLAG, PRODUCT_ATTRIBUTE_CONTEXT,PRODUCT_ATTRIBUTE,

Line 395: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,

391: ,ORIG_SYS_PRICING_ATTR_REF
392: ,ORIG_SYS_LINE_REF
393: ,ORIG_SYS_HEADER_REF)
394: VALUES (
395: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,
396: p_last_update_date, p_last_updated_by, p_last_update_login, p_program_application_id,
397: p_program_id, p_program_update_date, p_request_id, p_list_line_id, p_excluder_flag,
398: p_accumulate_flag, p_product_attribute_context, p_product_attribute,
399: p_product_attr_value, p_product_uom_code, p_pricing_attribute_context,

Line 404: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)

400: p_pricing_attribute, p_pricing_attr_value_from, p_pricing_attr_value_to,
401: 1 , p_comparision_operator_code,
402: p_pricing_attr_datatype, p_product_attr_datatype
403: --ENH Upgrade BOAPI for orig_sys...ref RAVI
404: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
405: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
406: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
407: );
408:

Line 410: /* SELECT QP_PRICING_ATTRIBUTES_S.currval

406: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
407: );
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:

Line 463: INSERT INTO QP_PRICING_ATTRIBUTES

459: err_msg VARCHAR2(100);
460:
461: BEGIN
462:
463: INSERT INTO QP_PRICING_ATTRIBUTES
464: (PRICING_ATTRIBUTE_ID, CREATION_DATE, CREATED_BY,
465: LAST_UPDATE_DATE, LAST_UPDATED_BY,LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
466: PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, LIST_LINE_ID, EXCLUDER_FLAG,
467: ACCUMULATE_FLAG, PRODUCT_ATTRIBUTE_CONTEXT,PRODUCT_ATTRIBUTE,

Line 477: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,

473: ,ORIG_SYS_PRICING_ATTR_REF
474: ,ORIG_SYS_LINE_REF
475: ,ORIG_SYS_HEADER_REF)
476: VALUES (
477: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,
478: p_last_update_date, p_last_updated_by, p_last_update_login, p_program_application_id,
479: p_program_id, p_program_update_date, p_request_id, p_list_line_id, p_excluder_flag,
480: p_accumulate_flag, p_product_attribute_context, p_product_attribute,
481: p_product_attr_value, p_product_uom_code, p_pricing_attribute_context,

Line 486: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)

482: p_pricing_attribute, qp_number.number_to_canonical(p_pricing_attr_value_from),
483: qp_number.number_to_canonical(p_pricing_attr_value_to), 1 ,
484: p_comparision_operator_code,p_pricing_attr_datatype, p_product_attr_datatype
485: --ENH Upgrade BOAPI for orig_sys...ref RAVI
486: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
487: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
488: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
489: );
490:

Line 491: SELECT QP_PRICING_ATTRIBUTES_S.currval

487: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
488: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
489: );
490:
491: SELECT QP_PRICING_ATTRIBUTES_S.currval
492: INTO x_pricing_attribute_id
493: FROM DUAL;
494:
495: