PACKAGE BODY: APPS.OE_VIEW_FUNCTIONS

Source

1 PACKAGE BODY OE_VIEW_FUNCTIONS AS
2 --$Header: OEXVIFNB.pls 120.0 2005/05/31 23:28:21 appldev noship $
3 FUNCTION GET_AGREEMENT_REVISION
4 (
5   p_Agreement_Name  Varchar2,
6   p_revision        Varchar2
7 )
8 RETURN Varchar2  is
9  x_agreement_revision varchar2(2000);
10 
11 BEGIN
12   fnd_message.set_name('ONT','ONT_CONCAT_AGREEMENT_REVISION');
13   fnd_message.set_token('AGREEMENT' , p_Agreement_Name);
14   fnd_message.set_token('REVISION' , p_revision);
15   x_agreement_revision:=FND_MESSAGE.GET;
16   return(x_agreement_revision);
17 EXCEPTION
18 WHEN OTHERS  THEN
19  return(null);
20 
21 END GET_AGREEMENT_REVISION;
22 
23 END OE_VIEW_FUNCTIONS;