APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 2063: select OE_ORDER_PRICE_ATTRIBS_S.nextval

2059: l_Header_Price_Att_rec.creation_date := SYSDATE;
2060: l_Header_Price_Att_rec.created_by := FND_GLOBAL.USER_ID;
2061: oe_debug_pub.add(' Before calling pattr_util.insert_row');
2062:
2063: select OE_ORDER_PRICE_ATTRIBS_S.nextval
2064: into l_header_price_att_rec.order_price_attrib_id
2065: from dual;
2066:
2067: OE_Header_PAttr_Util.Insert_Row (l_Header_Price_Att_rec);

Line 3200: select OE_ORDER_PRICE_ATTRIBS_S.nextval

3196: --BT
3197: --Added the If loop for Bug 3402434
3198: If(l_Line_price_att_rec.order_price_attrib_id is NULL or
3199: l_Line_price_att_rec.order_price_attrib_id=FND_API.G_MISS_NUM) THEN
3200: select OE_ORDER_PRICE_ATTRIBS_S.nextval
3201: into l_Line_price_att_rec.order_price_attrib_id
3202: from dual;
3203: End If;
3204: OE_Line_Pattr_Util.Insert_Row (l_Line_price_att_rec);

Line 4502: from oe_order_price_attribs a

4498: pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
4499: pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
4500: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
4501: ,Override_Flag
4502: from oe_order_price_attribs a
4503: where (a.line_id is null and a.header_id = p_header_id )
4504: union all
4505: select flex_title, pricing_context, pricing_attribute1,
4506: pricing_attribute2 , pricing_attribute3 , pricing_attribute4 , pricing_attribute5 ,

Line 4532: from oe_order_price_attribs a

4528: pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
4529: pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
4530: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
4531: ,Override_Flag
4532: from oe_order_price_attribs a
4533: where (p_line_id is not null and a.line_id = p_line_id )
4534: ;
4535: begin
4536: G_STMT_NO := 'Append_asked_for#10';

Line 5962: oe_order_price_attribs oopa

5958: l_header_id2:=nvl(p_header_id,l_line_tbl(line_tbl_index).header_id);
5959: Select 'x' into l_dummy from dual
5960: Where exists
5961: (select 'x' from
5962: oe_order_price_attribs oopa
5963: where
5964: nvl(oopa.line_id,l_Line_Tbl(line_Tbl_Index).line_id) = l_Line_Tbl(line_Tbl_Index).line_id
5965: and oopa.header_id = l_header_id2);
5966:

Line 6145: Select 'X' from oe_order_price_attribs oopa

6141: -- End of 3502454
6142:
6143: Select 'x' into l_dummy from dual
6144: where exists(
6145: Select 'X' from oe_order_price_attribs oopa
6146: where oopa.header_id = l_header_id2 and oopa.line_id is null);
6147:
6148: Append_asked_for(
6149: p_header_id => l_header_id2

Line 12791: oe_order_price_attribs oopa

12787:
12788: Select 'x' into l_dummy from dual
12789: Where exists
12790: (select 'x' from
12791: oe_order_price_attribs oopa
12792: where
12793: nvl(oopa.line_id,l_Line_Tbl(line_Tbl_Index).line_id) = l_Line_Tbl(line_Tbl_Index).line_id
12794: and oopa.header_id = l_header_id2);
12795:

Line 12894: Select 'X' from oe_order_price_attribs oopa

12890: END IF;
12891: -- End of 3502454
12892: Select 'x' into l_dummy from dual
12893: where exists(
12894: Select 'X' from oe_order_price_attribs oopa
12895: where oopa.header_id = l_header_id2 and oopa.line_id is null);
12896:
12897: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
12898: oe_order_price_pvt.Append_asked_for(