APPS.OE_ORDER_PRICE_PVT dependencies on OE_PRICE_ADJ_ATTRIBS

Line 3638: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = p_adj_id_tbl(i);

3634: --END IF;
3635: END IF;
3636:
3637: FORALL i IN p_adj_id_tbl.FIRST..p_adj_id_tbl.LAST
3638: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = p_adj_id_tbl(i);
3639: IF l_debug_level > 0 THEN
3640: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ATTRIBS' , 3 ) ;
3641: END IF;
3642:

Line 4716: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)

4712:
4713: If l_adj_id_tbl.count > 0 Then
4714: l_stmt:=9;
4715: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4716: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)
4717: AND ( pricing_context
4718: , pricing_attribute
4719: , pricing_attr_value_from
4720: , pricing_attr_value_to)

Line 4746: INSERT INTO OE_PRICE_ADJ_ATTRIBS

4742: oe_debug_pub.add( 'DELETED '||SQL%ROWCOUNT||' ATTRIBUTES' ) ;
4743: END IF;
4744: l_stmt:=10;
4745: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4746: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4747: ( PRICE_ADJUSTMENT_ID
4748: ,PRICING_CONTEXT
4749: ,PRICING_ATTRIBUTE
4750: ,CREATION_DATE

Line 4785: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

4781: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
4782: ,decode(QPLAT.ATTRIBUTE_TYPE,
4783: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4784: 'QP_ATTR_DEFNS_PRICING')
4785: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4786: ,1
4787: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4788: -- , QP_LDETS_v LDETS
4789: -- , OE_PRICE_ADJUSTMENTS ADJ

Line 4807: FROM OE_PRICE_ADJ_ATTRIBS

4803: not in (select pricing_context
4804: , pricing_attribute
4805: , pricing_attr_value_from
4806: , pricing_attr_value_to
4807: FROM OE_PRICE_ADJ_ATTRIBS
4808: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4809: ));
4810: IF l_debug_level > 0 THEN
4811: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' CHANGED ATTRIBS' ) ;

Line 4824: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)

4820: fetch del_attribs2 Bulk Collect into l_adj_id_tbl, l_line_detail_index_tbl;
4821:
4822: If l_adj_id_tbl.count > 0 Then
4823: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4824: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)
4825: AND ( pricing_context
4826: , pricing_attribute
4827: , pricing_attr_value_from
4828: , pricing_attr_value_to)

Line 4852: INSERT INTO OE_PRICE_ADJ_ATTRIBS

4848: oe_debug_pub.add( 'DELETED '||SQL%ROWCOUNT||'ORDER ADJ LEVEL ATTRIBUTES' ) ;
4849: END IF;
4850: l_stmt:=12;
4851: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4852: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4853: ( PRICE_ADJUSTMENT_ID
4854: ,PRICING_CONTEXT
4855: ,PRICING_ATTRIBUTE
4856: ,CREATION_DATE

Line 4891: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

4887: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
4888: ,decode(QPLAT.ATTRIBUTE_TYPE,
4889: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4890: 'QP_ATTR_DEFNS_PRICING')
4891: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4892: ,1
4893: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4894: --, QP_LDETS_v LDETS
4895: --, OE_PRICE_ADJUSTMENTS ADJ

Line 4914: FROM OE_PRICE_ADJ_ATTRIBS

4910: not in (select pricing_context
4911: , pricing_attribute
4912: , pricing_attr_value_from
4913: , pricing_attr_value_to
4914: FROM OE_PRICE_ADJ_ATTRIBS
4915: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4916: ));
4917: End If;
4918: close del_attribs2;

Line 4921: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs

4917: End If;
4918: close del_attribs2;
4919: l_stmt:=13;
4920: /* Delete price_adj_attribs for order level adj*/
4921: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs
4922: WHERE exists
4923: (Select ADJ.PRICE_ADJUSTMENT_ID
4924: From QP_LDETS_V LDETS
4925: ,OE_PRICE_ADJUSTMENTS ADJ

Line 4934: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs

4930: AND QPLINES.LINE_ID = ADJ.HEADER_ID
4931: AND ADJ.price_adjustment_id = adjattrs.price_adjustment_id);*/
4932:
4933: /* Delete price_adj_attribs for line level adj*/
4934: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs
4935: WHERE exists
4936: (Select ADJ.PRICE_ADJUSTMENT_ID
4937: From QP_LDETS_V LDETS
4938: ,OE_PRICE_ADJUSTMENTS ADJ

Line 4947: INSERT INTO OE_PRICE_ADJ_ATTRIBS

4943: AND QPLINES.LINE_TYPE_CODE = 'LINE'
4944: AND ADJ.price_adjustment_id = adjattrs.price_adjustment_id);*/
4945:
4946: /* insert header level adjustment attributes */
4947: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4948: ( PRICE_ADJUSTMENT_ID
4949: ,PRICING_CONTEXT
4950: ,PRICING_ATTRIBUTE
4951: ,CREATION_DATE

Line 4985: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

4981: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
4982: ,decode(QPLAT.ATTRIBUTE_TYPE,
4983: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4984: 'QP_ATTR_DEFNS_PRICING')
4985: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4986: ,1
4987: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4988: , QP_LDETS_v LDETS
4989: , OE_PRICE_ADJUSTMENTS ADJ

Line 5006: INSERT INTO OE_PRICE_ADJ_ATTRIBS

5002: );
5003: l_stmt:=14;
5004: --13582129 Start
5005: /*
5006: INSERT INTO OE_PRICE_ADJ_ATTRIBS
5007: ( PRICE_ADJUSTMENT_ID
5008: ,PRICING_CONTEXT
5009: ,PRICING_ATTRIBUTE
5010: ,CREATION_DATE

Line 5044: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

5040: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
5041: ,decode(QPLAT.ATTRIBUTE_TYPE,
5042: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
5043: 'QP_ATTR_DEFNS_PRICING')
5044: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
5045: ,1
5046: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5047: , QP_LDETS_v LDETS
5048: , OE_PRICE_ADJUSTMENTS ADJ

Line 5065: INSERT INTO OE_PRICE_ADJ_ATTRIBS

5061: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5062: AND QPLINE.PROCESS_STATUS <> 'NOT_VALID'
5063: );
5064: */
5065: INSERT INTO OE_PRICE_ADJ_ATTRIBS
5066: ( PRICE_ADJUSTMENT_ID
5067: ,PRICING_CONTEXT
5068: ,PRICING_ATTRIBUTE
5069: ,CREATION_DATE

Line 5104: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

5100: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
5101: ,decode(QPLAT.ATTRIBUTE_TYPE,
5102: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
5103: 'QP_ATTR_DEFNS_PRICING')
5104: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
5105: ,1
5106: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5107: , QP_PREQ_LDETS_TMP LDETS
5108: , OE_PRICE_ADJUSTMENTS ADJ