eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
TYPE BODY: APPS.HZ_ORGANIZATION_BO

Source


1 TYPE BODY hz_organization_bo AS
2 
3   STATIC FUNCTION create_object(
4     p_organization_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_organization_name	IN VARCHAR2 := NULL,
38     p_duns_number_c	IN VARCHAR2 := NULL,
39     p_enquiry_duns	IN VARCHAR2 := NULL,
40     p_ceo_name	IN VARCHAR2 := NULL,
41     p_ceo_title	IN VARCHAR2 := NULL,
42     p_principal_name	IN VARCHAR2 := NULL,
43     p_principal_title	IN VARCHAR2 := NULL,
44     p_legal_status	IN VARCHAR2 := NULL,
45     p_control_yr	IN NUMBER := NULL,
46     p_employees_total	IN NUMBER := NULL,
47     p_hq_branch_ind	IN VARCHAR2 := NULL,
48     p_branch_flag	IN VARCHAR2 := NULL,
49     p_oob_ind	IN VARCHAR2 := NULL,
50     p_line_of_business	IN VARCHAR2 := NULL,
51     p_cong_dist_code	IN VARCHAR2 := NULL,
52     p_sic_code	IN VARCHAR2 := NULL,
53     p_import_ind	IN VARCHAR2 := NULL,
54     p_export_ind	IN VARCHAR2 := NULL,
55     p_labor_surplus_ind	IN VARCHAR2 := NULL,
56     p_debarment_ind	IN VARCHAR2 := NULL,
57     p_minority_owned_ind	IN VARCHAR2 := NULL,
58     p_minority_owned_type	IN VARCHAR2 := NULL,
59     p_woman_owned_ind	IN VARCHAR2 := NULL,
60     p_disadv_8a_ind	IN VARCHAR2 := NULL,
61     p_small_bus_ind	IN VARCHAR2 := NULL,
62     p_rent_own_ind	IN VARCHAR2 := NULL,
63     p_debarments_count	IN NUMBER := NULL,
64     p_debarments_date	IN DATE := NULL,
65     p_failure_score	IN VARCHAR2 := NULL,
66     p_failure_score_natnl_per	IN NUMBER := NULL,
67     p_failure_score_override_code	IN VARCHAR2 := NULL,
68     p_failure_score_commentary	IN VARCHAR2 := NULL,
69     p_global_failure_score	IN VARCHAR2 := NULL,
70     p_db_rating	IN VARCHAR2 := NULL,
71     p_credit_score	IN VARCHAR2 := NULL,
72     p_credit_score_commentary	IN VARCHAR2 := NULL,
73     p_paydex_score	IN VARCHAR2 := NULL,
74     p_paydex_three_months_ago	IN VARCHAR2 := NULL,
75     p_paydex_norm	IN VARCHAR2 := NULL,
76     p_best_time_contact_begin	IN DATE := NULL,
77     p_best_time_contact_end	IN DATE := NULL,
78     p_organization_name_phonetic	IN VARCHAR2 := NULL,
79     p_tax_reference	IN VARCHAR2 := NULL,
80     p_gsa_indicator_flag	IN VARCHAR2 := NULL,
81     p_jgzz_fiscal_code	IN VARCHAR2 := NULL,
82     p_analysis_fy	IN VARCHAR2 := NULL,
83     p_fiscal_yearend_month	IN VARCHAR2 := NULL,
84     p_curr_fy_potential_revenue	IN NUMBER := NULL,
85     p_next_fy_potential_revenue	IN NUMBER := NULL,
86     p_year_established	IN NUMBER := NULL,
87     p_mission_statement	IN VARCHAR2 := NULL,
88     p_organization_type	IN VARCHAR2 := NULL,
89     p_business_scope	IN VARCHAR2 := NULL,
90     p_corporation_class	IN VARCHAR2 := NULL,
91     p_known_as	IN VARCHAR2 := NULL,
92     p_known_as2	IN VARCHAR2 := NULL,
93     p_known_as3	IN VARCHAR2 := NULL,
94     p_known_as4	IN VARCHAR2 := NULL,
95     p_known_as5	IN VARCHAR2 := NULL,
96     p_local_bus_iden_type	IN VARCHAR2 := NULL,
97     p_local_bus_identifier	IN VARCHAR2 := NULL,
98     p_pref_functional_currency	IN VARCHAR2 := NULL,
99     p_registration_type	IN VARCHAR2 := NULL,
100     p_total_employees_text	IN VARCHAR2 := NULL,
101     p_total_employees_ind	IN VARCHAR2 := NULL,
102     p_total_emp_est_ind	IN VARCHAR2 := NULL,
103     p_total_emp_min_ind	IN VARCHAR2 := NULL,
104     p_parent_sub_ind	IN VARCHAR2 := NULL,
105     p_incorp_year	IN NUMBER := NULL,
106     p_sic_code_type	IN VARCHAR2 := NULL,
107     p_public_private_owner_flag	IN VARCHAR2 := NULL,
108     p_internal_flag	IN VARCHAR2 := NULL,
109     p_local_activity_code_type	IN VARCHAR2 := NULL,
110     p_local_activity_code	IN VARCHAR2 := NULL,
111     p_emp_at_primary_adr	IN VARCHAR2 := NULL,
112     p_emp_at_primary_adr_text	IN VARCHAR2 := NULL,
113     p_emp_at_primary_adr_est_ind	IN VARCHAR2 := NULL,
114     p_emp_at_primary_adr_min_ind	IN VARCHAR2 := NULL,
115     p_high_credit	IN NUMBER := NULL,
116     p_avg_high_credit	IN NUMBER := NULL,
117     p_total_payments	IN NUMBER := NULL,
118     p_credit_score_class	IN NUMBER := NULL,
119     p_credit_score_natl_percentile	IN NUMBER := NULL,
120     p_credit_score_incd_default	IN NUMBER := NULL,
121     p_credit_score_age	IN NUMBER := NULL,
122     p_credit_score_date	IN DATE := NULL,
123     p_credit_score_commentary2	IN VARCHAR2 := NULL,
124     p_credit_score_commentary3	IN VARCHAR2 := NULL,
125     p_credit_score_commentary4	IN VARCHAR2 := NULL,
126     p_credit_score_commentary5	IN VARCHAR2 := NULL,
127     p_credit_score_commentary6	IN VARCHAR2 := NULL,
128     p_credit_score_commentary7	IN VARCHAR2 := NULL,
129     p_credit_score_commentary8	IN VARCHAR2 := NULL,
130     p_credit_score_commentary9	IN VARCHAR2 := NULL,
131     p_credit_score_commentary10	IN VARCHAR2 := NULL,
132     p_failure_score_class	IN NUMBER := NULL,
133     p_failure_score_incd_default	IN NUMBER := NULL,
134     p_failure_score_age	IN NUMBER := NULL,
135     p_failure_score_date	IN DATE := NULL,
136     p_failure_score_commentary2	IN VARCHAR2 := NULL,
137     p_failure_score_commentary3	IN VARCHAR2 := NULL,
138     p_failure_score_commentary4	IN VARCHAR2 := NULL,
139     p_failure_score_commentary5	IN VARCHAR2 := NULL,
140     p_failure_score_commentary6	IN VARCHAR2 := NULL,
141     p_failure_score_commentary7	IN VARCHAR2 := NULL,
142     p_failure_score_commentary8	IN VARCHAR2 := NULL,
143     p_failure_score_commentary9	IN VARCHAR2 := NULL,
144     p_failure_score_commentary10	IN VARCHAR2 := NULL,
145     p_maximum_credit_recommend	IN NUMBER := NULL,
146     p_maximum_credit_currency_code	IN VARCHAR2 := NULL,
147     p_displayed_duns_party_id	IN NUMBER := NULL,
148     p_actual_content_source	IN VARCHAR2 := NULL,
149     p_do_not_confuse_with	IN VARCHAR2 := NULL
150   ) RETURN hz_organization_bo AS
151   BEGIN
152     RETURN hz_organization_bo(
153       action_type => NULL,
154       common_obj_id => NULL,
155       organization_id => p_organization_id,
156       orig_system => p_orig_system,
157       orig_system_reference => p_orig_system_reference,
158       party_number => p_party_number, validated_flag => p_validated_flag,
159       status => p_status, category_code => p_category_code, salutation => p_salutation,
160       attribute_category => p_attribute_category, attribute1 => p_attribute1, attribute2 => p_attribute2,
161       attribute3 => p_attribute3, attribute4 => p_attribute4, attribute5 => p_attribute5, attribute6 => p_attribute6,
162       attribute7 => p_attribute7, attribute8 => p_attribute8, attribute9 => p_attribute9, attribute10 => p_attribute10,
163       attribute11 => p_attribute11, attribute12 => p_attribute12, attribute13 => p_attribute13,
164       attribute14 => p_attribute14, attribute15 => p_attribute15, attribute16 => p_attribute16,
165       attribute17 => p_attribute17, attribute18 => p_attribute18, attribute19 => p_attribute19,
166       attribute20 => p_attribute20, attribute21 => p_attribute21, attribute22 => p_attribute22,
167       attribute23 => p_attribute23, attribute24 => p_attribute24,
168       organization_name => p_organization_name,
169       duns_number_c => p_duns_number_c,
170       enquiry_duns => p_enquiry_duns,
171       ceo_name => p_ceo_name,
172       ceo_title => p_ceo_title,
173       principal_name => p_principal_name,
174       principal_title => p_principal_title,
175       legal_status => p_legal_status,
176       control_yr => p_control_yr,
177       employees_total => p_employees_total,
178       hq_branch_ind => p_hq_branch_ind,
179       branch_flag => p_branch_flag,
180       oob_ind => p_oob_ind,
181       line_of_business => p_line_of_business,
182       cong_dist_code => p_cong_dist_code,
183       sic_code => p_sic_code,
184       import_ind => p_import_ind,
185       export_ind => p_export_ind,
186       labor_surplus_ind => p_labor_surplus_ind,
187       debarment_ind => p_debarment_ind,
188       minority_owned_ind => p_minority_owned_ind,
189       minority_owned_type => p_minority_owned_type,
190       woman_owned_ind => p_woman_owned_ind,
191       disadv_8a_ind => p_disadv_8a_ind,
192       small_bus_ind => p_small_bus_ind,
193       rent_own_ind => p_rent_own_ind,
194       debarments_count => p_debarments_count,
195       debarments_date => p_debarments_date,
196       failure_score => p_failure_score,
197       failure_score_natnl_per => p_failure_score_natnl_per,
198       failure_score_override_code => p_failure_score_override_code,
199       failure_score_commentary => p_failure_score_commentary,
200       global_failure_score => p_global_failure_score,
201       db_rating => p_db_rating,
202       credit_score => p_credit_score,
203       credit_score_commentary => p_credit_score_commentary,
204       paydex_score => p_paydex_score,
205       paydex_three_months_ago => p_paydex_three_months_ago,
206       paydex_norm => p_paydex_norm,
207       best_time_contact_begin => p_best_time_contact_begin,
208       best_time_contact_end => p_best_time_contact_end,
209       organization_name_phonetic => p_organization_name_phonetic,
210       tax_reference => p_tax_reference,
211       gsa_indicator_flag => p_gsa_indicator_flag,
212       jgzz_fiscal_code => p_jgzz_fiscal_code,
213       analysis_fy => p_analysis_fy,
214       fiscal_yearend_month => p_fiscal_yearend_month,
215       curr_fy_potential_revenue => p_curr_fy_potential_revenue,
216       next_fy_potential_revenue => p_next_fy_potential_revenue,
217       year_established => p_year_established,
218       mission_statement => p_mission_statement,
219       organization_type => p_organization_type,
220       business_scope => p_business_scope,
221       corporation_class => p_corporation_class,
222       known_as => p_known_as,
223       known_as2 => p_known_as2,
224       known_as3 => p_known_as3,
225       known_as4 => p_known_as4,
226       known_as5 => p_known_as5,
227       local_bus_iden_type => p_local_bus_iden_type,
228       local_bus_identifier => p_local_bus_identifier,
229       pref_functional_currency => p_pref_functional_currency,
230       registration_type => p_registration_type,
231       total_employees_text => p_total_employees_text,
232       total_employees_ind => p_total_employees_ind,
233       total_emp_est_ind => p_total_emp_est_ind,
234       total_emp_min_ind => p_total_emp_min_ind,
235       parent_sub_ind => p_parent_sub_ind,
236       incorp_year => p_incorp_year,
237       sic_code_type => p_sic_code_type,
238       public_private_owner_flag => p_public_private_owner_flag,
239       internal_flag => p_internal_flag,
240       local_activity_code_type => p_local_activity_code_type,
241       local_activity_code => p_local_activity_code,
242       emp_at_primary_adr => p_emp_at_primary_adr,
243       emp_at_primary_adr_text => p_emp_at_primary_adr_text,
244       emp_at_primary_adr_est_ind => p_emp_at_primary_adr_est_ind,
245       emp_at_primary_adr_min_ind => p_emp_at_primary_adr_min_ind,
246       high_credit => p_high_credit,
247       avg_high_credit => p_avg_high_credit,
248       total_payments => p_total_payments,
249       credit_score_class => p_credit_score_class,
250       credit_score_natl_percentile => p_credit_score_natl_percentile,
251       credit_score_incd_default => p_credit_score_incd_default,
252       credit_score_age => p_credit_score_age,
253       credit_score_date => p_credit_score_date,
254       credit_score_commentary2 => p_credit_score_commentary2,
255       credit_score_commentary3 => p_credit_score_commentary3,
256       credit_score_commentary4 => p_credit_score_commentary4,
257       credit_score_commentary5 => p_credit_score_commentary5,
258       credit_score_commentary6 => p_credit_score_commentary6,
259       credit_score_commentary7 => p_credit_score_commentary7,
260       credit_score_commentary8 => p_credit_score_commentary8,
261       credit_score_commentary9 => p_credit_score_commentary9,
262       credit_score_commentary10 => p_credit_score_commentary10,
263       failure_score_class => p_failure_score_class,
264       failure_score_incd_default => p_failure_score_incd_default,
265       failure_score_age => p_failure_score_age,
266       failure_score_date => p_failure_score_date,
267       failure_score_commentary2 => p_failure_score_commentary2,
268       failure_score_commentary3 => p_failure_score_commentary3,
269       failure_score_commentary4 => p_failure_score_commentary4,
270       failure_score_commentary5 => p_failure_score_commentary5,
271       failure_score_commentary6 => p_failure_score_commentary6,
272       failure_score_commentary7 => p_failure_score_commentary7,
273       failure_score_commentary8 => p_failure_score_commentary8,
274       failure_score_commentary9 => p_failure_score_commentary9,
275       failure_score_commentary10 => p_failure_score_commentary10,
276       maximum_credit_recommend => p_maximum_credit_recommend,
277       maximum_credit_currency_code => p_maximum_credit_currency_code,
278       displayed_duns_party_id => p_displayed_duns_party_id,
279       program_update_date => NULL,
280       created_by_module => NULL,
281       created_by_name => NULL,
282       creation_date => NULL,
283       last_update_date => NULL,
284       last_updated_by_name => NULL,
285       do_not_confuse_with => p_do_not_confuse_with,
286       actual_content_source => p_actual_content_source,
287       orig_sys_objs => HZ_ORIG_SYS_REF_OBJ_TBL(),
288       ext_attributes_objs => HZ_EXT_ATTRIBUTE_OBJ_TBL(),
289       contact_objs => HZ_ORG_CONTACT_BO_TBL(),
290       party_site_objs => HZ_PARTY_SITE_BO_TBL(),
291       preference_objs => HZ_PARTY_PREF_OBJ_TBL(),
292       phone_objs => HZ_PHONE_CP_BO_TBL(),
293       telex_objs => HZ_TELEX_CP_BO_TBL(),
294       email_objs => HZ_EMAIL_CP_BO_TBL(),
295       web_objs => HZ_WEB_CP_BO_TBL(),
296       edi_objs => HZ_EDI_CP_BO_TBL(),
297       eft_objs => HZ_EFT_CP_BO_TBL(),
298       relationship_objs => HZ_RELATIONSHIP_OBJ_TBL(),
299       class_objs => HZ_CODE_ASSIGNMENT_OBJ_TBL(),
300       financial_report_objs => HZ_FINANCIAL_BO_TBL(),
301       credit_rating_objs => HZ_CREDIT_RATING_OBJ_TBL(),
302       certification_objs => HZ_CERTIFICATION_OBJ_TBL(),
303       financial_prof_objs => HZ_FINANCIAL_PROF_OBJ_TBL(),
304       contact_pref_objs => HZ_CONTACT_PREF_OBJ_TBL(),
305       party_usage_objs => HZ_PARTY_USAGE_OBJ_TBL()
306     );
307   END create_object;
308 END;