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.QP_CURR_LISTS_UTIL dependencies on QP_CURRENCY_PUB

Line 12: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
13: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
16: )

Line 13: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
13: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
16: )
17: IS

Line 14: QP_Currency_PUB.G_MISS_CURR_LISTS_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
13: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
13: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 352: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

348:
349: -- Procedure Apply_Attribute_Changes
350:
351: PROCEDURE Apply_Attribute_Changes
352: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
353: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
354: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
355: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
356: )

Line 353: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=

349: -- Procedure Apply_Attribute_Changes
350:
351: PROCEDURE Apply_Attribute_Changes
352: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
353: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
354: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
355: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
356: )
357: IS

Line 354: QP_Currency_PUB.G_MISS_CURR_LISTS_REC

350:
351: PROCEDURE Apply_Attribute_Changes
352: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
353: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
354: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
355: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
356: )
357: IS
358: l_dummy_c VARCHAR2(1);

Line 355: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

351: PROCEDURE Apply_Attribute_Changes
352: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
353: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
354: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
355: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
356: )
357: IS
358: l_dummy_c VARCHAR2(1);
359: list_already_attached EXCEPTION;

Line 598: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

594:
595: -- Function Complete_Record
596:
597: FUNCTION Complete_Record
598: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
599: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
600: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
601: IS
602: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;

Line 599: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

595: -- Function Complete_Record
596:
597: FUNCTION Complete_Record
598: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
599: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
600: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
601: IS
602: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
603: BEGIN

Line 600: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type

596:
597: FUNCTION Complete_Record
598: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
599: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
600: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
601: IS
602: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
603: BEGIN
604:

Line 602: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;

598: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
599: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
600: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
601: IS
602: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
603: BEGIN
604:
605: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
606: l_CURR_LISTS_rec.attribute1 := p_old_CURR_LISTS_rec.attribute1;

Line 752: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

748:
749: -- Function Convert_Miss_To_Null
750:
751: FUNCTION Convert_Miss_To_Null
752: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
753: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
754: IS
755: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
756: BEGIN

Line 753: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type

749: -- Function Convert_Miss_To_Null
750:
751: FUNCTION Convert_Miss_To_Null
752: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
753: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
754: IS
755: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
756: BEGIN
757:

Line 755: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;

751: FUNCTION Convert_Miss_To_Null
752: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
753: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
754: IS
755: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
756: BEGIN
757:
758: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
759: l_CURR_LISTS_rec.attribute1 := NULL;

Line 905: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

901:
902: -- Procedure Update_Row
903:
904: PROCEDURE Update_Row
905: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
906: )
907: IS
908: BEGIN
909:

Line 1001: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

997:
998: -- Procedure Insert_Row
999:
1000: PROCEDURE Insert_Row
1001: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1002: )
1003: IS
1004: BEGIN
1005: -- oe_debug_pub.add('INSERT_ROW of Header');

Line 1293: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type

1289: -- Function Query_Row
1290:
1291: FUNCTION Query_Row
1292: ( p_currency_header_id IN NUMBER
1293: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
1294: IS
1295: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1296: BEGIN
1297:

Line 1295: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

1291: FUNCTION Query_Row
1292: ( p_currency_header_id IN NUMBER
1293: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
1294: IS
1295: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1296: BEGIN
1297:
1298: SELECT ATTRIBUTE1
1299: , ATTRIBUTE10

Line 1415: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

1411: --
1412:
1413: PROCEDURE Lock_Row
1414: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1415: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1416: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1417: )
1418: IS
1419: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

Line 1416: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

1412:
1413: PROCEDURE Lock_Row
1414: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1415: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1416: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1417: )
1418: IS
1419: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1420: BEGIN

Line 1419: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

1415: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1416: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1417: )
1418: IS
1419: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1420: BEGIN
1421:
1422: SELECT ATTRIBUTE1
1423: , ATTRIBUTE10

Line 1654: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

1650:
1651: -- Function Get_Values
1652:
1653: FUNCTION Get_Values
1654: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1655: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1656: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1657: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1658: IS

Line 1655: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=

1651: -- Function Get_Values
1652:
1653: FUNCTION Get_Values
1654: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1655: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1656: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1657: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1658: IS
1659: l_CURR_LISTS_val_rec QP_Currency_PUB.Curr_Lists_Val_Rec_Type;

Line 1656: QP_Currency_PUB.G_MISS_CURR_LISTS_REC

1652:
1653: FUNCTION Get_Values
1654: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1655: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1656: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1657: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1658: IS
1659: l_CURR_LISTS_val_rec QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
1660: BEGIN

Line 1657: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type

1653: FUNCTION Get_Values
1654: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1655: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1656: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1657: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1658: IS
1659: l_CURR_LISTS_val_rec QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
1660: BEGIN
1661:

Line 1659: l_CURR_LISTS_val_rec QP_Currency_PUB.Curr_Lists_Val_Rec_Type;

1655: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1656: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1657: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1658: IS
1659: l_CURR_LISTS_val_rec QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
1660: BEGIN
1661:
1662: -- oe_debug_pub.add('. ENTERED QP_Curr_Lists_Util.Get_Values');
1663: IF p_CURR_LISTS_rec.base_currency_code IS NOT NULL AND

Line 1717: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

1713:
1714: -- Function Get_Ids
1715:
1716: FUNCTION Get_Ids
1717: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1718: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1719: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
1720: IS
1721: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

Line 1718: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type

1714: -- Function Get_Ids
1715:
1716: FUNCTION Get_Ids
1717: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1718: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1719: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
1720: IS
1721: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1722: BEGIN

Line 1719: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type

1715:
1716: FUNCTION Get_Ids
1717: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1718: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1719: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
1720: IS
1721: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1722: BEGIN
1723:

Line 1721: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

1717: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
1718: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
1719: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type
1720: IS
1721: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1722: BEGIN
1723:
1724: -- initialize return_status.
1725: