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_DETAILS_UTIL dependencies on QP_CURRENCY_PUB

Line 12: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_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_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
13: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
16: )

Line 13: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
13: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
16: )
17: IS

Line 14: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
13: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
13: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 456: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

452:
453: -- Procedure Apply_Attribute_Changes
454:
455: PROCEDURE Apply_Attribute_Changes
456: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
457: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
458: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
459: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
460: )

Line 457: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=

453: -- Procedure Apply_Attribute_Changes
454:
455: PROCEDURE Apply_Attribute_Changes
456: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
457: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
458: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
459: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
460: )
461: IS

Line 458: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC

454:
455: PROCEDURE Apply_Attribute_Changes
456: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
457: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
458: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
459: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
460: )
461: IS
462: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 459: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type

455: PROCEDURE Apply_Attribute_Changes
456: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
457: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
458: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
459: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
460: )
461: IS
462: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
463: BEGIN

Line 740: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

736:
737: -- Function Complete_Record
738:
739: FUNCTION Complete_Record
740: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
741: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
742: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
743: IS
744: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;

Line 741: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

737: -- Function Complete_Record
738:
739: FUNCTION Complete_Record
740: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
741: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
742: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
743: IS
744: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
745: BEGIN

Line 742: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type

738:
739: FUNCTION Complete_Record
740: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
741: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
742: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
743: IS
744: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
745: BEGIN
746:

Line 744: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;

740: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
741: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
742: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
743: IS
744: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
745: BEGIN
746:
747: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
748: l_CURR_DETAILS_rec.attribute1 := p_old_CURR_DETAILS_rec.attribute1;

Line 940: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

936:
937: -- Function Convert_Miss_To_Null
938:
939: FUNCTION Convert_Miss_To_Null
940: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
941: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
942: IS
943: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
944: BEGIN

Line 941: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type

937: -- Function Convert_Miss_To_Null
938:
939: FUNCTION Convert_Miss_To_Null
940: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
941: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
942: IS
943: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
944: BEGIN
945:

Line 943: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;

939: FUNCTION Convert_Miss_To_Null
940: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
941: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
942: IS
943: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
944: BEGIN
945:
946: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
947: l_CURR_DETAILS_rec.attribute1 := NULL;

Line 1139: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

1135:
1136: -- Procedure Update_Row
1137:
1138: PROCEDURE Update_Row
1139: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1140: )
1141: IS
1142: BEGIN
1143:

Line 1213: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

1209:
1210: -- Procedure Insert_Row
1211:
1212: PROCEDURE Insert_Row
1213: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1214: )
1215: IS
1216: BEGIN
1217:

Line 1363: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type

1359: -- Function Query_Row
1360:
1361: FUNCTION Query_Row
1362: ( p_currency_detail_id IN NUMBER
1363: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
1364: IS
1365: BEGIN
1366:
1367: RETURN Query_Rows

Line 1382: ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type

1378: ( p_currency_detail_id IN NUMBER :=
1379: FND_API.G_MISS_NUM
1380: , p_currency_header_id IN NUMBER :=
1381: FND_API.G_MISS_NUM
1382: ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type
1383: IS
1384: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1385: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1386:

Line 1384: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1380: , p_currency_header_id IN NUMBER :=
1381: FND_API.G_MISS_NUM
1382: ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type
1383: IS
1384: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1385: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1386:
1387: CURSOR l_CURR_DETAILS_csr IS
1388: SELECT ATTRIBUTE1

Line 1385: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

1381: FND_API.G_MISS_NUM
1382: ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type
1383: IS
1384: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1385: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1386:
1387: CURSOR l_CURR_DETAILS_csr IS
1388: SELECT ATTRIBUTE1
1389: , ATTRIBUTE10

Line 1563: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

1559: --
1560:
1561: PROCEDURE Lock_Row
1562: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1563: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1564: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
1565: )
1566: IS
1567: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

Line 1564: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type

1560:
1561: PROCEDURE Lock_Row
1562: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1563: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1564: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
1565: )
1566: IS
1567: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1568: BEGIN

Line 1567: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1563: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1564: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
1565: )
1566: IS
1567: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1568: BEGIN
1569:
1570: SELECT ATTRIBUTE1
1571: , ATTRIBUTE10

Line 1832: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

1828:
1829: -- Function Get_Values
1830:
1831: FUNCTION Get_Values
1832: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1833: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
1834: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
1835: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1836: IS

Line 1833: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=

1829: -- Function Get_Values
1830:
1831: FUNCTION Get_Values
1832: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1833: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
1834: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
1835: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1836: IS
1837: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;

Line 1834: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC

1830:
1831: FUNCTION Get_Values
1832: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1833: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
1834: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
1835: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1836: IS
1837: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
1838: BEGIN

Line 1835: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type

1831: FUNCTION Get_Values
1832: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1833: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
1834: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
1835: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1836: IS
1837: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
1838: BEGIN
1839:

Line 1837: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;

1833: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
1834: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
1835: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1836: IS
1837: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
1838: BEGIN
1839:
1840: IF p_CURR_DETAILS_rec.currency_detail_id IS NOT NULL AND
1841: p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM AND

Line 1897: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

1893:
1894: -- Function Get_Ids
1895:
1896: FUNCTION Get_Ids
1897: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1898: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1899: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
1900: IS
1901: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

Line 1898: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type

1894: -- Function Get_Ids
1895:
1896: FUNCTION Get_Ids
1897: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1898: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1899: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
1900: IS
1901: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1902: BEGIN

Line 1899: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type

1895:
1896: FUNCTION Get_Ids
1897: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1898: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1899: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
1900: IS
1901: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1902: BEGIN
1903:

Line 1901: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1897: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1898: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
1899: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type
1900: IS
1901: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1902: BEGIN
1903:
1904: -- initialize return_status.
1905: