[Home] [Help]
PACKAGE: APPS.JTF_UM_REGISTER_USER_PVT
Source
1 PACKAGE JTF_UM_REGISTER_USER_PVT AUTHID CURRENT_USER as
2 /* $Header: JTFVUURS.pls 115.5 2002/08/27 21:31:13 ssallaka ship $ */
3 -- Start of Comments
4 -- Package name : JTF_UM_REGISTER_USER_PVT
5 -- Purpose :
6 -- This package contains specification for pl/sql records and tables required
7 -- by the handlers to register users
8
9 TYPE Person_rec_type IS RECORD
10 (
11 first_name hz_parties.person_first_name%type := null,
12 last_name hz_parties.person_last_name%type := null,
13 user_name fnd_user.user_name%type := null,
14 password varchar2(100) := null,
15 phone_area_code hz_contact_points.phone_area_code%type := null,
16 phone_number hz_contact_points.phone_number%type := null,
17 email_address fnd_user.email_address%type := null,
18 party_id hz_parties.party_id%type := null,
19 user_id fnd_user.user_id%type := null,
20 start_date_active date := null,
21 privacy_preference varchar2(5) := 'NO'
22 );
23
24 G_MISS_Person_Rec Person_Rec_Type;
25
26 TYPE Organization_rec_type IS RECORD
27 (
28 Organization_number hz_parties.party_number%type := null,
29 Organization_name hz_parties.party_name%type := null,
30 Address1 hz_parties.address1%type := null,
31 address2 hz_parties.address2%type := null,
32 address3 hz_parties.address3%type := null,
33 address4 hz_parties.address3%type := null,
34 city hz_parties.city%type := null,
35 state hz_parties.state%type := null,
36 postal_code hz_parties.postal_code%type := null,
37 county hz_parties.county%type := null,
38 province hz_parties.province%type := null,
39 altaddress hz_locations.address_lines_phonetic%type := null,
40 country hz_parties.country%type := null,
41 phone_area_code hz_contact_points.phone_area_code%type := null,
42 phone_number hz_contact_points.phone_number%type := null,
43 fax_area_code hz_contact_points.phone_area_code%type := null,
44 fax_number varchar2(40) := null,
45 org_party_id hz_parties.party_id%type := null,
46 org_contact_party_id hz_parties.party_id%type := null,
47 start_date_active date := null
48 --location_id, party_site_id
49
50 );
51
52 G_MISS_Organization_Rec Organization_Rec_Type;
53
54 end JTF_UM_REGISTER_USER_PVT;