eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HEADER_PATTR_UTIL dependencies on OE_ORDER_PUB

Line 8: , x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Order_Header_PAttr';
5:
6: PROCEDURE Query_Row
7: ( p_order_price_attrib_id IN NUMBER
8: , x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
9: )
10: IS
11: l_Header_Price_Att_Tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
12:

Line 11: l_Header_Price_Att_Tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

7: ( p_order_price_attrib_id IN NUMBER
8: , x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
9: )
10: IS
11: l_Header_Price_Att_Tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
12:
13: --
14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: --

Line 31: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type

27: ( p_order_price_attrib_id IN NUMBER :=
28: FND_API.G_MISS_NUM
29: , p_header_id IN NUMBER :=
30: FND_API.G_MISS_NUM
31: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
32: )
33: IS
34: l_count NUMBER;
35:

Line 386: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

382: END Query_Rows;
383:
384: PROCEDURE Clear_Dependent_Attr
385: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
386: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
387: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
388: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
389: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
390: )

Line 387: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type

383:
384: PROCEDURE Clear_Dependent_Attr
385: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
386: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
387: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
388: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
389: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
390: )
391: IS

Line 388: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC

384: PROCEDURE Clear_Dependent_Attr
385: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
386: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
387: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
388: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
389: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
390: )
391: IS
392: l_index NUMBER := 0;

Line 389: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type

385: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
386: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
387: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
388: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
389: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
390: )
391: IS
392: l_index NUMBER := 0;
393: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 1593: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

1589: END Clear_Dependent_Attr;
1590:
1591:
1592: PROCEDURE Complete_Record
1593: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
1594: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
1595: )
1596: IS
1597: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;

Line 1594: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type

1590:
1591:
1592: PROCEDURE Complete_Record
1593: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
1594: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
1595: )
1596: IS
1597: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;
1598:

Line 1597: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;

1593: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
1594: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
1595: )
1596: IS
1597: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;
1598:
1599: --
1600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1601: --

Line 2137: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

2133: END Complete_Record;
2134:
2135:
2136: PROCEDURE Convert_Miss_To_Null
2137: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
2138: )
2139: IS
2140: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;
2141:

Line 2140: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;

2136: PROCEDURE Convert_Miss_To_Null
2137: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
2138: )
2139: IS
2140: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;
2141:
2142: --
2143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2144: --

Line 2677: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

2673: END Convert_Miss_To_Null;
2674:
2675:
2676: PROCEDURE Apply_Attribute_Changes
2677: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
2678: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
2679: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
2680: -- , x_Header_Price_Att_Rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
2681: )

Line 2678: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type

2674:
2675:
2676: PROCEDURE Apply_Attribute_Changes
2677: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
2678: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
2679: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
2680: -- , x_Header_Price_Att_Rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
2681: )
2682: IS

Line 2679: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC

2675:
2676: PROCEDURE Apply_Attribute_Changes
2677: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
2678: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
2679: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
2680: -- , x_Header_Price_Att_Rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
2681: )
2682: IS
2683: l_price_flag boolean := FALSE;

Line 2680: -- , x_Header_Price_Att_Rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type

2676: PROCEDURE Apply_Attribute_Changes
2677: ( p_x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
2678: , p_old_Header_Price_Att_Rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
2679: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
2680: -- , x_Header_Price_Att_Rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
2681: )
2682: IS
2683: l_price_flag boolean := FALSE;
2684: l_booked_flag Varchar2(1) := 'N';

Line 3575: ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

3571:
3572: END Delete_Row;
3573:
3574: PROCEDURE Insert_Row
3575: ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
3576: )
3577: IS
3578: l_lock_control NUMBER := 1;
3579:

Line 3880: ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

3876:
3877: END Insert_Row;
3878:
3879: PROCEDURE Update_Row
3880: ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
3881: )
3882: IS
3883: l_lock_control NUMBER;
3884:

Line 4064: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type

4060:
4061: PROCEDURE Lock_Row
4062: ( x_return_status OUT NOCOPY VARCHAR2
4063:
4064: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
4065: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4066: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
4067: )
4068: IS

Line 4066: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type

4062: ( x_return_status OUT NOCOPY VARCHAR2
4063:
4064: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
4065: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4066: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
4067: )
4068: IS
4069: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
4070: l_order_price_attrib_id NUMBER;

Line 4069: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;

4065: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4066: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
4067: )
4068: IS
4069: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
4070: l_order_price_attrib_id NUMBER;
4071: l_lock_control NUMBER;
4072:
4073: --

Line 4216: , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type

4212: ( p_order_price_attrib_id IN NUMBER
4213: := FND_API.G_MISS_NUM
4214: , p_header_id IN NUMBER
4215: := FND_API.G_MISS_NUM
4216: , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
4217: , x_return_status OUT NOCOPY VARCHAR2
4218:
4219: )
4220: IS

Line 4228: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

4224: FROM oe_order_price_attribs
4225: WHERE header_id = p_header_id
4226: FOR UPDATE NOWAIT;
4227:
4228: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4229: l_order_price_attrib_id NUMBER;
4230: l_lock_control NUMBER;
4231:
4232: --