APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 235: from qp_pricing_attributes qppa

231: begin
232: /*
233: select count(*)
234: into l_already_exists
235: from qp_pricing_attributes qppa
236: where qppa.pricing_phase_id = 1
237: and qppa.qualification_ind in (4,6,20,22)
238: and qppa.product_attribute_context = 'ITEM'
239: and qppa.product_attr_value = l_item_tbl(l_index)

Line 249: from qp_pricing_attributes qppa

245: Into l_already_exists
246: From Dual
247: Where Exists
248: (Select Null
249: from qp_pricing_attributes qppa
250: where qppa.list_header_id = p_price_list_id
251: and qppa.pricing_phase_id = 1
252: and qppa.product_attribute_context = 'ITEM'
253: and qppa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 510: into qp_pricing_attributes

506: ,l_list_line_id
507: ,l_orig_sys_header_ref); -- 10185331
508:
509: insert
510: into qp_pricing_attributes
511: (pricing_attribute_id,
512: creation_date,
513: created_by,
514: last_update_date,

Line 537: values (qp_pricing_attributes_s.nextval,

533: attribute_grouping_no
534: -- Bug 5202021 RAVI
535: ,ORIG_SYS_PRICING_ATTR_REF
536: ,ORIG_SYS_HEADER_REF) -- 10185331
537: values (qp_pricing_attributes_s.nextval,
538: sysdate, -- Bug No: 7281484
539: l_user_id,
540: sysdate, -- Bug No: 7281484
541: l_user_id,

Line 561: ,qp_pricing_attributes_s.CURRVAL

557: 'N',
558: 'BETWEEN', --2814272
559: l_attr_grp_s
560: -- Bug 5202021 RAVI
561: ,qp_pricing_attributes_s.CURRVAL
562: ,l_orig_sys_header_ref); -- 10185331
563:
564: END IF;
565:

Line 582: from qp_pricing_attributes qppa

578: begin
579: /*
580: select count(*)
581: into l_already_exists
582: from qp_pricing_attributes qppa
583: where qppa.list_header_id = p_price_list_id
584: and qppa.pricing_phase_id = 1
585: and qppa.product_attribute_context = 'ITEM'
586: and qppa.product_attr_value = l_item_tbl(l_index);

Line 594: from qp_pricing_attributes qppa

590: Into l_already_exists
591: From Dual
592: Where Exists
593: (Select Null
594: from qp_pricing_attributes qppa
595: where qppa.list_header_id = p_price_list_id
596: and qppa.pricing_phase_id = 1
597: and qppa.product_attribute_context = 'ITEM'
598: and qppa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 691: into qp_pricing_attributes

687: +-----------------------------------------------------------------------*/
688:
689:
690: insert
691: into qp_pricing_attributes
692: (PRICING_ATTRIBUTE_ID,
693: CREATION_DATE,
694: CREATED_BY,
695: LAST_UPDATE_DATE,

Line 718: values (qp_pricing_attributes_s.nextval,

714: ATTRIBUTE_GROUPING_NO
715: -- Bug 5202021 RAVI
716: ,ORIG_SYS_PRICING_ATTR_REF
717: ,ORIG_SYS_HEADER_REF) -- 10185331
718: values (qp_pricing_attributes_s.nextval,
719: sysdate, -- Bug No: 7281484
720: l_user_id,
721: sysdate, -- Bug No: 7281484
722: l_user_id,

Line 742: ,qp_pricing_attributes_s.CURRVAL

738: 'N',
739: 'BETWEEN', --2814272
740: l_attr_grp_s
741: -- Bug 5202021 RAVI
742: ,qp_pricing_attributes_s.CURRVAL
743: ,l_orig_sys_header_ref); -- 10185331
744:
745: END IF;
746: