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.15.12010000.3 2008/12/29 07:57:16 mayyalas 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 1002: current_calling_sequence := 'AP_VENDORS_PKG.UPDATE_ROW<-' ||

998: debug_info VARCHAR2(100);
999: BEGIN
1000: -- Update the calling sequence
1001: --
1002: current_calling_sequence := 'AP_VENDORS_PKG.UPDATE_ROW<-' ||
1003: X_calling_sequence;
1004: --
1005: -- error out NOCOPY if Vendor name has been assigned by another session
1006: --

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

1003: X_calling_sequence;
1004: --
1005: -- error out NOCOPY if Vendor name has been assigned by another session
1006: --
1007: ap_vendors_pkg.check_unique_vendor_name( p_vendor_id => x_vendor_id,
1008: p_vendor_name => x_vendor_name,
1009: X_calling_sequence => current_calling_sequence);
1010: --
1011: -- check for duplicate vendor_numbers

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

1009: X_calling_sequence => current_calling_sequence);
1010: --
1011: -- check for duplicate vendor_numbers
1012: --
1013: ap_vendors_pkg.check_unique_vendor_number( p_vendor_id => x_vendor_id,
1014: p_vendor_number => x_segment1,
1015: X_calling_sequence => current_calling_sequence);
1016: --
1017: -- error out NOCOPY if employee has been assigned by another session

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

1015: X_calling_sequence => current_calling_sequence);
1016: --
1017: -- error out NOCOPY if employee has been assigned by another session
1018: --
1019: ap_vendors_pkg.Check_Duplicate_Employee(p_rowid => x_rowid,
1020: p_employee_id => x_employee_id,
1021: X_calling_sequence => current_calling_sequence);
1022:
1023: debug_info := 'Update PO_VENDORS';

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

1499: --
1500: BEGIN
1501: -- Update the calling sequence
1502: --
1503: current_calling_sequence := 'AP_VENDORS_PKG.LOCK_ROW<-' ||
1504: X_calling_sequence;
1505:
1506: debug_info := 'Open cursor C';
1507: OPEN C;

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

1936: --
1937: BEGIN
1938: -- Update the calling sequence
1939: --
1940: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_UNIQUE_VENDOR_NAME<-' ||
1941: X_calling_sequence;
1942:
1943: debug_info := 'Count vendors with same name';
1944: SELECT count(1)

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

1990: --
1991: begin
1992: -- Update the calling sequence
1993: --
1994: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_DENORMALIZED_VENDOR_NAME<-' ||
1995: X_calling_sequence;
1996:
1997: debug_info := 'Count overlap count for the vendor_id and site_id';
1998: SELECT count(1)

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

2035: --
2036: BEGIN
2037: -- Update the calling sequence
2038: --
2039: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_UNIQUE_VENDOR_NUMBER<-' ||
2040: X_calling_sequence;
2041: --
2042: --
2043: debug_info := 'Count overlap for vendor number';

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

2094: debug_info VARCHAR2(100);
2095: BEGIN
2096: -- Update the calling sequence
2097: --
2098: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_SELECTED_INVOICES<-' ||
2099: X_calling_sequence;
2100:
2101: debug_info := 'Count from AP_selected_invoices';
2102: select count(1)

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

2129: debug_info VARCHAR2(100);
2130: begin
2131: -- Update the calling sequence
2132: --
2133: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_DUPLICATE_EMPLOYEE<-' ||
2134: X_calling_sequence;
2135:
2136: debug_info := 'Count for same employee_id';
2137: SELECT count(1)

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

2172: begin
2173:
2174: -- Update the calling sequence
2175: --
2176: current_calling_sequence := 'AP_VENDORS_PKG.RESOLVE_EMPLOYEE<-' ||
2177: X_calling_sequence;
2178:
2179: -- For bug 2437569. Changed the view from hr_employees to
2180: -- hr_employees_current_v. This is to retrive the record details

Line 2257: END AP_VENDORS_PKG;

2253: return l_segment1;
2254:
2255: END Update_Product_Setup;
2256:
2257: END AP_VENDORS_PKG;