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 3678: --individual contractors and employees.

3674: l_org_rec.organization_name_phonetic :=
3675: l_vendor_rec.vendor_name_alt;
3676:
3677: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3678: --individual contractors and employees.
3679: --taxpayer id of individual contractors is stored only in ap_suppliers.
3680: --bug6691916.commented the below if clause and added the one below that.
3681: --as per analysis,only organization lookup code of type individual
3682: --and foreign individual belong to individual suppliers category.

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

3675: l_vendor_rec.vendor_name_alt;
3676:
3677: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3678: --individual contractors and employees.
3679: --taxpayer id of individual contractors is stored only in ap_suppliers.
3680: --bug6691916.commented the below if clause and added the one below that.
3681: --as per analysis,only organization lookup code of type individual
3682: --and foreign individual belong to individual suppliers category.
3683:

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

3677: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3678: --individual contractors and employees.
3679: --taxpayer id of individual contractors is stored only in ap_suppliers.
3680: --bug6691916.commented the below if clause and added the one below that.
3681: --as per analysis,only organization lookup code of type individual
3682: --and foreign individual belong to individual suppliers category.
3683:
3684: IF ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
3685: ('INDIVIDUAL','FOREIGN INDIVIDUAL')

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

3678: --individual contractors and employees.
3679: --taxpayer id of individual contractors is stored only in ap_suppliers.
3680: --bug6691916.commented the below if clause and added the one below that.
3681: --as per analysis,only organization lookup code of type individual
3682: --and foreign individual belong to individual suppliers category.
3683:
3684: IF ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
3685: ('INDIVIDUAL','FOREIGN INDIVIDUAL')
3686: OR

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

3681: --as per analysis,only organization lookup code of type individual
3682: --and foreign individual belong to individual suppliers category.
3683:
3684: IF ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
3685: ('INDIVIDUAL','FOREIGN INDIVIDUAL')
3686: OR
3687: (UPPER(p_vendor_rec.vendor_type_lookup_code)='EMPLOYEE')) THEN
3688: l_org_rec.jgzz_fiscal_code :=NULL;
3689: ELSE

Line 3704: FROM DUAL;

3700: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
3701: IF nvl(l_party_num, 'Y') = 'N' THEN
3702: SELECT HZ_PARTY_NUMBER_S.Nextval
3703: INTO l_party_rec.party_number
3704: FROM DUAL;
3705: END IF;
3706:
3707: l_org_rec.party_rec := l_party_rec;
3708:

Line 4556: --of individual contractors into ap_suppliers

4552: ,decode(l_vendor_rec.terms_id,
4553: ap_null_num,NULL,
4554: nvl(l_vendor_rec.terms_id, terms_id ))
4555: --bug6050423 starts.system inserts taxpayer id
4556: --of individual contractors into ap_suppliers
4557: ,decode(l_vendor_rec.jgzz_fiscal_code,
4558: ap_null_char,NULL,
4559: nvl(l_vendor_rec.jgzz_fiscal_code,nvl(individual_1099,num_1099)))
4560: --bug6050423 ends

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

4555: --bug6050423 starts.system inserts taxpayer id
4556: --of individual contractors into ap_suppliers
4557: ,decode(l_vendor_rec.jgzz_fiscal_code,
4558: ap_null_char,NULL,
4559: nvl(l_vendor_rec.jgzz_fiscal_code,nvl(individual_1099,num_1099)))
4560: --bug6050423 ends
4561: ,decode(l_vendor_rec.type_1099,
4562: ap_null_char,NULL,
4563: nvl(l_vendor_rec.type_1099, type_1099))

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

