APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 2146: select OE_ORDER_PRICE_ATTRIBS_S.nextval

2142: l_Header_Price_Att_rec.creation_date := SYSDATE;
2143: l_Header_Price_Att_rec.created_by := FND_GLOBAL.USER_ID;
2144: oe_debug_pub.add(' Before calling pattr_util.insert_row');
2145:
2146: select OE_ORDER_PRICE_ATTRIBS_S.nextval
2147: into l_header_price_att_rec.order_price_attrib_id
2148: from dual;
2149:
2150: OE_Header_PAttr_Util.Insert_Row (l_Header_Price_Att_rec);

Line 3283: select OE_ORDER_PRICE_ATTRIBS_S.nextval

3279: --BT
3280: --Added the If loop for Bug 3402434
3281: If(l_Line_price_att_rec.order_price_attrib_id is NULL or
3282: l_Line_price_att_rec.order_price_attrib_id=FND_API.G_MISS_NUM) THEN
3283: select OE_ORDER_PRICE_ATTRIBS_S.nextval
3284: into l_Line_price_att_rec.order_price_attrib_id
3285: from dual;
3286: End If;
3287: OE_Line_Pattr_Util.Insert_Row (l_Line_price_att_rec);

Line 4585: from oe_order_price_attribs a

4581: pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
4582: pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
4583: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
4584: ,Override_Flag
4585: from oe_order_price_attribs a
4586: where (a.line_id is null and a.header_id = p_header_id )
4587: union all
4588: select flex_title, pricing_context, pricing_attribute1,
4589: pricing_attribute2 , pricing_attribute3 , pricing_attribute4 , pricing_attribute5 ,

Line 4615: from oe_order_price_attribs a

4611: pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
4612: pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
4613: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
4614: ,Override_Flag
4615: from oe_order_price_attribs a
4616: where (p_line_id is not null and a.line_id = p_line_id )
4617: ;
4618: begin
4619: G_STMT_NO := 'Append_asked_for#10';

Line 6053: oe_order_price_attribs oopa

6049: l_header_id2:=nvl(p_header_id,l_line_tbl(line_tbl_index).header_id);
6050: Select 'x' into l_dummy from dual
6051: Where exists
6052: (select 'x' from
6053: oe_order_price_attribs oopa
6054: where
6055: nvl(oopa.line_id,l_Line_Tbl(line_Tbl_Index).line_id) = l_Line_Tbl(line_Tbl_Index).line_id
6056: and oopa.header_id = l_header_id2);
6057:

Line 6236: Select 'X' from oe_order_price_attribs oopa

6232: -- End of 3502454
6233:
6234: Select 'x' into l_dummy from dual
6235: where exists(
6236: Select 'X' from oe_order_price_attribs oopa
6237: where oopa.header_id = l_header_id2 and oopa.line_id is null);
6238:
6239: Append_asked_for(
6240: p_header_id => l_header_id2

Line 12965: oe_order_price_attribs oopa

12961:
12962: Select 'x' into l_dummy from dual
12963: Where exists
12964: (select 'x' from
12965: oe_order_price_attribs oopa
12966: where
12967: nvl(oopa.line_id,l_Line_Tbl(line_Tbl_Index).line_id) = l_Line_Tbl(line_Tbl_Index).line_id
12968: and oopa.header_id = l_header_id2);
12969:

Line 13068: Select 'X' from oe_order_price_attribs oopa

13064: END IF;
13065: -- End of 3502454
13066: Select 'x' into l_dummy from dual
13067: where exists(
13068: Select 'X' from oe_order_price_attribs oopa
13069: where oopa.header_id = l_header_id2 and oopa.line_id is null);
13070:
13071: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
13072: oe_order_price_pvt.Append_asked_for(