PACKAGE: APPS.AMS_CTD_UTIL_PKG

Source

1 PACKAGE AMS_CTD_UTIL_PKG AS
2 /* $Header: amsvctus.pls 120.1 2005/07/02 00:54:48 appldev noship $ */
3 
4 
5 -- ===============================================================
6 -- Start of Comments
7 -- Package name
8 --        AMS_CTD_UTIL_PKG`
9 -- Purpose
10 --
11 -- This package contains utility methods for CTD
12 --
13 -- History
14 --
15 -- NOTE
16 --
17 -- End of Comments
18 -- ===============================================================
19 G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'AMS_CTD_UTIL_PKG';
20 
21 -- Start of Comments
22 -- Name
23 -- GET_TRACKING_URL
24 --
25 -- Note: Once we start supporting Offer for Web ADI,
26 -- we need to add Offer Code
27 
28 procedure   GET_TRACKING_URL(
29               p_ctd_id number,
30               p_schedule_id NUMBER,
31               p_schedule_src_code varchar2,
32               p_track_flag varchar2,
33               x_tracking_url OUT nocopy varchar2
34             );
35 Procedure   GET_FORWARDING_URL(
36               p_action_id NUMBER,
37               p_parameter_id1 NUMBER,
38               p_parameter_id2 NUMBER,
39               p_parameter_id3 NUMBER,
40               p_add_param1 varchar2,
41               p_add_param_value1 varchar2,
42               p_add_param2 varchar2,
43               p_add_param_value2 varchar2,
44               p_add_param3 varchar2,
45               p_add_param_value3 varchar2,
46               p_add_param4 varchar2,
47               p_add_param_value4 varchar2,
48               p_add_param5 varchar2,
49               p_add_param_value5 varchar2,
50               p_url_text varchar2,
51               p_schedule_id number,
52               x_forwarding_url out nocopy varchar2
53             );
54 Procedure   GET_ACTION_PARAM_ID (
55               p_action_id NUMBER,
56               x_act_param_code_list out nocopy jtf_varchar2_table_100,
57               x_act_param_id_list out nocopy jtf_number_table
58             );
59 
60 Procedure GetUsedByType(
61              p_activity_id number,
62              x_used_by_type out nocopy varchar2
63             );
64 Procedure Encrypt (
65                    p_value varchar2,
66                    x_value out nocopy varchar2
67                   );
68 
69 
70 END AMS_CTD_UTIL_PKG;