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 1441: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required

1437: -- API name : check_currency_name_or_code
1438: -- Type : Public
1439: -- Pre-reqs : None.
1440: -- Parameters :
1441: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required
1442: -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required
1443: -- p_check_id_flag IN VARCHAR2 Required
1444: -- x_agreement_currency OUT VARCHAR2 Required
1445: -- x_return_status OUT VARCHAR2 Required

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

1438: -- Type : Public
1439: -- Pre-reqs : None.
1440: -- Parameters :
1441: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required
1442: -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required
1443: -- p_check_id_flag IN VARCHAR2 Required
1444: -- x_agreement_currency OUT VARCHAR2 Required
1445: -- x_return_status OUT VARCHAR2 Required
1446: -- x_error_msg_code OUT VARCHAR2 Required

Line 1457: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE

1453: -- and enabled_flag in the where clause.
1454: --
1455: --
1456: procedure Check_currency_name_or_code
1457: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
1458: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
1459: ,p_check_id_flag IN VARCHAR2
1460: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
1461: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1458: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE

1454: --
1455: --
1456: procedure Check_currency_name_or_code
1457: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
1458: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
1459: ,p_check_id_flag IN VARCHAR2
1460: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
1461: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1462: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

1456: procedure Check_currency_name_or_code
1457: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
1458: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
1459: ,p_check_id_flag IN VARCHAR2
1460: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
1461: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1462: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1463: IS
1464: BEGIN

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

1465: IF (p_agreement_currency IS NOT NULL) THEN
1466: IF (p_check_id_flag = 'Y') THEN
1467: SELECT currency_code
1468: INTO x_agreement_currency
1469: FROM fnd_currencies --Used base table:Bug 4352162
1470: WHERE currency_code = p_agreement_currency
1471: AND nvl(enabled_flag, 'Y') = 'Y'
1472: AND sysdate between decode(start_date_active, null, sysdate, start_date_active)
1473: AND decode (end_date_active, null, sysdate, end_date_active);

Line 1480: FROM fnd_currencies_vl

1476: END IF;
1477: ELSE
1478: SELECT currency_code
1479: INTO x_agreement_currency
1480: FROM fnd_currencies_vl
1481: WHERE name = p_agreement_currency_name
1482: AND nvl(enabled_flag, 'Y') = 'Y'
1483: AND sysdate between decode(start_date_active, null, sysdate, start_date_active)
1484: AND decode (end_date_active, null, sysdate, end_date_active);