DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_UTILS dependencies on FND_CURRENCIES_VL

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

454: -- API name : check_agreement_currency_name_or_code
455: -- Type : Public
456: -- Pre-reqs : None.
457: -- Parameters :
458: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required
459: -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required
460: -- p_check_id_flag IN VARCHAR2 Required
461: -- x_agreement_currency OUT VARCHAR2 Required
462: -- x_return_status OUT VARCHAR2 Required

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

455: -- Type : Public
456: -- Pre-reqs : None.
457: -- Parameters :
458: -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required
459: -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required
460: -- p_check_id_flag IN VARCHAR2 Required
461: -- x_agreement_currency OUT VARCHAR2 Required
462: -- x_return_status OUT VARCHAR2 Required
463: -- x_error_msg_code OUT VARCHAR2 Required

Line 472: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE

468: -- 12-OCT-2001 -- anlee created
469: --
470: --
471: procedure Check_currency_name_or_code
472: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
473: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
474: ,p_check_id_flag IN VARCHAR2
475: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
476: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 473: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE

469: --
470: --
471: procedure Check_currency_name_or_code
472: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
473: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
474: ,p_check_id_flag IN VARCHAR2
475: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
476: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
477: ,x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

471: procedure Check_currency_name_or_code
472: ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
473: ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
474: ,p_check_id_flag IN VARCHAR2
475: ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
476: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
477: ,x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
478:
479: