DBA Data[Home] [Help]

PACKAGE: APPS.AMS_LIST_UTIL_PKG

Source


1 PACKAGE AMS_LIST_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: amsvluts.pls 115.5 2002/11/22 08:56:08 jieli ship $*/
3 PROCEDURE get_supp_sql_string(
4                       p_list_header_id in NUMBER,
5                       p_table_alias in varchar2,
6                       p_object_type in varchar2 default null,
7                       p_object_id in number default null,
8                       p_media_type in number default 'EMAIL',
9                       p_where_clause  OUT NOCOPY varchar2
10                      ) ;
11 PROCEDURE  get_supp_sql_string(
12 p_object_type in VARCHAR2,
13 p_object_id   in NUMBER,
14 x_where_clause OUT NOCOPY VARCHAR2,
15 x_status OUT NOCOPY VARCHAR2
16 );
17 END AMS_LIST_UTIL_PKG ;