DBA Data[Home] [Help]

PACKAGE: APPS.AMS_ADI_CTD_PVT

Source


1 PACKAGE AMS_ADI_CTD_PVT AS
2 /* $Header: amsvadts.pls 120.1 2005/08/31 04:36:16 mayjain noship $ */
3 
4 
5 -- ===============================================================
6 -- Start of Comments
7 -- Package name
8 --         AMS_ADI_CTD_PVT
9 -- Purpose
10 --
11 -- This package contains all the program units for Click Through Destinations
12 --
13 -- History
14 --
15 -- NOTE
16 --
17 -- End of Comments
18 -- ===============================================================
19 G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'AMS_ADI_CTD_PVT';
20 
21 -- Start of Comments
22 -- Name
23 -- CREATE_CTDS
24 --
25 Procedure   CREATE_CTDS(
26               p_action_id NUMBER,
27               p_parameter_id1 NUMBER,
28               p_parameter_id2 NUMBER,
29               p_parameter_id3 NUMBER,
30               p_url_text varchar2,
31               p_adhoc_param_name1 varchar2 default null,
32               p_adhoc_param_name2 varchar2 default null,
33               p_adhoc_param_name3 varchar2 default null,
34               p_adhoc_param_name4 varchar2 default null,
35               p_adhoc_param_name5 varchar2 default null,
36               p_adhoc_param_val1 varchar2 default null,
37               p_adhoc_param_val2 varchar2 default null,
38               p_adhoc_param_val3 varchar2 default null,
39               p_adhoc_param_val4 varchar2 default null,
40               p_adhoc_param_val5 varchar2 default null,
41               p_used_by_id_list   JTF_NUMBER_TABLE,
42               p_schedule_id number,
43               p_activity_id number,
44               p_schedule_src_code varchar2,
45               x_ctd_id_list OUT nocopy jtf_number_table,
46               x_msg_count number,
47               x_msg_data varchar2,
48               x_return_status out nocopy varchar2,
49 	      p_activity_product_id NUMBER
50             ) ;
51 
52 END AMS_ADI_CTD_PVT;