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.29.12020000.2 2013/02/01 11:09:26 wywong ship $ */
3: --
4: --
5: ap_null_num CONSTANT NUMBER := FND_API.G_NULL_NUM; /*Bug 11724842*/

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

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

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

1069:
1070: BEGIN
1071: -- Update the calling sequence
1072: --
1073: current_calling_sequence := 'AP_VENDOR_SITES_PKG.LOCK_ROW<-' ||
1074: X_calling_sequence;
1075: debug_info := 'Open cursor C';
1076: OPEN C;
1077: debug_info := 'Fetch cursor C';

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

1662:
1663: BEGIN
1664: -- Update the calling sequence
1665: --
1666: current_calling_sequence := 'AP_VENDOR_SITES_PKG.UPDATE_ROW<-' ||
1667: X_calling_sequence;
1668:
1669: -- Bug # 636963 Vendor site code can not be changed if same code exits in
1670: -- a different org.

Line 2099: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_VENDOR_OFFSETS

2095: debug_info varchar2(100);
2096: begin
2097: -- Update the calling sequence
2098: --
2099: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_VENDOR_OFFSETS
2100: <-' ||
2101: X_calling_sequence;
2102:
2103: debug_info := 'Count sites with offset';

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

2140: debug_info varchar2(100);
2141: begin
2142: -- Update the calling sequence
2143: --
2144: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_DUPLICATE_VENDOR_SITE<-' ||
2145: X_calling_sequence;
2146:
2147: debug_info := 'Count duplicates for vendor_id and site_code';
2148: SELECT count(1)

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

2184: debug_info varchar2(100);
2185: begin
2186: -- Update the calling sequence
2187: --
2188: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_MULTIPLE_TAX_SITES<-' ||
2189: X_calling_sequence;
2190: debug_info := 'Count tax reporting sites (vendor_id = ' || x_vendor_id || ')';
2191: SELECT count(1)
2192: INTO L_Multiple_count

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

2224: debug_info varchar2(100);
2225: begin
2226: -- Update the calling sequence
2227: --
2228: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_SITE_CURRENCIES<-' ||
2229: X_calling_sequence;
2230:
2231: debug_info := 'Count sites not in base currency for vendor_id';
2232: SELECT count(1)

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

2267: debug_info varchar2(100);
2268: begin
2269: -- Update the calling sequence
2270: --
2271: current_calling_sequence := 'AP_VENDOR_SITES_PKG.GET_TAX_SITE<-' ||
2272: X_calling_sequence;
2273:
2274: debug_info := 'Return Vendor Site ID for tax reporting site';
2275: -- use table since policy context can be set in

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

2307: L_Return_Count number;
2308: begin
2309: -- Update the calling sequence
2310: --
2311: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_STATE_CODES<-' ||
2312: X_calling_sequence;
2313:
2314: debug_info := 'Check that all Site State Codes are valid for US sites';
2315:

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

2351: debug_info varchar2(100);
2352: begin
2353: -- Update the calling sequence
2354: --
2355: current_calling_sequence := 'AP_VENDOR_SITES_PKG.CHECK_DUPLICATE_ECE_CODE<-' ||
2356: X_calling_sequence;
2357:
2358: debug_info := 'Count duplicates for vendor_id and site_code';
2359: SELECT count(1)

Line 2389: END AP_VENDOR_SITES_PKG;

2385: end Check_duplicate_ece_code;
2386:
2387:
2388:
2389: END AP_VENDOR_SITES_PKG;