[Home] [Help]
PACKAGE: APPS.HZ_CONTACT_PREFERENCE_V2PUB_JW
Source
1 package hz_contact_preference_v2pub_jw AUTHID CURRENT_USER as
2 /* $Header: ARH2CTJS.pls 120.2 2005/06/18 04:27:39 jhuang noship $ */
3 procedure create_contact_preference_1(p_init_msg_list VARCHAR2
4 , x_contact_preference_id out nocopy NUMBER
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p1_a0 NUMBER := null
9 , p1_a1 VARCHAR2 := null
10 , p1_a2 NUMBER := null
11 , p1_a3 VARCHAR2 := null
12 , p1_a4 VARCHAR2 := null
13 , p1_a5 VARCHAR2 := null
14 , p1_a6 NUMBER := null
15 , p1_a7 VARCHAR2 := null
16 , p1_a8 DATE := null
17 , p1_a9 DATE := null
18 , p1_a10 NUMBER := null
19 , p1_a11 NUMBER := null
20 , p1_a12 NUMBER := null
21 , p1_a13 NUMBER := null
22 , p1_a14 NUMBER := null
23 , p1_a15 VARCHAR2 := null
24 , p1_a16 VARCHAR2 := null
25 , p1_a17 VARCHAR2 := null
26 , p1_a18 VARCHAR2 := null
27 , p1_a19 VARCHAR2 := null
28 , p1_a20 NUMBER := null
29 );
30 procedure update_contact_preference_2(p_init_msg_list VARCHAR2
31 , p_object_version_number in out nocopy NUMBER
32 , x_return_status out nocopy VARCHAR2
33 , x_msg_count out nocopy NUMBER
34 , x_msg_data out nocopy VARCHAR2
35 , p1_a0 NUMBER := null
36 , p1_a1 VARCHAR2 := null
37 , p1_a2 NUMBER := null
38 , p1_a3 VARCHAR2 := null
39 , p1_a4 VARCHAR2 := null
40 , p1_a5 VARCHAR2 := null
41 , p1_a6 NUMBER := null
42 , p1_a7 VARCHAR2 := null
43 , p1_a8 DATE := null
44 , p1_a9 DATE := null
45 , p1_a10 NUMBER := null
46 , p1_a11 NUMBER := null
47 , p1_a12 NUMBER := null
48 , p1_a13 NUMBER := null
49 , p1_a14 NUMBER := null
50 , p1_a15 VARCHAR2 := null
51 , p1_a16 VARCHAR2 := null
52 , p1_a17 VARCHAR2 := null
53 , p1_a18 VARCHAR2 := null
54 , p1_a19 VARCHAR2 := null
55 , p1_a20 NUMBER := null
56 );
57 procedure get_contact_preference_rec_3(p_init_msg_list VARCHAR2
58 , p_contact_preference_id NUMBER
59 , p2_a0 out nocopy NUMBER
60 , p2_a1 out nocopy VARCHAR2
61 , p2_a2 out nocopy NUMBER
62 , p2_a3 out nocopy VARCHAR2
63 , p2_a4 out nocopy VARCHAR2
64 , p2_a5 out nocopy VARCHAR2
65 , p2_a6 out nocopy NUMBER
66 , p2_a7 out nocopy VARCHAR2
67 , p2_a8 out nocopy DATE
68 , p2_a9 out nocopy DATE
69 , p2_a10 out nocopy NUMBER
70 , p2_a11 out nocopy NUMBER
71 , p2_a12 out nocopy NUMBER
72 , p2_a13 out nocopy NUMBER
73 , p2_a14 out nocopy NUMBER
74 , p2_a15 out nocopy VARCHAR2
75 , p2_a16 out nocopy VARCHAR2
76 , p2_a17 out nocopy VARCHAR2
77 , p2_a18 out nocopy VARCHAR2
78 , p2_a19 out nocopy VARCHAR2
79 , p2_a20 out nocopy NUMBER
80 , x_return_status out nocopy VARCHAR2
81 , x_msg_count out nocopy NUMBER
82 , x_msg_data out nocopy VARCHAR2
83 );
84 end hz_contact_preference_v2pub_jw;