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_VENDORS_PKG dependencies on DUAL

Line 233: from sys.dual;

229: --
230: debug_info := 'Select next sequence value from PO_VENDORS_S';
231: Select PO_VENDORS_S.NEXTVAL
232: into x_vendor_id
233: from sys.dual;
234: --
235: --
236: debug_info := 'Insert into PO_VENDORS';
237: INSERT INTO ap_suppliers (

Line 584: from sys.dual;

580: --
581: debug_info := 'Select next sequence value from PO_VENDORS_S';
582: Select PO_VENDORS_S.NEXTVAL
583: into x_vendor_id
584: from sys.dual;
585: --
586: --
587:
588: debug_info := 'Insert into ap_suppliers';

Line 620: individual_1099,--bug6050423

616: invoice_amount_limit,
617: hold_all_payments_flag,
618: hold_future_payments_flag,
619: hold_reason,
620: individual_1099,--bug6050423
621: type_1099,
622: withholding_status_lookup_code,
623: withholding_start_date,
624: organization_type_lookup_code,

Line 742: --non-employee individuals to the individual_1099 field.

738: p_vendor_rec.Hold_All_Payments_Flag,
739: p_vendor_rec.Hold_Future_Payments_Flag,
740: p_vendor_rec.Hold_Reason,
741: --bug6050423 starts.System inserts the taxpayer of
742: --non-employee individuals to the individual_1099 field.
743: --we donot insert any value to num_1099,becas we update
744: --it using the ap_tca_sync_pkg.sync_supplier
745: --bug6691916.commented the below decode statement and added
746: --the one below that.As per analysis,only organization type lookup

Line 747: --code of individual or foreign individual are considered

743: --we donot insert any value to num_1099,becas we update
744: --it using the ap_tca_sync_pkg.sync_supplier
745: --bug6691916.commented the below decode statement and added
746: --the one below that.As per analysis,only organization type lookup
747: --code of individual or foreign individual are considered
748: --as individual suppliers
749: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
750: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
751: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 748: --as individual suppliers

744: --it using the ap_tca_sync_pkg.sync_supplier
745: --bug6691916.commented the below decode statement and added
746: --the one below that.As per analysis,only organization type lookup
747: --code of individual or foreign individual are considered
748: --as individual suppliers
749: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
750: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
751: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
752: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 751: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

747: --code of individual or foreign individual are considered
748: --as individual suppliers
749: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
750: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
751: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
752: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
753: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
754: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
755: NULL),

Line 752: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

748: --as individual suppliers
749: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
750: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
751: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
752: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
753: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
754: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
755: NULL),
756: NULL),*/

Line 754: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,

750: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
751: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
752: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
753: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
754: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
755: NULL),
756: NULL),*/
757: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
758: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 758: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

754: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
755: NULL),
756: NULL),*/
757: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
758: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
759: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
760: NULL),
761: --bug6050423 ends
762: p_vendor_rec.Type_1099,

Line 759: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

755: NULL),
756: NULL),*/
757: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
758: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
759: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
760: NULL),
761: --bug6050423 ends
762: p_vendor_rec.Type_1099,
763: p_vendor_rec.withholding_status_Lookup_Code,

Line 1250: --code of individual or foreign individual are considered

1246: hold_reason = p_vendor_rec.Hold_Reason,
1247: --bug6050423 starts
1248: --bug6691916.commented the below assignment statement and added
1249: --the one below that.As per analysis,only organization type lookup
1250: --code of individual or foreign individual are considered
1251: --as individual suppliers
1252: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1253: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1254: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 1251: --as individual suppliers

1247: --bug6050423 starts
1248: --bug6691916.commented the below assignment statement and added
1249: --the one below that.As per analysis,only organization type lookup
1250: --code of individual or foreign individual are considered
1251: --as individual suppliers
1252: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1253: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1254: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1255: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 1252: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',

1248: --bug6691916.commented the below assignment statement and added
1249: --the one below that.As per analysis,only organization type lookup
1250: --code of individual or foreign individual are considered
1251: --as individual suppliers
1252: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1253: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1254: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1255: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1256: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,

Line 1254: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

1250: --code of individual or foreign individual are considered
1251: --as individual suppliers
1252: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1253: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1254: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1255: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1256: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1257: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1258: NULL),

Line 1255: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

1251: --as individual suppliers
1252: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1253: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1254: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1255: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1256: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1257: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1258: NULL),
1259: NULL),*/

Line 1257: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,

1253: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1254: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1255: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1256: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1257: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1258: NULL),
1259: NULL),*/
1260: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1261: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 1260: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),

1256: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1257: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1258: NULL),
1259: NULL),*/
1260: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1261: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1262: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1263: NULL),
1264: --bug6050423 ends

Line 1261: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

1257: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1258: NULL),
1259: NULL),*/
1260: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1261: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1262: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1263: NULL),
1264: --bug6050423 ends
1265: type_1099 = p_vendor_rec.Type_1099,

Line 1262: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

1258: NULL),
1259: NULL),*/
1260: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1261: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1262: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1263: NULL),
1264: --bug6050423 ends
1265: type_1099 = p_vendor_rec.Type_1099,
1266: withholding_status_lookup_code = p_vendor_rec.withholding_status_Lookup_Code,