[Home] [Help]
PACKAGE: APPS.FND_OID_USERS
Source
1 package fnd_oid_users AUTHID CURRENT_USER as
2 /* $Header: AFSCOURS.pls 120.3 2005/11/03 16:11:33 ssallaka noship $ */
3 --
4 /*****************************************************************************/
5 -- Start of Package Globals
6
7 G_PERSON constant varchar2(6) := 'PERSON';
8 G_LOCATION constant varchar2(8) := 'LOCATION';
9 G_BUSINESS constant varchar2(8) := 'BUSINESS';
10 G_PERSONAL constant varchar2(8) := 'PERSONAL';
11 G_GEN constant varchar2(3) := 'GEN';
12 G_PHONE constant varchar2(5) := 'PHONE';
13 G_EMAIL constant varchar2(5) := 'EMAIL';
14
15 G_HZ_GENERATE_PARTY_NUMBER constant varchar2(24) := 'HZ_GENERATE_PARTY_NUMBER';
16 G_HZ_GENERATE_PS_NUMBER constant varchar2(29) := 'HZ_GENERATE_PARTY_SITE_NUMBER';
17 G_FND_OID_SYNCH constant varchar2(13) := 'FND_OID_SYNCH';
18 G_HZ_PARTIES constant varchar2(10) := 'HZ_PARTIES';
19 G_HZ_CONTACT_POINTS constant varchar2(17) := 'HZ_CONTACT_POINTS';
20 G_HZ_PARTY_SITES constant varchar2(14) := 'HZ_PARTY_SITES';
21
22 G_ACTIVE constant varchar2(1) := 'A';
23 G_INACTIVE constant varchar2(1) := 'I';
24 G_YES constant varchar2(1) := 'Y';
25 G_NO constant varchar2(1) := 'N';
26 G_UPDATE constant varchar2(6) := 'UPDATE';
27 G_CREATE constant varchar2(6) := 'CREATE';
28 G_UNKNOWN constant varchar2(10) := '*UNKNOWN*';
29
30 -- End of Package Globals
31 --
32 --
33 /*
34 ** Name : hz_create
35 ** Type : Public, FND Internal
36 ** Desc : Creates TCA entitites to reflect an OID user
37 ** Pre-Reqs :
38 ** Parameters :
39 ** p_ldap_msg -- Contains LDAP attributes
40 ** Notes :
41 */
42 procedure hz_create(
43 p_ldap_message in fnd_oid_util.ldap_message_type,
44 x_return_status out nocopy varchar2);
45 --
46 --
47 /*
48 ** Name : create_party
49 ** Type : Public, FND Internal
50 ** Desc : Creates a person
51 ** Pre-Reqs :
52 ** Parameters :
53 ** p_ldap_msg -- Contains LDAP attributes
54 ** Notes :
55 */
56 procedure create_party(
57 p_ldap_message in fnd_oid_util.ldap_message_type,
58 x_return_status out nocopy varchar2);
59
60 --
61 --
62 /*
63 ** Name : create_phone_contact_point
64 ** Type : Public, FND Internal
65 ** Desc : Creates a contact point of type 'PHONE'
66 ** Pre-Reqs :
67 ** Parameters :
68 ** p_ldap_msg -- Contains LDAP attributes
69 ** p_contact_point_purose -- BUSINESS or PERSONAL
70 ** Notes :
71 */
72 procedure create_phone_contact_point(
73 p_ldap_message in fnd_oid_util.ldap_message_type,
74 p_contact_point_purpose in varchar2,
75 x_return_status out nocopy varchar2);
76 --
77 --
78 procedure create_email_contact_point(
79 p_ldap_message in fnd_oid_util.ldap_message_type,
80 x_return_status out nocopy varchar2);
81 --
82 --
83 procedure create_location(
84 p_ldap_message in fnd_oid_util.ldap_message_type,
85 x_return_status out nocopy varchar2);
86 --
87 --
88 procedure create_party_site(
89 p_ldap_message in fnd_oid_util.ldap_message_type,
90 p_location_id in number,
91 x_return_status out nocopy varchar2);
92 --
93 --
94 procedure hz_update(
95 p_ldap_message in fnd_oid_util.ldap_message_type,
96 x_return_status out nocopy varchar2);
97 --
98 --
99 procedure update_party(
100 p_ldap_message in fnd_oid_util.ldap_message_type,
101 x_return_status out nocopy varchar2);
102 --
103 --
104 procedure update_phone_contact_point(
105 p_ldap_message in fnd_oid_util.ldap_message_type,
106 p_contact_point_purpose in varchar2,
107 x_return_status out nocopy varchar2);
108 --
109 --
110 procedure update_email_contact_point(
111 p_ldap_message in fnd_oid_util.ldap_message_type,
112 x_return_status out nocopy varchar2);
113 --
114 --
115 procedure update_party_site(
116 p_ldap_message in fnd_oid_util.ldap_message_type,
117 x_return_status out nocopy varchar2);
118 --
119 --
120 procedure get_person_rec(
121 p_ldap_message in fnd_oid_util.ldap_message_type,
122 p_action_type in varchar2,
123 x_person_rec out nocopy hz_party_v2pub.person_rec_type,
124 x_return_status out nocopy varchar2);
125 --
126 --
127 procedure get_contact_point_rec(
128 p_ldap_message in fnd_oid_util.ldap_message_type,
129 p_contact_point_type in varchar2,
130 p_contact_point_purpose in varchar2,
131 p_action_type in varchar2,
132 x_contact_point_rec out nocopy
133 hz_contact_point_v2pub.contact_point_rec_type,
134 x_return_status out nocopy varchar2);
135 --
136 --
137 procedure get_location_rec(
138 p_ldap_message in fnd_oid_util.ldap_message_type,
139 x_location_rec out nocopy hz_location_v2pub.location_rec_type);
140 --
141 --
142 procedure get_party_site_rec(
143 p_ldap_message in fnd_oid_util.ldap_message_type,
144 p_action_type in varchar2,
145 x_party_site_rec out nocopy hz_party_site_v2pub.party_site_rec_type,
146 x_return_status out nocopy varchar2);
147 --
148 --
149 procedure get_orig_system_ref(
150 p_ldap_message in fnd_oid_util.ldap_message_type,
151 p_tag in varchar2,
152 x_reference out nocopy varchar2);
153 --
154 --
155 procedure create_orig_system_reference(
156 p_ldap_message in fnd_oid_util.ldap_message_type,
157 p_tag in varchar2,
158 p_owner_table_name in varchar2,
159 p_owner_table_id in number,
160 p_status in varchar2,
161 x_return_status out nocopy varchar2);
162 --
163 --
164 procedure update_orig_system_reference(
165 p_ldap_message in fnd_oid_util.ldap_message_type,
166 p_tag in varchar2,
167 p_owner_table_name in varchar2,
168 p_owner_table_id in number default null,
169 p_status in varchar2,
170 x_return_status out nocopy varchar2);
171 --
172 --
173 procedure test;
174 --
175 --
176 end fnd_oid_users;