DBA Data[Home] [Help]

APPS.JTF_UM_REGISTER_USER_PVT dependencies on HZ_PARTIES

Line 11: first_name hz_parties.person_first_name%type := null,

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,

Line 12: last_name hz_parties.person_last_name%type := null,

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,

Line 18: party_id hz_parties.party_id%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: );

Line 28: Organization_number hz_parties.party_number%type := null,

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,

Line 29: Organization_name hz_parties.party_name%type := null,

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,

Line 30: Address1 hz_parties.address1%type := null,

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,

Line 31: address2 hz_parties.address2%type := null,

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,

Line 32: address3 hz_parties.address3%type := null,

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,

Line 33: address4 hz_parties.address3%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,

Line 34: city hz_parties.city%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,

Line 35: state hz_parties.state%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,

Line 36: postal_code hz_parties.postal_code%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,

Line 37: county hz_parties.county%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,

Line 38: province hz_parties.province%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,

Line 40: country hz_parties.country%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,

Line 45: org_party_id hz_parties.party_id%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:

Line 46: org_contact_party_id hz_parties.party_id%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: );