1 PACKAGE gl_movemerge_requests_pkg As
2 /* $Header: glimmrqs.pls 120.5 2004/02/13 23:28:14 kdyung ship $ */
3 --
4 --
5 -- Package
6 -- gl_movemerge_requests_pkg
7 -- Purpose
8 -- Server routines related to table gl_movemerge_requests
9 -- History
10 -- 3/6/1997 Mike Marra Created
11
12
13 --
14 -- Function
15 -- Get_Unique_Id
16 -- Purpose
17 -- Gets nextval from GL_MOVEMERGE_REQUESTS_S
18 -- History
19 -- 03-06-1997 Mike Marra Created
20 -- Notes
21 -- Raises GL_ERROR_GETTING_UNIQUE_ID on failure
22 FUNCTION get_unique_id Return NUMBER;
23
24 --
25 -- Procedure
26 -- Must_Have_Accounts
27 -- Purpose
28 -- Enforce bus rule that every GL_MOVEMERGE_REQUESTS
29 -- record has at least 1 GL_MOVEMERGE_ACCOUNTS record
30 -- History
31 -- 03-06-1997 Mike Marra Created
32 -- Notes
33 -- Raises GL_MM_REQUEST_WITHOUT_ACCOUNTS on failure
34 PROCEDURE must_have_accounts (mm_id IN NUMBER);
35
36 --
37 -- Procedure
38 -- Delete_All_Accounts
39 -- Purpose
40 -- Cascade deletes from parent to child table
41 -- History
42 -- 03-06-1997 Mike Marra Created
43 -- Notes
44 --
45 PROCEDURE delete_all_accounts (mm_id IN NUMBER);
46
47
48 -- Name
49 -- Check_unique_name
50 -- Purpose
51 -- Unique check for name
52 -- Arguments
53 -- name
54 --
55 PROCEDURE check_unique_name(X_rowid VARCHAR2,
56 X_coaid NUMBER,
57 X_name VARCHAR2);
58
59
60 -- Name
61 -- Pre_Insert
62 -- Purpose
63 -- Validations before pre_insert on request block
64 -- Arguments
65 -- name
66 --
67 PROCEDURE pre_insert(X_rowid VARCHAR2,
68 X_coaid NUMBER,
69 X_name VARCHAR2);
70
71 -- Name
72 -- validate_segments
73 -- Purpose
74 -- Calling the validate_segs in FND_FLEX-KEYVAL
75 -- Arguments
76 -- ops_string - Operations to be performed
77 -- concatseg - accouting information to be validated
78 -- coaid - charts of accounts id
79
80 FUNCTION validate_segments(ops_string IN VARCHAR2,
81 concatseg IN VARCHAR2,
82 coaid IN NUMBER) RETURN VARCHAR2;
83
84 -- Name
85 -- Check_Last_Opened_Period
86 -- Purpose
87 -- To make sure ledger and its associated ALCs all have the same
88 -- lastest opened period.
89 -- Arguments
90 -- ledger_id - ledger id
91
92 PROCEDURE check_last_opened_period(ledgerid IN NUMBER);
93
94 -- Name
95 -- get_mm_ledger_id
96 -- Purpose
97 -- To get a ledger id from a ledger set. Because all ledger and its
98 -- associated ALCs have the same Chart of Accounts. Use one of the ledger
99 -- ID will be sufficient here.
100 -- Arguments
101 -- ledger_id - ledger id or ledger set id
102
103 PROCEDURE get_mm_ledger_id(ledgerid IN NUMBER,
104 mm_ledger_id IN OUT NOCOPY NUMBER);
105
106 End gl_movemerge_requests_pkg;