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.PA_PROJECTS_MAINT_UTILS dependencies on FND_CURRENCIES

Line 1454: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required

1450: -- API name : check_currency_name_or_code
1451: -- Type : Public
1452: -- Pre-reqs : None.
1453: -- Parameters :
1454: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required
1455: -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required
1456: -- p_check_id_flag IN VARCHAR2 Required
1457: -- x_agreement_currency OUT VARCHAR2 Required
1458: -- x_return_status OUT VARCHAR2 Required

Line 1455: -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required

1451: -- Type : Public
1452: -- Pre-reqs : None.
1453: -- Parameters :
1454: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required
1455: -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required
1456: -- p_check_id_flag IN VARCHAR2 Required
1457: -- x_agreement_currency OUT VARCHAR2 Required
1458: -- x_return_status OUT VARCHAR2 Required
1459: -- x_error_msg_code OUT VARCHAR2 Required

Line 1470: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE

1466: -- and enabled_flag in the where clause.
1467: --
1468: --
1469: procedure Check_currency_name_or_code
1470: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
1471: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
1472: ,p_check_id_flag IN VARCHAR2
1473: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
1474: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1471: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE

1467: --
1468: --
1469: procedure Check_currency_name_or_code
1470: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
1471: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
1472: ,p_check_id_flag IN VARCHAR2
1473: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
1474: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1475: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1473: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895

1469: procedure Check_currency_name_or_code
1470: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
1471: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
1472: ,p_check_id_flag IN VARCHAR2
1473: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
1474: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1475: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1476: IS
1477: BEGIN

Line 1482: FROM fnd_currencies --Used base table:Bug 4352162

1478: IF (p_agreement_currency IS NOT NULL) THEN
1479: IF (p_check_id_flag = 'Y') THEN
1480: SELECT currency_code
1481: INTO x_agreement_currency
1482: FROM fnd_currencies --Used base table:Bug 4352162
1483: WHERE currency_code = p_agreement_currency
1484: AND nvl(enabled_flag, 'Y') = 'Y'
1485: AND sysdate between decode(start_date_active, null, sysdate, start_date_active)
1486: AND decode (end_date_active, null, sysdate, end_date_active);

Line 1493: FROM fnd_currencies_vl

1489: END IF;
1490: ELSE
1491: SELECT currency_code
1492: INTO x_agreement_currency
1493: FROM fnd_currencies_vl
1494: WHERE name = p_agreement_currency_name
1495: AND nvl(enabled_flag, 'Y') = 'Y'
1496: AND sysdate between decode(start_date_active, null, sysdate, start_date_active)
1497: AND decode (end_date_active, null, sysdate, end_date_active);