APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 211: from qp_pricing_attributes qppa

207: begin
208: /*
209: select count(*)
210: into l_already_exists
211: from qp_pricing_attributes qppa
212: where qppa.pricing_phase_id = 1
213: and qppa.qualification_ind in (4,6,20,22)
214: and qppa.product_attribute_context = 'ITEM'
215: and qppa.product_attr_value = l_item_tbl(l_index)

Line 225: from qp_pricing_attributes qppa

221: Into l_already_exists
222: From Dual
223: Where Exists
224: (Select Null
225: from qp_pricing_attributes qppa
226: where qppa.list_header_id = p_price_list_id
227: and qppa.pricing_phase_id = 1
228: and qppa.product_attribute_context = 'ITEM'
229: and qppa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 387: into qp_pricing_attributes

383: -- Bug 5202021 RAVI
384: ,l_list_line_id);
385:
386: insert
387: into qp_pricing_attributes
388: (pricing_attribute_id,
389: creation_date,
390: created_by,
391: last_update_date,

Line 413: values (qp_pricing_attributes_s.nextval,

409: comparison_operator_code, --2814272
410: attribute_grouping_no
411: -- Bug 5202021 RAVI
412: ,ORIG_SYS_PRICING_ATTR_REF)
413: values (qp_pricing_attributes_s.nextval,
414: sysdate, -- Bug No: 7281484
415: l_user_id,
416: sysdate, -- Bug No: 7281484
417: l_user_id,

Line 437: ,qp_pricing_attributes_s.currval);

433: 'N',
434: 'BETWEEN', --2814272
435: l_attr_grp_s
436: -- Bug 5202021 RAVI
437: ,qp_pricing_attributes_s.currval);
438:
439: END IF;
440:
441: l_index := l_item_tbl.NEXT(l_index);

Line 457: from qp_pricing_attributes qppa

453: begin
454: /*
455: select count(*)
456: into l_already_exists
457: from qp_pricing_attributes qppa
458: where qppa.list_header_id = p_price_list_id
459: and qppa.pricing_phase_id = 1
460: and qppa.product_attribute_context = 'ITEM'
461: and qppa.product_attr_value = l_item_tbl(l_index);

Line 469: from qp_pricing_attributes qppa

465: Into l_already_exists
466: From Dual
467: Where Exists
468: (Select Null
469: from qp_pricing_attributes qppa
470: where qppa.list_header_id = p_price_list_id
471: and qppa.pricing_phase_id = 1
472: and qppa.product_attribute_context = 'ITEM'
473: and qppa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 559: into qp_pricing_attributes

555: +-----------------------------------------------------------------------*/
556:
557:
558: insert
559: into qp_pricing_attributes
560: (PRICING_ATTRIBUTE_ID,
561: CREATION_DATE,
562: CREATED_BY,
563: LAST_UPDATE_DATE,

Line 585: values (qp_pricing_attributes_s.nextval,

581: comparison_operator_code, --2814272
582: ATTRIBUTE_GROUPING_NO
583: -- Bug 5202021 RAVI
584: ,ORIG_SYS_PRICING_ATTR_REF)
585: values (qp_pricing_attributes_s.nextval,
586: sysdate, -- Bug No: 7281484
587: l_user_id,
588: sysdate, -- Bug No: 7281484
589: l_user_id,

Line 609: ,qp_pricing_attributes_s.currval);

605: 'N',
606: 'BETWEEN', --2814272
607: l_attr_grp_s
608: -- Bug 5202021 RAVI
609: ,qp_pricing_attributes_s.currval);
610:
611: END IF;
612:
613: l_index := l_item_tbl.NEXT(l_index);