[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;