1 PACKAGE GL_SHARES_OUTSTANDING_PKG AS
2 /* $Header: glistous.pls 120.3 2005/05/05 01:23:44 kvora ship $ */
3
4 -- Package
5 -- GL_SHARES_OUTSTANDING_PKG
6 -- Purpose
7 -- To create GL_SHARES_OUTSTANDING_PKG package.
8 -- History
9 -- 08/25/98 K Vora Created
10
11 --
12 -- Procedure
13 -- check_unique
14 -- Purpose
15 -- Checks to make sure the combination of set_of_books_id,
16 -- fiscal_year, share_measure_code and measure_type_code is
17 -- unique within the GL_SHARES_OUTSTANDING table.
18 -- History
19 -- 08/25/98 K Vora Created
20 -- Arguments
21 -- X_rowid The ID of the row to be checked
22 -- X_ledger_id The ledger_id to be checked
23 -- X_fiscal_year The fiscal_year to be checked
24 -- X_share_measure_code The share measure code to be checked
25 -- X_measure_type_code The measure type code to be checked
26 -- Example
27 -- GL_SHARES_OUTSTANDING_PKG.check_unique('123:A:456', 46,
28 -- 1990, 'BASIC', 'ACTUAL' );
29 -- Notes
30 --
31 PROCEDURE check_unique( X_rowid VARCHAR2,
32 X_ledger_id NUMBER,
33 X_fiscal_year NUMBER,
34 X_share_measure_code VARCHAR2,
35 X_measure_type_code VARCHAR2);
36
37 END GL_SHARES_OUTSTANDING_PKG;