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.AP_VENDOR_PUB_PKG dependencies on DUAL

Line 3236: --individual contractors and employees.

3232: l_org_rec.organization_name_phonetic :=
3233: l_vendor_rec.vendor_name_alt;
3234:
3235: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3236: --individual contractors and employees.
3237: --taxpayer id of individual contractors is stored only in ap_suppliers.
3238: --bug6691916.commented the below if clause and added the one below that.
3239: --as per analysis,only organization lookup code of type individual
3240: --and foreign individual belong to individual suppliers category.

Line 3237: --taxpayer id of individual contractors is stored only in ap_suppliers.

3233: l_vendor_rec.vendor_name_alt;
3234:
3235: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3236: --individual contractors and employees.
3237: --taxpayer id of individual contractors is stored only in ap_suppliers.
3238: --bug6691916.commented the below if clause and added the one below that.
3239: --as per analysis,only organization lookup code of type individual
3240: --and foreign individual belong to individual suppliers category.
3241: /*IF ( ((UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR')

Line 3239: --as per analysis,only organization lookup code of type individual

3235: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3236: --individual contractors and employees.
3237: --taxpayer id of individual contractors is stored only in ap_suppliers.
3238: --bug6691916.commented the below if clause and added the one below that.
3239: --as per analysis,only organization lookup code of type individual
3240: --and foreign individual belong to individual suppliers category.
3241: /*IF ( ((UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR')
3242: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
3243: ('INDIVIDUAL','FOREIGN INDIVIDUAL',

Line 3240: --and foreign individual belong to individual suppliers category.

3236: --individual contractors and employees.
3237: --taxpayer id of individual contractors is stored only in ap_suppliers.
3238: --bug6691916.commented the below if clause and added the one below that.
3239: --as per analysis,only organization lookup code of type individual
3240: --and foreign individual belong to individual suppliers category.
3241: /*IF ( ((UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR')
3242: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
3243: ('INDIVIDUAL','FOREIGN INDIVIDUAL',
3244: 'PARTNERSHIP','FOREIGN PARTNERSHIP') )

Line 3243: ('INDIVIDUAL','FOREIGN INDIVIDUAL',

3239: --as per analysis,only organization lookup code of type individual
3240: --and foreign individual belong to individual suppliers category.
3241: /*IF ( ((UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR')
3242: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
3243: ('INDIVIDUAL','FOREIGN INDIVIDUAL',
3244: 'PARTNERSHIP','FOREIGN PARTNERSHIP') )
3245: OR (UPPER(p_vendor_rec.vendor_type_lookup_code)='EMPLOYEE')) THEN*/
3246:
3247: IF ( UPPER(p_vendor_rec.organization_type_lookup_code) IN

Line 3248: ('INDIVIDUAL','FOREIGN INDIVIDUAL')

3244: 'PARTNERSHIP','FOREIGN PARTNERSHIP') )
3245: OR (UPPER(p_vendor_rec.vendor_type_lookup_code)='EMPLOYEE')) THEN*/
3246:
3247: IF ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
3248: ('INDIVIDUAL','FOREIGN INDIVIDUAL')
3249: OR
3250: (UPPER(p_vendor_rec.vendor_type_lookup_code)='EMPLOYEE')) THEN
3251: l_org_rec.jgzz_fiscal_code :=NULL;
3252: ELSE

Line 3267: FROM DUAL;

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;
3268: END IF;
3269:
3270: l_org_rec.party_rec := l_party_rec;
3271:

Line 3966: --of individual contractors into ap_suppliers

3962: ,decode(l_vendor_rec.terms_id,
3963: ap_null_num,NULL,
3964: nvl(l_vendor_rec.terms_id, terms_id ))
3965: --bug6050423 starts.system inserts taxpayer id
3966: --of individual contractors into ap_suppliers
3967: ,decode(l_vendor_rec.jgzz_fiscal_code,
3968: ap_null_char,NULL,
3969: nvl(l_vendor_rec.jgzz_fiscal_code,nvl(individual_1099,num_1099)))
3970: --bug6050423 ends

Line 3969: nvl(l_vendor_rec.jgzz_fiscal_code,nvl(individual_1099,num_1099)))

3965: --bug6050423 starts.system inserts taxpayer id
3966: --of individual contractors into ap_suppliers
3967: ,decode(l_vendor_rec.jgzz_fiscal_code,
3968: ap_null_char,NULL,
3969: nvl(l_vendor_rec.jgzz_fiscal_code,nvl(individual_1099,num_1099)))
3970: --bug6050423 ends
3971: ,decode(l_vendor_rec.type_1099,
3972: ap_null_char,NULL,
3973: nvl(l_vendor_rec.type_1099, type_1099))

