1 PACKAGE gl_movemerge_accounts_pkg AS
2 /* $Header: glimmacs.pls 120.3 2005/05/05 01:17:29 kvora ship $ */
3 --
4 -- Package
5 -- gl_movemerge_accounts_pkg
6 -- Purpose
7 -- server routines related to table gl_movemerge_accounts
8 -- History
9 -- 3/6/1997 Mike Marra Created
10 --
11
12 --
13 -- PUBLIC methods
14 --
15
16 --
17 -- Procedure
18 -- line_number_is_unique
19 -- Purpose
20 -- Enforces unique constraint on column
21 -- GL_MOVEMERGE_ACCOUNTS.line_number
22 -- for a given request.
23 -- History
24 -- 03-06-1997 Mike Marra Created
25 -- Notes
26 -- Raises GL_DUPLICATE_JE_LINE_NUM on failure
27 PROCEDURE line_number_is_unique (
28 mm_id IN NUMBER,
29 lineno IN NUMBER,
30 row_id IN CHAR
31 );
32
33
34 --
35 -- Procedure
36 -- source_spec_is_unique
37 -- Purpose
38 -- Enforces unique constraint over columns
39 -- GL_MOVEMERGE_ACCOUNTS.source_segmentN
40 -- conditionally, for movemerge type requests
41 -- History
42 -- 03-05-1997 Mike Marra Created
43 -- Notes
44 -- Raises GL_MM_SOURCE_NOT_UNIQUE on failure
45 PROCEDURE source_spec_is_unique (
46 mm_id IN NUMBER, row_id IN CHAR,
47 ss1 IN VARCHAR2, ss2 IN VARCHAR2,
48 ss3 IN VARCHAR2, ss4 IN VARCHAR2,
49 ss5 IN VARCHAR2, ss6 IN VARCHAR2,
50 ss7 IN VARCHAR2, ss8 IN VARCHAR2,
51 ss9 IN VARCHAR2, ss10 IN VARCHAR2,
52 ss11 IN VARCHAR2, ss12 IN VARCHAR2,
53 ss13 IN VARCHAR2, ss14 IN VARCHAR2,
54 ss15 IN VARCHAR2, ss16 IN VARCHAR2,
55 ss17 IN VARCHAR2, ss18 IN VARCHAR2,
56 ss19 IN VARCHAR2, ss20 IN VARCHAR2,
57 ss21 IN VARCHAR2, ss22 IN VARCHAR2,
58 ss23 IN VARCHAR2, ss24 IN VARCHAR2,
59 ss25 IN VARCHAR2, ss26 IN VARCHAR2,
60 ss27 IN VARCHAR2, ss28 IN VARCHAR2,
61 ss29 IN VARCHAR2, ss30 IN VARCHAR2
62 );
63
64
65 -- Name
66 -- Pre_Insert
67 -- Purpose
68 -- Validations before pre_insert on account block
69 -- Arguments
70 -- name
71 --
72 PROCEDURE pre_insert(
73 mm_id IN NUMBER,
74 lineno IN NUMBER,
75 row_id IN CHAR);
76
77 END gl_movemerge_accounts_pkg;