APPS.AP_VENDOR_SITES_PKG dependencies on AP_VENDOR_SITES_PKG

Line 1: PACKAGE BODY AP_VENDOR_SITES_PKG as

1: PACKAGE BODY AP_VENDOR_SITES_PKG as
2: /* $Header: apvndsib.pls 120.19.12010000.6 2008/12/29 07:57:55 mayyalas ship $ */
3: --
4: --
5: function format_address( country_code varchar2,

Line 218: current_calling_sequence := 'AP_VENDOR_SITES_PKG.INSERT_ROW<-' ||

214:
215: BEGIN
216: -- Update the calling sequence
217: --
218: current_calling_sequence := 'AP_VENDOR_SITES_PKG.INSERT_ROW<-' ||
219: X_calling_sequence;
220:
221: Check_duplicate_vendor_site (x_vendor_id, x_vendor_site_code,
222: x_org_id, --MO Access Control

Line 1032: current_calling_sequence := 'AP_VENDOR_SITES_PKG.LOCK_ROW<-' ||

1028:
1029: BEGIN
1030: -- Update the calling sequence
1031: --
1032: current_calling_sequence := 'AP_VENDOR_SITES_PKG.LOCK_ROW<-' ||
1033: X_calling_sequence;
1034: debug_info := 'Open cursor C';
1035: OPEN C;
1036: debug_info := 'Fetch cursor C';

Line 1624: current_calling_sequence := 'AP_VENDOR_SITES_PKG.UPDATE_ROW<-' ||

1620:
1621: BEGIN
1622: -- Update the calling sequence
1623: --
1624: current_calling_sequence := 'AP_VENDOR_SITES_PKG.UPDATE_ROW<-' ||
1625: X_calling_sequence;
1626:
1627: -- Bug # 636963 Vendor site code can not be changed if same code exits in
1628: -- a different org.

Line 2015: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_VENDOR_OFFSETS

2011: debug_info varchar2(100);
2012: begin
2013: -- Update the calling sequence
2014: --
2015: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_VENDOR_OFFSETS
2016: <-' ||
2017: X_calling_sequence;
2018:
2019: debug_info := 'Count sites with offset';

Line 2060: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_DUPLICATE_VENDOR_SITE<-' ||

2056: debug_info varchar2(100);
2057: begin
2058: -- Update the calling sequence
2059: --
2060: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_DUPLICATE_VENDOR_SITE<-' ||
2061: X_calling_sequence;
2062:
2063: debug_info := 'Count duplicates for vendor_id and site_code';
2064: SELECT count(1)

Line 2104: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_MULTIPLE_TAX_SITES<-' ||

2100: debug_info varchar2(100);
2101: begin
2102: -- Update the calling sequence
2103: --
2104: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_MULTIPLE_TAX_SITES<-' ||
2105: X_calling_sequence;
2106: debug_info := 'Count tax reporting sites (vendor_id = ' || x_vendor_id || ')';
2107: SELECT count(1)
2108: INTO L_Multiple_count

Line 2144: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_SITE_CURRENCIES<-' ||

2140: debug_info varchar2(100);
2141: begin
2142: -- Update the calling sequence
2143: --
2144: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_SITE_CURRENCIES<-' ||
2145: X_calling_sequence;
2146:
2147: debug_info := 'Count sites not in base currency for vendor_id';
2148: SELECT count(1)

Line 2187: current_calling_sequence := 'AP_VENDOR_SITES_PKG.GET_TAX_SITE<-' ||

2183: debug_info varchar2(100);
2184: begin
2185: -- Update the calling sequence
2186: --
2187: current_calling_sequence := 'AP_VENDOR_SITES_PKG.GET_TAX_SITE<-' ||
2188: X_calling_sequence;
2189:
2190: debug_info := 'Return Vendor Site ID for tax reporting site';
2191: -- use table since policy context can be set in

Line 2227: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_STATE_CODES<-' ||

2223: L_Return_Count number;
2224: begin
2225: -- Update the calling sequence
2226: --
2227: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_STATE_CODES<-' ||
2228: X_calling_sequence;
2229:
2230: debug_info := 'Check that all Site State Codes are valid for US sites';
2231:

Line 2271: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_DUPLICATE_ECE_CODE<-' ||

2267: debug_info varchar2(100);
2268: begin
2269: -- Update the calling sequence
2270: --
2271: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_DUPLICATE_ECE_CODE<-' ||
2272: X_calling_sequence;
2273:
2274: debug_info := 'Count duplicates for vendor_id and site_code';
2275: SELECT count(1)

Line 2305: END AP_VENDOR_SITES_PKG;

2301: end Check_duplicate_ece_code;
2302:
2303:
2304:
2305: END AP_VENDOR_SITES_PKG;