[Home] [Help]
PACKAGE: APPS.GL_ELIMINATION_SETS_PKG
Source
1 PACKAGE gl_elimination_sets_pkg As
2 /* $Header: gliesets.pls 120.6 2005/05/05 01:07:33 kvora ship $ */
3 --
4 -- Package
5 -- gl_elimination_sets_pkg
6 -- Purpose
7 -- Server routines related to table gl_elimination_sets
8 -- History
9 -- 11/11/1998 W Wong Created
10
11
12 --
13 -- Function
14 -- Get_Unique_Id
15 -- Purpose
16 -- Gets nextval from GL_ELIMINATION_SETS
17 -- Parameters
18 -- None
19 -- History
20 -- 11-06-1998 W Wong Created
21 -- Notes
22 -- Raises GL_ERROR_GETTING_UNIQUE_ID on failure
23 --
24 FUNCTION get_unique_id Return NUMBER;
25
26 --
27 -- Procedure
28 -- get_company_description
29 -- Purpose
30 -- Gets the description for the elimination company value
31 -- History
32 -- 05-Nov-98 W Wong Created
33 -- Parameters
34 -- x_coa_id ID of the current chart of accounts
35 -- x_company_val Elimination company value
36 -- Notes
37 -- None
38 --
39 FUNCTION get_company_description(
40 x_coa_id NUMBER,
41 x_company_val VARCHAR2
42 ) RETURN VARCHAR2;
43
44 --
45 -- Procedure
46 -- Check_unique_name
47 -- Purpose
48 -- Unique check for name
49 -- History
50 -- 05-Nov-98 W Wong Created
51 -- 31-OCT-02 J Huang sobid-->ledgerid
52 -- Parameters
53 -- x_rowid Rowid
54 -- x_ledgerid LedgerId
55 -- x_name Name of elimination set
56 --
57 -- Notes
58 -- None
59 --
60 PROCEDURE check_unique_name( X_rowid VARCHAR2,
61 X_ledgerid NUMBER,
62 X_name VARCHAR2);
63
64
65 --
66 -- FUNCTION
67 -- Allow_delete_record
68 -- Purpose
69 -- Check if we can allow deletion of the record.
70 -- Deletion is not allowed if an elimination set is marked for tracking
71 -- and it has generated at least once.
72 -- History
73 -- 05-Nov-98 W Wong Created
74 -- Parameters
75 -- x_setid Elimination Set ID
76 --
77 -- Notes
78 -- None
79 --
80 FUNCTION allow_delete_record( X_setid NUMBER ) RETURN boolean;
81
82 --
83 -- Procedure
84 -- Lock_Row
85 -- Purpose
86 -- Locks a row in GL_ELIMINATION_SETS table.
87 -- History
88 -- 09-10-03 P Sahay Created
89 --
90 PROCEDURE lock_row(X_Rowid IN OUT NOCOPY VARCHAR2,
91 X_Elimination_Set_Id IN OUT NOCOPY NUMBER,
92 X_Name VARCHAR2,
93 X_Ledger_Id NUMBER,
94 X_Track_Elimination_Status VARCHAR2,
95 X_Start_Date_Active DATE,
96 X_End_Date_Active DATE,
97 X_Elimination_Company VARCHAR2,
98 X_Last_Executed_Period VARCHAR2,
99 X_Description VARCHAR2,
100 X_Attribute1 VARCHAR2,
101 X_Attribute2 VARCHAR2,
102 X_Attribute3 VARCHAR2,
103 X_Attribute4 VARCHAR2,
104 X_Attribute5 VARCHAR2,
105 X_Attribute6 VARCHAR2,
106 X_Attribute7 VARCHAR2,
107 X_Attribute8 VARCHAR2,
108 X_Attribute9 VARCHAR2,
109 X_Attribute10 VARCHAR2,
110 X_Attribute11 VARCHAR2,
111 X_Attribute12 VARCHAR2,
112 X_Attribute13 VARCHAR2,
113 X_Attribute14 VARCHAR2,
114 X_Attribute15 VARCHAR2,
115 X_Context VARCHAR2,
116 X_Security_Flag VARCHAR2);
117
118
119 End gl_elimination_sets_pkg;