DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on FND_PROFILE

Line 1976: fnd_profile.get('DEFAULT_COUNTRY',l_default_country_code);

1972: WHERE HR.organization_id = FIN.org_id
1973: AND ( HR.name = p_org_name OR
1974: HR.organization_id = p_org_id);
1975:
1976: fnd_profile.get('DEFAULT_COUNTRY',l_default_country_code);
1977: --
1978: --
1979: if ( l_default_country_code is null ) then
1980: p_country_code := l_home_country_code;

Line 3263: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);

3259: -- Commenting this code as part of bug 5066199
3260: -- l_org_rec.sic_code := l_vendor_rec.sic_code;
3261: l_org_rec.tax_reference := l_vendor_rec.tax_reference;
3262:
3263: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
3264: IF nvl(l_party_num, 'Y') = 'N' THEN
3265: SELECT HZ_PARTY_NUMBER_S.Nextval
3266: INTO l_party_rec.party_number
3267: FROM DUAL;

Line 4448: fnd_profile.get('DEFAULT_COUNTRY',l_default_country_code);

4444: -- Validate the jgzz_fiscal_code value
4445: --
4446:
4447:
4448: fnd_profile.get('DEFAULT_COUNTRY',l_default_country_code);
4449:
4450: IF( l_default_country_code is null
4451: AND
4452: p_vendor_rec.set_of_books_id IS NOT NULL) then

Line 7579: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);

7575: --Bug 6753822 - Added NVL on vendor_type_lookup_code
7576: IF (NVL(l_vendor_type_lookup_code,'DUMMY') <> 'EMPLOYEE') then
7577: -- udhenuko Bug 6823885 start
7578: --We need to populate the party site number based on profile value.
7579: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
7580: IF nvl(l_party_site_num, 'Y') = 'N' THEN
7581: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
7582: INTO l_party_site_rec.party_site_number
7583: FROM DUAL;

Line 11565: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);

11561:
11562: l_per_rec.person_pre_name_adjunct := l_vendor_contact_rec.prefix;
11563: l_per_rec.person_name_phonetic := l_vendor_contact_rec.contact_name_phonetic;
11564:
11565: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
11566: IF nvl(l_party_num, 'Y') = 'N' THEN
11567: SELECT HZ_PARTY_NUMBER_S.Nextval
11568: INTO l_party_rec.party_number
11569: FROM DUAL;

Line 11632: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);

11628: l_rel_rec.start_date := sysdate;
11629: l_rel_rec.created_by_module := 'AP_SUPPLIERS_API';
11630: l_rel_rec.application_id := 200;
11631:
11632: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
11633: IF nvl(l_party_num, 'Y') = 'N' THEN
11634: SELECT HZ_PARTY_NUMBER_S.Nextval
11635: INTO l_party_rec.party_number
11636: FROM DUAL;

Line 11690: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);

11686: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
11687: l_party_site_rec.application_id := 200;
11688: l_party_site_rec.party_id := l_vendor_contact_rec.rel_party_id;
11689: -- udhenuko Bug 6823885 start. Party site number populated based on profile.
11690: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
11691: IF nvl(l_party_site_num, 'Y') = 'N' THEN
11692: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
11693: INTO l_party_site_rec.party_site_number
11694: FROM DUAL;