APPS.QP_MODIFIER_UPGRADE_UTIL_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 387: INSERT INTO QP_PRICING_ATTRIBUTES

383: err_msg VARCHAR2(100);
384:
385: BEGIN
386:
387: INSERT INTO QP_PRICING_ATTRIBUTES
388: (PRICING_ATTRIBUTE_ID, CREATION_DATE, CREATED_BY,
389: LAST_UPDATE_DATE, LAST_UPDATED_BY,LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
390: PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, LIST_LINE_ID, EXCLUDER_FLAG,
391: ACCUMULATE_FLAG, PRODUCT_ATTRIBUTE_CONTEXT,PRODUCT_ATTRIBUTE,

Line 401: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,

397: ,ORIG_SYS_PRICING_ATTR_REF
398: ,ORIG_SYS_LINE_REF
399: ,ORIG_SYS_HEADER_REF)
400: VALUES (
401: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,
402: p_last_update_date, p_last_updated_by, p_last_update_login, p_program_application_id,
403: p_program_id, p_program_update_date, p_request_id, p_list_line_id, p_excluder_flag,
404: p_accumulate_flag, p_product_attribute_context, p_product_attribute,
405: p_product_attr_value, p_product_uom_code, p_pricing_attribute_context,

Line 410: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)

406: p_pricing_attribute, p_pricing_attr_value_from, p_pricing_attr_value_to,
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:

Line 416: /* SELECT QP_PRICING_ATTRIBUTES_S.currval

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
417: INTO x_pricing_attribute_id
418: FROM DUAL; */
419: x_pricing_attribute_id :=1;
420:

Line 469: INSERT INTO QP_PRICING_ATTRIBUTES

465: err_msg VARCHAR2(100);
466:
467: BEGIN
468:
469: INSERT INTO QP_PRICING_ATTRIBUTES
470: (PRICING_ATTRIBUTE_ID, CREATION_DATE, CREATED_BY,
471: LAST_UPDATE_DATE, LAST_UPDATED_BY,LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
472: PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, LIST_LINE_ID, EXCLUDER_FLAG,
473: ACCUMULATE_FLAG, PRODUCT_ATTRIBUTE_CONTEXT,PRODUCT_ATTRIBUTE,

Line 483: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,

479: ,ORIG_SYS_PRICING_ATTR_REF
480: ,ORIG_SYS_LINE_REF
481: ,ORIG_SYS_HEADER_REF)
482: VALUES (
483: QP_PRICING_ATTRIBUTES_S.nextval,p_creation_date, p_created_by,
484: p_last_update_date, p_last_updated_by, p_last_update_login, p_program_application_id,
485: p_program_id, p_program_update_date, p_request_id, p_list_line_id, p_excluder_flag,
486: p_accumulate_flag, p_product_attribute_context, p_product_attribute,
487: p_product_attr_value, p_product_uom_code, p_pricing_attribute_context,

Line 492: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)

488: p_pricing_attribute, qp_number.number_to_canonical(p_pricing_attr_value_from),
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:

Line 497: SELECT 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
499: FROM DUAL;
500:
501: