DBA Data[Home] [Help]

PACKAGE: APPS.OTA_OM_UTIL

Source


1 Package OTA_OM_UTIL AUTHID CURRENT_USER as
2 /* $Header: otomutil.pkh 115.1 2002/11/26 15:57:39 arkashya noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< <get_event_detail> >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 --   Name                           Reqd Type     Description
17 --  p_line_id			    NUMBER        Line ID
18 --  p_uom			    VARCHAR2      Unit of measure
19 --
20 -- Out Parameters:
21 --   Name                       Reqd Type     	Description
22 --  x_activity_name    		VARCHAR2	Activity Name
23 --  x_event_title		VARCHAR2	Event Title
24 --  x_course_start_date		DATE		Course Start Date
25 --  x_course_end_date		DATE		Course End Date
26 -- Post Success:
27 --
28 --
29 --   Name                           Type     Description
30 --
31 -- Post Failure:
32 --
33 --
34 -- Access Status:
35 --   Public.
36 --
37 -- {End Of Comments}
38 --
39 PROCEDURE get_event_detail
40   (p_line_id        		IN	NUMBER,
41    p_UOM			IN	VARCHAR2,
42    x_activity_name		OUT   NOCOPY VARCHAR2,
43    x_event_title		OUT   NOCOPY VARCHAR2,
44    x_course_start_date		OUT   NOCOPY	DATE,
45    x_course_end_date		OUT   NOCOPY    DATE
46   );
47 
48 
49 END ota_om_util;