1 PACKAGE gl_elim_accounts_map_pkg As
2 /* $Header: glieacms.pls 120.4 2005/05/05 01:06:52 kvora ship $ */
3 --
4 -- Package
5 -- gl_elim_accounts_map_pkg
6 -- Purpose
7 -- Server routines related to table gl_elim_accounts_map
8 -- History
9 -- 11/11/1998 W Wong Created
10
11
12 --
13 -- Procedure
14 -- unique_line_number
15 -- Purpose
16 -- Make sure line number within each journal is unique
17 -- Parameters
18 -- None
19 -- History
20 -- 11-06-1998 W Wong Created
21 -- Notes
22 -- Raises GL_DUPLICATE_JE_LINE_NUM on failure
23 --
24 PROCEDURE unique_line_number (
25 X_journal_id IN NUMBER,
26 X_lineno IN NUMBER,
27 X_rowid IN VARCHAR2
28 );
29
30 --
31 -- Procedure
32 -- source_spec_is_unique
33 -- Purpose
34 -- Enforces unique constraint over columns
35 -- GL_ELIM_ACCOUNTS_MAP.source_segmentN
36 -- History
37 -- 11-06-1998 W Wong Created
38 -- Notes
39 -- Raises GL_ELIM_SOURCE_NOT_UNIQUE on failure
40 --
41 PROCEDURE source_spec_is_unique (
42 X_journal_id IN NUMBER, X_row_id IN CHAR,
43 X_ss1 IN VARCHAR2, X_ss2 IN VARCHAR2,
44 X_ss3 IN VARCHAR2, X_ss4 IN VARCHAR2,
45 X_ss5 IN VARCHAR2, X_ss6 IN VARCHAR2,
46 X_ss7 IN VARCHAR2, X_ss8 IN VARCHAR2,
47 X_ss9 IN VARCHAR2, X_ss10 IN VARCHAR2,
48 X_ss11 IN VARCHAR2, X_ss12 IN VARCHAR2,
49 X_ss13 IN VARCHAR2, X_ss14 IN VARCHAR2,
50 X_ss15 IN VARCHAR2, X_ss16 IN VARCHAR2,
51 X_ss17 IN VARCHAR2, X_ss18 IN VARCHAR2,
52 X_ss19 IN VARCHAR2, X_ss20 IN VARCHAR2,
53 X_ss21 IN VARCHAR2, X_ss22 IN VARCHAR2,
54 X_ss23 IN VARCHAR2, X_ss24 IN VARCHAR2,
55 X_ss25 IN VARCHAR2, X_ss26 IN VARCHAR2,
56 X_ss27 IN VARCHAR2, X_ss28 IN VARCHAR2,
57 X_ss29 IN VARCHAR2, X_ss30 IN VARCHAR2
58 );
59
60 --
61 -- Procedure
62 -- get_bal_seg_num
63 -- Purpose
64 -- Get the balancing segment number
65 -- History
66 -- 12-17-1998 W Wong Created
67 -- Notes
68 --
69 PROCEDURE get_bal_seg_num (
70 X_coa_id IN NUMBER,
71 X_company_value IN OUT NOCOPY NUMBER
72 );
73
74 End gl_elim_accounts_map_pkg;