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_PRICE_BREAK_UTIL dependencies on OE_PRICING_CONT_PUB

Line 12: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
13: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
15: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
16: )

Line 13: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
13: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
15: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
16: )
17: IS

Line 14: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
13: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
15: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
16: )
17: IS
18: BEGIN

Line 15: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
13: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
15: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
16: )
17: IS
18: BEGIN
19:

Line 281: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

277:
278: -- Procedure Apply_Attribute_Changes
279:
280: PROCEDURE Apply_Attribute_Changes
281: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
282: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
283: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
284: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
285: )

Line 282: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=

278: -- Procedure Apply_Attribute_Changes
279:
280: PROCEDURE Apply_Attribute_Changes
281: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
282: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
283: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
284: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
285: )
286: IS

Line 283: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC

279:
280: PROCEDURE Apply_Attribute_Changes
281: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
282: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
283: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
284: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
285: )
286: IS
287: BEGIN

Line 284: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type

280: PROCEDURE Apply_Attribute_Changes
281: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
282: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
283: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
284: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
285: )
286: IS
287: BEGIN
288:

Line 473: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

469:
470: -- Function Complete_Record
471:
472: FUNCTION Complete_Record
473: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
474: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
475: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
476: IS
477: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;

Line 474: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

470: -- Function Complete_Record
471:
472: FUNCTION Complete_Record
473: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
474: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
475: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
476: IS
477: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
478: BEGIN

Line 475: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

471:
472: FUNCTION Complete_Record
473: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
474: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
475: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
476: IS
477: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
478: BEGIN
479:

Line 477: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;

473: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
474: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
475: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
476: IS
477: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
478: BEGIN
479:
480: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN
481: l_Price_Break_rec.amount := p_old_Price_Break_rec.amount;

Line 627: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

623:
624: -- Function Convert_Miss_To_Null
625:
626: FUNCTION Convert_Miss_To_Null
627: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
628: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
629: IS
630: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
631: BEGIN

Line 628: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

624: -- Function Convert_Miss_To_Null
625:
626: FUNCTION Convert_Miss_To_Null
627: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
628: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
629: IS
630: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
631: BEGIN
632:

Line 630: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;

626: FUNCTION Convert_Miss_To_Null
627: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
628: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
629: IS
630: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
631: BEGIN
632:
633: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN
634: l_Price_Break_rec.amount := NULL;

Line 780: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

776:
777: -- Procedure Update_Row
778:
779: PROCEDURE Update_Row
780: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
781: )
782: IS
783: BEGIN
784:

Line 846: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

842:
843: -- Procedure Insert_Row
844:
845: PROCEDURE Insert_Row
846: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
847: )
848: IS
849: BEGIN
850:

Line 983: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

979: ( p_discount_line_id IN NUMBER
980: , p_method_type_code IN VARCHAR2
981: , p_price_break_high IN NUMBER
982: , p_price_break_low IN NUMBER
983: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
984: IS
985: BEGIN
986:
987: RETURN Query_Rows

Line 1009: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

1005: , p_price_break_high IN NUMBER :=
1006: FND_API.G_MISS_NUM
1007: , p_price_break_low IN NUMBER :=
1008: FND_API.G_MISS_NUM
1009: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1010: IS
1011: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1012: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1013:

Line 1011: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1007: , p_price_break_low IN NUMBER :=
1008: FND_API.G_MISS_NUM
1009: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1010: IS
1011: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1012: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1013:
1014: CURSOR l_Price_Break_csr IS
1015: SELECT AMOUNT

Line 1012: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1008: FND_API.G_MISS_NUM
1009: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1010: IS
1011: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1012: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1013:
1014: CURSOR l_Price_Break_csr IS
1015: SELECT AMOUNT
1016: , ATTRIBUTE1

Line 1196: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

1192: --
1193:
1194: PROCEDURE Lock_Row
1195: ( x_return_status OUT VARCHAR2
1196: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1197: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1198: )
1199: IS
1200: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1197: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type

1193:
1194: PROCEDURE Lock_Row
1195: ( x_return_status OUT VARCHAR2
1196: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1197: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1198: )
1199: IS
1200: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1201: BEGIN

Line 1200: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1196: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1197: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1198: )
1199: IS
1200: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1201: BEGIN
1202:
1203: SELECT AMOUNT
1204: , ATTRIBUTE1

Line 1529: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

1525:
1526: -- Function Get_Values
1527:
1528: FUNCTION Get_Values
1529: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1530: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
1531: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
1532: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1533: IS

Line 1530: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=

1526: -- Function Get_Values
1527:
1528: FUNCTION Get_Values
1529: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1530: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
1531: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
1532: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1533: IS
1534: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;

Line 1531: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC

1527:
1528: FUNCTION Get_Values
1529: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1530: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
1531: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
1532: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1533: IS
1534: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
1535: BEGIN

Line 1532: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type

1528: FUNCTION Get_Values
1529: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1530: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
1531: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
1532: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1533: IS
1534: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
1535: BEGIN
1536: /*

Line 1534: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;

1530: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
1531: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
1532: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1533: IS
1534: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
1535: BEGIN
1536: /*
1537: IF p_Price_Break_rec.discount_line_id IS NOT NULL AND
1538: p_Price_Break_rec.discount_line_id <> FND_API.G_MISS_NUM AND

Line 1574: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

1570:
1571: -- Function Get_Ids
1572:
1573: FUNCTION Get_Ids
1574: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1575: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1576: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1577: IS
1578: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1575: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type

1571: -- Function Get_Ids
1572:
1573: FUNCTION Get_Ids
1574: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1575: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1576: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1577: IS
1578: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1579: BEGIN

Line 1576: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

1572:
1573: FUNCTION Get_Ids
1574: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1575: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1576: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1577: IS
1578: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1579: BEGIN
1580:

Line 1578: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1574: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1575: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
1576: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1577: IS
1578: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1579: BEGIN
1580:
1581: -- initialize return_status.
1582: