1 PACKAGE PA_IND_COST_CODES_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAXCIICS.pls 120.1 2005/08/23 19:18:16 spunathi noship $ */
3
4 -- =====================================================================
5 -- This procedure performs a referential integrity check for indirect cost
6 -- codes. Indirect cost code appears as a foreign key in the following
7 -- tables:
8 -- PA_COST_BASE_COST_CODES
9 -- PA_IND_COST_CODE_MULTIPLIERS
10 -- PA_COMPILED_MULTIPLIERS
11
12 PROCEDURE check_references( X_icc_name IN VARCHAR2
13 , status IN OUT NOCOPY NUMBER
14 , outcome IN OUT NOCOPY VARCHAR2 );
15
16 -- =====================================================================
17 -- This procedure checks if the indirect cost code being inserted already
18 -- exists, and if so, returns an error message.
19
20 PROCEDURE check_unique( X_icc_name IN VARCHAR2
21 , X_rowid IN VARCHAR2
22 , status IN OUT NOCOPY NUMBER
23 , outcome IN OUT NOCOPY VARCHAR2 );
24
25 END PA_IND_COST_CODES_PKG;