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 AP_VENDORS_PKG

Line 1: PACKAGE BODY AP_VENDORS_PKG as

1: PACKAGE BODY AP_VENDORS_PKG as
2: /* $Header: apvndhrb.pls 120.20 2011/07/05 12:34:29 lkarna ship $ */
3: --
4: --
5: FUNCTION Update_Product_Setup Return Number;

Line 167: current_calling_sequence := 'AP_VENDORS_PKG.INSERT_ROW<-' ||

163:
164: BEGIN
165: -- Update the calling sequence
166: --
167: current_calling_sequence := 'AP_VENDORS_PKG.INSERT_ROW<-' ||
168: X_calling_sequence;
169:
170: --
171: -- error out NOCOPY if Vendor name has been assigned by another session

Line 173: ap_vendors_pkg.check_unique_vendor_name( p_vendor_id => x_vendor_id,

169:
170: --
171: -- error out NOCOPY if Vendor name has been assigned by another session
172: --
173: ap_vendors_pkg.check_unique_vendor_name( p_vendor_id => x_vendor_id,
174: p_vendor_name => x_vendor_name,
175: X_calling_sequence => current_calling_sequence );
176: --
177: -- error out NOCOPY if employee has been assigned by another session

Line 179: ap_vendors_pkg.Check_Duplicate_Employee(p_rowid => x_rowid,

175: X_calling_sequence => current_calling_sequence );
176: --
177: -- error out NOCOPY if employee has been assigned by another session
178: --
179: ap_vendors_pkg.Check_Duplicate_Employee(p_rowid => x_rowid,
180: p_employee_id => x_employee_id,
181: X_calling_sequence => current_calling_sequence);
182: --
183: -- assign automatic Vendor number if needed

Line 225: ap_vendors_pkg.check_unique_vendor_number( p_vendor_id => x_vendor_id,

221:
222: end if;
223: --
224: --
225: ap_vendors_pkg.check_unique_vendor_number( p_vendor_id => x_vendor_id,
226: p_vendor_number => x_segment1,
227: X_calling_sequence => current_calling_sequence );
228: --
229: --

Line 1020: current_calling_sequence := 'AP_VENDORS_PKG.UPDATE_ROW<-' ||

1016: debug_info VARCHAR2(100);
1017: BEGIN
1018: -- Update the calling sequence
1019: --
1020: current_calling_sequence := 'AP_VENDORS_PKG.UPDATE_ROW<-' ||
1021: X_calling_sequence;
1022: --
1023: -- error out NOCOPY if Vendor name has been assigned by another session
1024: --

Line 1025: ap_vendors_pkg.check_unique_vendor_name( p_vendor_id => x_vendor_id,

1021: X_calling_sequence;
1022: --
1023: -- error out NOCOPY if Vendor name has been assigned by another session
1024: --
1025: ap_vendors_pkg.check_unique_vendor_name( p_vendor_id => x_vendor_id,
1026: p_vendor_name => x_vendor_name,
1027: X_calling_sequence => current_calling_sequence);
1028: --
1029: -- check for duplicate vendor_numbers

Line 1031: ap_vendors_pkg.check_unique_vendor_number( p_vendor_id => x_vendor_id,

1027: X_calling_sequence => current_calling_sequence);
1028: --
1029: -- check for duplicate vendor_numbers
1030: --
1031: ap_vendors_pkg.check_unique_vendor_number( p_vendor_id => x_vendor_id,
1032: p_vendor_number => x_segment1,
1033: X_calling_sequence => current_calling_sequence);
1034: --
1035: -- error out NOCOPY if employee has been assigned by another session

Line 1037: ap_vendors_pkg.Check_Duplicate_Employee(p_rowid => x_rowid,

1033: X_calling_sequence => current_calling_sequence);
1034: --
1035: -- error out NOCOPY if employee has been assigned by another session
1036: --
1037: ap_vendors_pkg.Check_Duplicate_Employee(p_rowid => x_rowid,
1038: p_employee_id => x_employee_id,
1039: X_calling_sequence => current_calling_sequence);
1040:
1041: debug_info := 'Update PO_VENDORS';

Line 1529: current_calling_sequence := 'AP_VENDORS_PKG.LOCK_ROW<-' ||

1525: --
1526: BEGIN
1527: -- Update the calling sequence
1528: --
1529: current_calling_sequence := 'AP_VENDORS_PKG.LOCK_ROW<-' ||
1530: X_calling_sequence;
1531:
1532: debug_info := 'Open cursor C';
1533: OPEN C;

Line 1966: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_UNIQUE_VENDOR_NAME<-' ||

1962: --
1963: BEGIN
1964: -- Update the calling sequence
1965: --
1966: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_UNIQUE_VENDOR_NAME<-' ||
1967: X_calling_sequence;
1968:
1969: debug_info := 'Count vendors with same name';
1970: SELECT count(1)

Line 2020: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_DENORMALIZED_VENDOR_NAME<-' ||

2016: --
2017: begin
2018: -- Update the calling sequence
2019: --
2020: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_DENORMALIZED_VENDOR_NAME<-' ||
2021: X_calling_sequence;
2022:
2023: debug_info := 'Count overlap count for the vendor_id and site_id';
2024: SELECT count(1)

Line 2065: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_UNIQUE_VENDOR_NUMBER<-' ||

2061: --
2062: BEGIN
2063: -- Update the calling sequence
2064: --
2065: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_UNIQUE_VENDOR_NUMBER<-' ||
2066: X_calling_sequence;
2067: --
2068: --
2069: debug_info := 'Count overlap for vendor number';

Line 2124: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_SELECTED_INVOICES<-' ||

2120: debug_info VARCHAR2(100);
2121: BEGIN
2122: -- Update the calling sequence
2123: --
2124: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_SELECTED_INVOICES<-' ||
2125: X_calling_sequence;
2126:
2127: debug_info := 'Count from AP_selected_invoices';
2128: select count(1)

Line 2159: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_DUPLICATE_EMPLOYEE<-' ||

2155: debug_info VARCHAR2(100);
2156: begin
2157: -- Update the calling sequence
2158: --
2159: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_DUPLICATE_EMPLOYEE<-' ||
2160: X_calling_sequence;
2161:
2162: debug_info := 'Count for same employee_id';
2163: SELECT count(1)

Line 2202: current_calling_sequence := 'AP_VENDORS_PKG.RESOLVE_EMPLOYEE<-' ||

2198: begin
2199:
2200: -- Update the calling sequence
2201: --
2202: current_calling_sequence := 'AP_VENDORS_PKG.RESOLVE_EMPLOYEE<-' ||
2203: X_calling_sequence;
2204:
2205: -- For bug 2437569. Changed the view from hr_employees to
2206: -- hr_employees_current_v. This is to retrive the record details

Line 2283: END AP_VENDORS_PKG;

2279: return l_segment1;
2280:
2281: END Update_Product_Setup;
2282:
2283: END AP_VENDORS_PKG;