Line 4425: --contractor individuals

4421: END IF;
4422: END IF;
4423:
4424: --bug6050423.Added the below validation for num_1099 for
4425: --contractor individuals
4426: --bug6691916.commented the below if clause and added the one below that.
4427: --as per analysis,only organization lookup code of type individual
4428: --and foreign individual belong to individual suppliers category.
4429:

Line 4427: --as per analysis,only organization lookup code of type individual

4423:
4424: --bug6050423.Added the below validation for num_1099 for
4425: --contractor individuals
4426: --bug6691916.commented the below if clause and added the one below that.
4427: --as per analysis,only organization lookup code of type individual
4428: --and foreign individual belong to individual suppliers category.
4429:
4430: /* if ( UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR'
4431: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN

Line 4428: --and foreign individual belong to individual suppliers category.

4424: --bug6050423.Added the below validation for num_1099 for
4425: --contractor individuals
4426: --bug6691916.commented the below if clause and added the one below that.
4427: --as per analysis,only organization lookup code of type individual
4428: --and foreign individual belong to individual suppliers category.
4429:
4430: /* if ( UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR'
4431: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
4432: ('INDIVIDUAL','FOREIGN INDIVIDUAL',

Line 4432: ('INDIVIDUAL','FOREIGN INDIVIDUAL',

4428: --and foreign individual belong to individual suppliers category.
4429:
4430: /* if ( UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR'
4431: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
4432: ('INDIVIDUAL','FOREIGN INDIVIDUAL',
4433: 'PARTNERSHIP','FOREIGN PARTNERSHIP') )THEN*/
4434: if ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
4435: ('INDIVIDUAL','FOREIGN INDIVIDUAL') )THEN
4436: ------------------------------------------------------------------------

Line 4435: ('INDIVIDUAL','FOREIGN INDIVIDUAL') )THEN

4431: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
4432: ('INDIVIDUAL','FOREIGN INDIVIDUAL',
4433: 'PARTNERSHIP','FOREIGN PARTNERSHIP') )THEN*/
4434: if ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
4435: ('INDIVIDUAL','FOREIGN INDIVIDUAL') )THEN
4436: ------------------------------------------------------------------------
4437: l_debug_info := 'Call to Validate the jgzz_fiscal_code value';
4438: ------------------------------------------------------------------------
4439: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7583: FROM DUAL;

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;
7584: END IF;
7585: -- udhenuko Bug 6823885 End
7586: hz_party_site_v2pub.create_party_site(
7587: p_init_msg_list => FND_API.G_FALSE,

Line 8818: SELECT COUNT(*) INTO l_status FROM DUAL WHERE EXISTS (

8814: --
8815: IF p_vendor_site_rec.vat_code is NOT NULL THEN
8816: -- Checking the vat code in the tax tables
8817: l_status := 0;
8818: SELECT COUNT(*) INTO l_status FROM DUAL WHERE EXISTS (
8819: SELECT 'Y'
8820: FROM zx_input_classifications_v
8821: WHERE lookup_type in ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
8822: AND org_id in ( p_vendor_site_rec.org_id, -99)

Line 11569: FROM DUAL;

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;
11570: END IF;
11571:
11572: l_per_rec.party_rec := l_party_rec;
11573:

Line 11636: FROM DUAL;

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;
11637: END IF;
11638:
11639: l_rel_rec.party_rec := l_party_rec;
11640:

Line 11694: FROM DUAL;

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;
11695: END IF;
11696: -- udhenuko Bug 6823885 End
11697:
11698: hz_party_site_v2pub.create_party_site(

Line 11921: FROM dual;

11917:
11918:
11919: SELECT po_vendor_contacts_s.nextval
11920: INTO l_vendor_contact_rec.vendor_contact_id
11921: FROM dual;
11922:
11923: INSERT INTO ap_supplier_contacts(
11924: per_party_id,
11925: relationship_id,

Line 14388: FROM dual;

14384: );
14385:
14386: SELECT to_char(ap_supplier_event_s.nextval)
14387: INTO l_event_key
14388: FROM dual;
14389:
14390: wf_event.raise( p_event_name => l_event_name,
14391: p_event_key => l_event_key,
14392: p_parameters => l_parameter_list);