4906: --
4907: IF p_vendor_rec.vat_code is NOT NULL THEN
4908: -- Checking the vat code in the tax tables
4909: l_status := 0;
4910: SELECT COUNT(*) INTO l_status FROM DUAL WHERE EXISTS (
4911: SELECT 'Y'
4912: FROM zx_input_classifications_v
4913: WHERE lookup_type in ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
4914: AND org_id = -99

Line 5086: --contractor individuals

5082: END IF;
5083: END IF;
5084:
5085: --bug6050423.Added the below validation for num_1099 for
5086: --contractor individuals
5087: --bug6691916.commented the below if clause and added the one below that.
5088: --as per analysis,only organization lookup code of type individual
5089: --and foreign individual belong to individual suppliers category.
5090:

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

5084:
5085: --bug6050423.Added the below validation for num_1099 for
5086: --contractor individuals
5087: --bug6691916.commented the below if clause and added the one below that.
5088: --as per analysis,only organization lookup code of type individual
5089: --and foreign individual belong to individual suppliers category.
5090:
5091: /* if ( UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR'
5092: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN

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

5085: --bug6050423.Added the below validation for num_1099 for
5086: --contractor individuals
5087: --bug6691916.commented the below if clause and added the one below that.
5088: --as per analysis,only organization lookup code of type individual
5089: --and foreign individual belong to individual suppliers category.
5090:
5091: /* if ( UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR'
5092: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
5093: ('INDIVIDUAL','FOREIGN INDIVIDUAL',

Line 5093: ('INDIVIDUAL','FOREIGN INDIVIDUAL',

5089: --and foreign individual belong to individual suppliers category.
5090:
5091: /* if ( UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR'
5092: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
5093: ('INDIVIDUAL','FOREIGN INDIVIDUAL',
5094: 'PARTNERSHIP','FOREIGN PARTNERSHIP') )THEN*/
5095: if ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
5096: ('INDIVIDUAL','FOREIGN INDIVIDUAL') )THEN
5097: ------------------------------------------------------------------------

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

5092: AND UPPER(p_vendor_rec.organization_type_lookup_code) IN
5093: ('INDIVIDUAL','FOREIGN INDIVIDUAL',
5094: 'PARTNERSHIP','FOREIGN PARTNERSHIP') )THEN*/
5095: if ( UPPER(p_vendor_rec.organization_type_lookup_code) IN
5096: ('INDIVIDUAL','FOREIGN INDIVIDUAL') )THEN
5097: ------------------------------------------------------------------------
5098: l_debug_info := 'Call to Validate the jgzz_fiscal_code value';
5099: ------------------------------------------------------------------------
5100: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 8608: FROM DUAL;

8604: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
8605: IF nvl(l_party_site_num, 'Y') = 'N' THEN
8606: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
8607: INTO l_party_site_rec.party_site_number
8608: FROM DUAL;
8609: END IF;
8610: -- udhenuko Bug 6823885 End
8611: hz_party_site_v2pub.create_party_site(
8612: p_init_msg_list => FND_API.G_FALSE,

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

10209: --
10210: IF p_vendor_site_rec.vat_code is NOT NULL THEN
10211: -- Checking the vat code in the tax tables
10212: l_status := 0;
10213: SELECT COUNT(*) INTO l_status FROM DUAL WHERE EXISTS (
10214: SELECT 'Y'
10215: FROM zx_input_classifications_v
10216: WHERE lookup_type in ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
10217: AND org_id in ( p_vendor_site_rec.org_id, -99)

Line 13987: FROM DUAL;

13983: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
13984: IF nvl(l_party_num, 'Y') = 'N' THEN
13985: SELECT HZ_PARTY_NUMBER_S.Nextval
13986: INTO l_party_rec.party_number
13987: FROM DUAL;
13988: END IF;
13989:
13990: l_per_rec.party_rec := l_party_rec;
13991: hz_party_v2pub.create_person(

Line 14099: FROM DUAL;

14095: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
14096: IF nvl(l_party_num, 'Y') = 'N' THEN
14097: SELECT HZ_PARTY_NUMBER_S.Nextval
14098: INTO l_party_rec.party_number
14099: FROM DUAL;
14100: END IF;
14101:
14102: l_rel_rec.party_rec := l_party_rec;
14103:

Line 14203: FROM DUAL;

14199: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
14200: IF nvl(l_party_site_num, 'Y') = 'N' THEN
14201: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
14202: INTO l_party_site_rec.party_site_number
14203: FROM DUAL;
14204: END IF;
14205: -- udhenuko Bug 6823885 End
14206:
14207: hz_party_site_v2pub.create_party_site(

Line 14712: FROM dual;

14708:
14709:
14710: SELECT po_vendor_contacts_s.nextval
14711: INTO l_vendor_contact_rec.vendor_contact_id
14712: FROM dual;
14713:
14714: INSERT INTO ap_supplier_contacts(
14715: per_party_id,
14716: relationship_id,

Line 18021: FROM dual;

18017: );
18018:
18019: SELECT to_char(ap_supplier_event_s.nextval)
18020: INTO l_event_key
18021: FROM dual;
18022:
18023: wf_event.raise( p_event_name => l_event_name,
18024: p_event_key => l_event_key,
18025: p_parameters => l_parameter_list);