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
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
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
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
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: