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.

APPS.OE_OE_INLINE_ADDRESS dependencies on FND_PROFILE

Line 151: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');

147: l_person_rec.person_last_name:=p_contact_last_name;
148: l_person_rec.person_pre_name_adjunct:=p_contact_title;
149: l_person_rec.created_by_module := G_CREATED_BY_MODULE;
150:
151: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');
152: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');
153: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');
154:
155: -- if the party_number is not automatically generated then get it

Line 152: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');

148: l_person_rec.person_pre_name_adjunct:=p_contact_title;
149: l_person_rec.created_by_module := G_CREATED_BY_MODULE;
150:
151: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');
152: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');
153: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');
154:
155: -- if the party_number is not automatically generated then get it
156: -- from the sequence

Line 153: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');

149: l_person_rec.created_by_module := G_CREATED_BY_MODULE;
150:
151: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');
152: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');
153: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');
154:
155: -- if the party_number is not automatically generated then get it
156: -- from the sequence
157: if l_gen_party_number = 'N' then

Line 1775: fnd_profile.get('DEFAULT_COUNTRY',out_default_country_code);

1771:
1772:
1773: out_auto_cust_numbering :=sysparm.generate_customer_number;
1774: --g_home_country_code := sysparm.default_country;
1775: fnd_profile.get('DEFAULT_COUNTRY',out_default_country_code);
1776: fnd_profile.get('ONT_MANDATE_CUSTOMER_EMAIL',out_email_required);
1777:
1778: IF out_default_country_code is not null THEN
1779: select territory_short_name,address_style

Line 1776: fnd_profile.get('ONT_MANDATE_CUSTOMER_EMAIL',out_email_required);

1772:
1773: out_auto_cust_numbering :=sysparm.generate_customer_number;
1774: --g_home_country_code := sysparm.default_country;
1775: fnd_profile.get('DEFAULT_COUNTRY',out_default_country_code);
1776: fnd_profile.get('ONT_MANDATE_CUSTOMER_EMAIL',out_email_required);
1777:
1778: IF out_default_country_code is not null THEN
1779: select territory_short_name,address_style
1780: into out_default_country,out_address_style

Line 1785: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER',out_auto_party_numbering);

1781: from fnd_territories_vl
1782: where territory_code = out_default_country_code;
1783: END IF;
1784:
1785: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER',out_auto_party_numbering);
1786: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER',out_auto_site_numbering);
1787:
1788: if out_auto_site_numbering is null then
1789: out_auto_site_numbering :='Y';

Line 1786: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER',out_auto_site_numbering);

1782: where territory_code = out_default_country_code;
1783: END IF;
1784:
1785: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER',out_auto_party_numbering);
1786: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER',out_auto_site_numbering);
1787:
1788: if out_auto_site_numbering is null then
1789: out_auto_site_numbering :='Y';
1790: end if;