APPS.AP_INCOME_TAX_REGIONS_PKG dependencies on AP_INCOME_TAX_REGIONS

Line 1: PACKAGE BODY AP_INCOME_TAX_REGIONS_PKG AS

1: PACKAGE BODY AP_INCOME_TAX_REGIONS_PKG AS
2: /* $Header: apiincrb.pls 120.3 2004/10/28 00:04:59 pjena noship $ */
3:
4: PROCEDURE CHECK_UNIQUE (X_ROWID VARCHAR2,
5: X_REGION_SHORT_NAME VARCHAR2,

Line 15: current_calling_sequence := 'AP_INCOME_TAX_REGIONS_PKG.CHECK_UNIQUE<-' ||

11:
12: begin
13: --Update the calling sequence
14: --
15: current_calling_sequence := 'AP_INCOME_TAX_REGIONS_PKG.CHECK_UNIQUE<-' ||
16: X_calling_sequence;
17:
18: debug_info := 'Count income tax regions';
19: select count(1)

Line 21: from ap_income_tax_regions

17:
18: debug_info := 'Count income tax regions';
19: select count(1)
20: into dummy
21: from ap_income_tax_regions
22: where (region_short_name = X_REGION_SHORT_NAME OR
23: region_code = X_REGION_CODE)
24: and ((X_ROWID is null) or (rowid <> X_ROWID));
25:

Line 45: END AP_INCOME_TAX_REGIONS_PKG;

41: APP_EXCEPTION.RAISE_EXCEPTION;
42:
43: end CHECK_UNIQUE;
44:
45: END AP_INCOME_TAX_REGIONS_PKG;