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 619: individual_1099,--bug6050423

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

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

728: p_vendor_rec.Hold_All_Payments_Flag,
729: p_vendor_rec.Hold_Future_Payments_Flag,
730: p_vendor_rec.Hold_Reason,
731: --bug6050423 starts.System inserts the taxpayer of
732: --non-employee individuals to the individual_1099 field.
733: --we donot insert any value to num_1099,becas we update
734: --it using the ap_tca_sync_pkg.sync_supplier
735: --bug6691916.commented the below decode statement and added
736: --the one below that.As per analysis,only organization type lookup

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

733: --we donot insert any value to num_1099,becas we update
734: --it using the ap_tca_sync_pkg.sync_supplier
735: --bug6691916.commented the below decode statement and added
736: --the one below that.As per analysis,only organization type lookup
737: --code of individual or foreign individual are considered
738: --as individual suppliers
739: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
740: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
741: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 738: --as individual suppliers

734: --it using the ap_tca_sync_pkg.sync_supplier
735: --bug6691916.commented the below decode statement and added
736: --the one below that.As per analysis,only organization type lookup
737: --code of individual or foreign individual are considered
738: --as individual suppliers
739: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
740: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
741: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
742: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 741: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

737: --code of individual or foreign individual are considered
738: --as individual suppliers
739: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
740: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
741: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
742: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
743: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
744: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
745: NULL),

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

738: --as individual suppliers
739: /*decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
740: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
741: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
742: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
743: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
744: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
745: NULL),
746: NULL),*/

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

740: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
741: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
742: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
743: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
744: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
745: NULL),
746: NULL),*/
747: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
748: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 748: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

744: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
745: NULL),
746: NULL),*/
747: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
748: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
749: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
750: NULL),
751: --bug6050423 ends
752: p_vendor_rec.Type_1099,

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

745: NULL),
746: NULL),*/
747: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
748: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
749: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
750: NULL),
751: --bug6050423 ends
752: p_vendor_rec.Type_1099,
753: p_vendor_rec.withholding_status_Lookup_Code,

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

1228: hold_reason = p_vendor_rec.Hold_Reason,
1229: --bug6050423 starts
1230: --bug6691916.commented the below assignment statement and added
1231: --the one below that.As per analysis,only organization type lookup
1232: --code of individual or foreign individual are considered
1233: --as individual suppliers
1234: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1235: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1236: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

Line 1233: --as individual suppliers

1229: --bug6050423 starts
1230: --bug6691916.commented the below assignment statement and added
1231: --the one below that.As per analysis,only organization type lookup
1232: --code of individual or foreign individual are considered
1233: --as individual suppliers
1234: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1235: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1236: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1237: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

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

1230: --bug6691916.commented the below assignment statement and added
1231: --the one below that.As per analysis,only organization type lookup
1232: --code of individual or foreign individual are considered
1233: --as individual suppliers
1234: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1235: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1236: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1237: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1238: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,

Line 1236: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

1232: --code of individual or foreign individual are considered
1233: --as individual suppliers
1234: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1235: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1236: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1237: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1238: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1239: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1240: NULL),

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

1233: --as individual suppliers
1234: /*individual_1099 = decode(UPPER(p_vendor_rec.Vendor_Type_Lookup_Code),'CONTRACTOR',
1235: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1236: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1237: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1238: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1239: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1240: NULL),
1241: NULL),*/

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

1235: decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1236: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1237: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1238: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1239: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1240: NULL),
1241: NULL),*/
1242: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1243: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

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

1238: 'PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1239: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1240: NULL),
1241: NULL),*/
1242: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1243: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1244: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1245: NULL),
1246: --bug6050423 ends

Line 1243: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,

1239: 'INDIVIDUAL PARTNERSHIP',p_vendor_rec.jgzz_fiscal_code,
1240: NULL),
1241: NULL),*/
1242: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1243: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1244: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1245: NULL),
1246: --bug6050423 ends
1247: type_1099 = p_vendor_rec.Type_1099,

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

1240: NULL),
1241: NULL),*/
1242: individual_1099 = decode(UPPER(p_vendor_rec.Organization_Type_Lookup_Code),
1243: 'INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1244: 'FOREIGN INDIVIDUAL',p_vendor_rec.jgzz_fiscal_code,
1245: NULL),
1246: --bug6050423 ends
1247: type_1099 = p_vendor_rec.Type_1099,
1248: withholding_status_lookup_code = p_vendor_rec.withholding_status_Lookup_Code,