[Home] [Help]
TYPE BODY: APPS.HZ_PERSON_PROFILE_OBJ
Source
1 TYPE BODY hz_person_profile_obj AS
2
3 STATIC FUNCTION create_object(
4 p_person_id IN NUMBER := NULL,
5 p_orig_system IN VARCHAR2 := NULL,
6 p_orig_system_reference IN VARCHAR2 := NULL,
7 p_party_number IN VARCHAR2 := NULL,
8 p_validated_flag IN VARCHAR2 := NULL,
9 p_status IN VARCHAR2 := NULL,
10 p_category_code IN VARCHAR2 := NULL,
11 p_salutation IN VARCHAR2 := NULL,
12 p_attribute_category IN VARCHAR2 := NULL,
13 p_attribute1 IN VARCHAR2 := NULL,
14 p_attribute2 IN VARCHAR2 := NULL,
15 p_attribute3 IN VARCHAR2 := NULL,
16 p_attribute4 IN VARCHAR2 := NULL,
17 p_attribute5 IN VARCHAR2 := NULL,
18 p_attribute6 IN VARCHAR2 := NULL,
19 p_attribute7 IN VARCHAR2 := NULL,
20 p_attribute8 IN VARCHAR2 := NULL,
21 p_attribute9 IN VARCHAR2 := NULL,
22 p_attribute10 IN VARCHAR2 := NULL,
23 p_attribute11 IN VARCHAR2 := NULL,
24 p_attribute12 IN VARCHAR2 := NULL,
25 p_attribute13 IN VARCHAR2 := NULL,
26 p_attribute14 IN VARCHAR2 := NULL,
27 p_attribute15 IN VARCHAR2 := NULL,
28 p_attribute16 IN VARCHAR2 := NULL,
29 p_attribute17 IN VARCHAR2 := NULL,
30 p_attribute18 IN VARCHAR2 := NULL,
31 p_attribute19 IN VARCHAR2 := NULL,
32 p_attribute20 IN VARCHAR2 := NULL,
33 p_attribute21 IN VARCHAR2 := NULL,
34 p_attribute22 IN VARCHAR2 := NULL,
35 p_attribute23 IN VARCHAR2 := NULL,
36 p_attribute24 IN VARCHAR2 := NULL,
37 p_person_pre_name_adjunct IN VARCHAR2 := NULL,
38 p_person_first_name IN VARCHAR2 := NULL,
39 p_person_middle_name IN VARCHAR2 := NULL,
40 p_person_last_name IN VARCHAR2 := NULL,
41 p_person_name_suffix IN VARCHAR2 := NULL,
42 p_person_title IN VARCHAR2 := NULL,
43 p_person_academic_title IN VARCHAR2 := NULL,
44 p_person_previous_last_name IN VARCHAR2 := NULL,
45 p_person_initials IN VARCHAR2 := NULL,
46 p_known_as IN VARCHAR2 := NULL,
47 p_known_as2 IN VARCHAR2 := NULL,
48 p_known_as3 IN VARCHAR2 := NULL,
49 p_known_as4 IN VARCHAR2 := NULL,
50 p_known_as5 IN VARCHAR2 := NULL,
51 p_person_name_phonetic IN VARCHAR2 := NULL,
52 p_person_first_name_phonetic IN VARCHAR2 := NULL,
53 p_person_last_name_phonetic IN VARCHAR2 := NULL,
54 p_middle_name_phonetic IN VARCHAR2 := NULL,
55 p_tax_reference IN VARCHAR2 := NULL,
56 p_jgzz_fiscal_code IN VARCHAR2 := NULL,
57 p_person_iden_type IN VARCHAR2 := NULL,
58 p_person_identifier IN VARCHAR2 := NULL,
59 p_date_of_birth IN DATE := NULL,
60 p_place_of_birth IN VARCHAR2 := NULL,
61 p_date_of_death IN DATE := NULL,
62 p_deceased_flag IN VARCHAR2 := NULL,
63 p_gender IN VARCHAR2 := NULL,
64 p_declared_ethnicity IN VARCHAR2 := NULL,
65 p_marital_status IN VARCHAR2 := NULL,
66 p_marital_status_eff_date IN DATE := NULL,
67 p_personal_income IN NUMBER := NULL,
68 p_head_of_household_flag IN VARCHAR2 := NULL,
69 p_household_income IN NUMBER := NULL,
70 p_household_size IN NUMBER := NULL,
71 p_rent_own_ind IN VARCHAR2 := NULL,
72 p_last_known_gps IN VARCHAR2 := NULL,
73 p_internal_flag IN VARCHAR2 := NULL,
74 p_actual_content_source IN VARCHAR2 := NULL
75 ) RETURN hz_person_profile_obj AS
76 BEGIN
77 RETURN hz_person_profile_obj(
78 action_type => NULL,
79 common_obj_id => NULL,
80 person_id => p_person_id,
81 orig_system => p_orig_system, orig_system_reference => p_orig_system_reference,
82 party_number => p_party_number, validated_flag => p_validated_flag,
83 status => p_status, category_code => p_category_code, salutation => p_salutation,
84 attribute_category => p_attribute_category, attribute1 => p_attribute1, attribute2 => p_attribute2,
85 attribute3 => p_attribute3, attribute4 => p_attribute4, attribute5 => p_attribute5, attribute6 => p_attribute6,
86 attribute7 => p_attribute7, attribute8 => p_attribute8, attribute9 => p_attribute9, attribute10 => p_attribute10,
87 attribute11 => p_attribute11, attribute12 => p_attribute12, attribute13 => p_attribute13,
88 attribute14 => p_attribute14, attribute15 => p_attribute15, attribute16 => p_attribute16,
89 attribute17 => p_attribute17, attribute18 => p_attribute18, attribute19 => p_attribute19,
90 attribute20 => p_attribute20, attribute21 => p_attribute21, attribute22 => p_attribute22,
91 attribute23 => p_attribute23, attribute24 => p_attribute24,
92 person_pre_name_adjunct => p_person_pre_name_adjunct,
93 person_first_name => p_person_first_name,
94 person_middle_name => p_person_middle_name,
95 person_last_name => p_person_last_name,
96 person_name_suffix => p_person_name_suffix,
97 person_title => p_person_title,
98 person_academic_title => p_person_academic_title,
99 person_previous_last_name => p_person_previous_last_name,
100 person_initials => p_person_initials,
101 known_as => p_known_as,
102 known_as2 => p_known_as2,
103 known_as3 => p_known_as3,
104 known_as4 => p_known_as4,
105 known_as5 => p_known_as5,
106 person_name_phonetic => p_person_name_phonetic,
107 person_first_name_phonetic => p_person_first_name_phonetic,
108 person_last_name_phonetic => p_person_last_name_phonetic,
109 middle_name_phonetic => p_middle_name_phonetic,
110 tax_reference => p_tax_reference,
111 jgzz_fiscal_code => p_jgzz_fiscal_code,
112 person_iden_type => p_person_iden_type,
113 person_identifier => p_person_identifier,
114 date_of_birth => p_date_of_birth,
115 place_of_birth => p_place_of_birth,
116 date_of_death => p_date_of_death,
117 deceased_flag => p_deceased_flag,
118 gender => p_gender,
119 declared_ethnicity => p_declared_ethnicity,
120 marital_status => p_marital_status,
121 marital_status_eff_date => p_marital_status_eff_date,
122 personal_income => p_personal_income,
123 head_of_household_flag => p_head_of_household_flag,
124 household_income => p_household_income,
125 household_size => p_household_size,
126 rent_own_ind => p_rent_own_ind,
127 last_known_gps => p_last_known_gps,
128 internal_flag => p_internal_flag,
129 program_update_date => NULL,
130 created_by_module => NULL,
131 created_by_name => NULL,
132 creation_date => NULL,
133 last_update_date => NULL,
134 last_updated_by_name => NULL,
135 actual_content_source => p_actual_content_source,
136 orig_sys_objs => HZ_ORIG_SYS_REF_OBJ_TBL(),
137 ext_attributes_objs => HZ_EXT_ATTRIBUTE_OBJ_TBL()
138 );
139 END create_object;
140 END;