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_LIST_UTIL dependencies on OE_PRICE_LIST_PUB

Line 12: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_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_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
13: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
16: )

Line 13: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
13: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
16: )
17: IS

Line 14: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
13: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
13: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 372: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

368:
369: -- Procedure Apply_Attribute_Changes
370:
371: PROCEDURE Apply_Attribute_Changes
372: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
373: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
374: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
375: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
376: )

Line 373: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

369: -- Procedure Apply_Attribute_Changes
370:
371: PROCEDURE Apply_Attribute_Changes
372: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
373: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
374: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
375: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
376: )
377: IS

Line 374: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

370:
371: PROCEDURE Apply_Attribute_Changes
372: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
373: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
374: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
375: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
376: )
377: IS
378: BEGIN

Line 375: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

371: PROCEDURE Apply_Attribute_Changes
372: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
373: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
374: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
375: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
376: )
377: IS
378: BEGIN
379:

Line 574: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

570:
571: -- Function Complete_Record
572:
573: FUNCTION Complete_Record
574: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
575: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
576: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
577: IS
578: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

Line 575: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

571: -- Function Complete_Record
572:
573: FUNCTION Complete_Record
574: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
575: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
576: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
577: IS
578: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
579: BEGIN

Line 576: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type

572:
573: FUNCTION Complete_Record
574: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
575: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
576: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
577: IS
578: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
579: BEGIN
580:

Line 578: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

574: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
575: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
576: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
577: IS
578: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
579: BEGIN
580:
581: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
582: l_PRICE_LIST_rec.attribute1 := p_old_PRICE_LIST_rec.attribute1;

Line 736: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

732:
733: -- Function Convert_Miss_To_Null
734:
735: FUNCTION Convert_Miss_To_Null
736: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
737: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
738: IS
739: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
740: BEGIN

Line 737: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type

733: -- Function Convert_Miss_To_Null
734:
735: FUNCTION Convert_Miss_To_Null
736: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
737: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
738: IS
739: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
740: BEGIN
741:

Line 739: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

735: FUNCTION Convert_Miss_To_Null
736: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
737: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
738: IS
739: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
740: BEGIN
741:
742: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
743: l_PRICE_LIST_rec.attribute1 := NULL;

Line 897: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

893:
894: -- Procedure Update_Row
895:
896: PROCEDURE Update_Row
897: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
898: )
899: IS
900: l_sec_price_list_id number;
901: l_context varchar2(30);

Line 1017: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

1013:
1014: -- Procedure Insert_Row
1015:
1016: PROCEDURE Insert_Row
1017: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1018: )
1019: IS
1020: -- new added
1021: -- cursor not added to get rowid

Line 1374: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type

1370:
1371: FUNCTION Query_Row
1372: ( p_name IN VARCHAR2
1373: , p_price_list_id IN NUMBER
1374: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
1375: IS
1376: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1377: BEGIN
1378:

Line 1376: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;

1372: ( p_name IN VARCHAR2
1373: , p_price_list_id IN NUMBER
1374: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
1375: IS
1376: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1377: BEGIN
1378:
1379: SELECT ATTRIBUTE1
1380: , ATTRIBUTE10

Line 1481: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

1477: --
1478:
1479: PROCEDURE Lock_Row
1480: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1481: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1482: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1483: )
1484: IS
1485: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1482: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

1478:
1479: PROCEDURE Lock_Row
1480: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1481: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1482: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1483: )
1484: IS
1485: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1486: BEGIN

Line 1485: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;

1481: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1482: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1483: )
1484: IS
1485: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1486: BEGIN
1487:
1488: QP_LIST_HEADERS_PKG.LOCK_ROW (
1489: X_LIST_HEADER_ID => p_PRICE_LIST_rec.price_list_id,

Line 1565: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

1561:
1562: -- Function Get_Values
1563:
1564: FUNCTION Get_Values
1565: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1566: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1567: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
1568: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type
1569: IS

Line 1566: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

1562: -- Function Get_Values
1563:
1564: FUNCTION Get_Values
1565: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1566: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1567: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
1568: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type
1569: IS
1570: l_PRICE_LIST_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;

Line 1567: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

1563:
1564: FUNCTION Get_Values
1565: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1566: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1567: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
1568: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type
1569: IS
1570: l_PRICE_LIST_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
1571: BEGIN

Line 1568: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type

1564: FUNCTION Get_Values
1565: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1566: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1567: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
1568: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type
1569: IS
1570: l_PRICE_LIST_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
1571: BEGIN
1572:

Line 1570: l_PRICE_LIST_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;

1566: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1567: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
1568: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type
1569: IS
1570: l_PRICE_LIST_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
1571: BEGIN
1572:
1573: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
1574: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND

Line 1646: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

1642:
1643: -- Function Get_Ids
1644:
1645: FUNCTION Get_Ids
1646: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1647: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
1648: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
1649: IS
1650: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1647: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type

1643: -- Function Get_Ids
1644:
1645: FUNCTION Get_Ids
1646: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1647: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
1648: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
1649: IS
1650: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1651: BEGIN

Line 1648: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type

1644:
1645: FUNCTION Get_Ids
1646: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1647: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
1648: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
1649: IS
1650: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1651: BEGIN
1652:

Line 1650: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;

1646: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1647: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
1648: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type
1649: IS
1650: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1651: BEGIN
1652:
1653: -- initialize return_status.
1654: