[Home] [Help]
PACKAGE: APPS.GL_ACCESS_DETAILS_PKG
Source
1 PACKAGE gl_access_details_pkg AS
2 /* $Header: glistads.pls 120.6 2005/05/05 01:22:06 kvora ship $ */
3 --
4 -- Package
5 -- gl_access_details_pkg
6 -- Purpose
7 -- Server routines related to gl_access_set_norm_assign
8 -- History
9 -- 02/19/2001 T Cheng Created
10
11 --
12 -- Function
13 -- get_record_id
14 -- Purpose
15 -- retrieves the unique record id from sequence gl_access_set_norm_assign_s
16 -- History
17 -- 05-15-2001 T Cheng Created
18 -- Notes
19 --
20 FUNCTION get_record_id RETURN NUMBER;
21
22 --
23 -- Procedure
24 -- is_ledger_set
25 -- Purpose
26 -- used to determine, given a ledger id, if it is a ledger set
27 -- History
28 -- 03-28-2001 T Cheng Created
29 -- Notes
30 --
31 FUNCTION is_ledger_set(X_Ledger_Id NUMBER) RETURN BOOLEAN;
32
33 --
34 -- Procedure
35 -- Insert_Row
36 -- Purpose
37 -- used to insert an access detail record
38 -- History
39 -- 02-19-2001 T Cheng Created
40 -- 10-23-2001 T Cheng Change parameters
41 -- Notes
42 --
43 PROCEDURE Insert_Row(
44 X_Rowid IN OUT NOCOPY VARCHAR2,
45 X_Access_Set_Id NUMBER,
46 X_Ledger_Id NUMBER,
47 X_All_Segment_Value_Flag VARCHAR2,
48 X_Segment_Value_Type_Code VARCHAR2,
49 X_Access_Privilege_Code VARCHAR2,
50 X_Record_Id NUMBER,
51 X_User_Id NUMBER,
52 X_Login_Id NUMBER,
53 X_Date DATE,
54 X_Segment_Value VARCHAR2 DEFAULT NULL,
55 X_Start_Date DATE DEFAULT NULL,
56 X_End_Date DATE DEFAULT NULL,
57 X_Status_Code VARCHAR2 DEFAULT NULL,
58 X_Link_Id NUMBER DEFAULT NULL,
59 X_Request_Id NUMBER DEFAULT NULL,
60 X_Context VARCHAR2 DEFAULT NULL,
61 X_Attribute1 VARCHAR2 DEFAULT NULL,
62 X_Attribute2 VARCHAR2 DEFAULT NULL,
63 X_Attribute3 VARCHAR2 DEFAULT NULL,
64 X_Attribute4 VARCHAR2 DEFAULT NULL,
65 X_Attribute5 VARCHAR2 DEFAULT NULL,
66 X_Attribute6 VARCHAR2 DEFAULT NULL,
67 X_Attribute7 VARCHAR2 DEFAULT NULL,
68 X_Attribute8 VARCHAR2 DEFAULT NULL,
69 X_Attribute9 VARCHAR2 DEFAULT NULL,
70 X_Attribute10 VARCHAR2 DEFAULT NULL,
71 X_Attribute11 VARCHAR2 DEFAULT NULL,
72 X_Attribute12 VARCHAR2 DEFAULT NULL,
73 X_Attribute13 VARCHAR2 DEFAULT NULL,
74 X_Attribute14 VARCHAR2 DEFAULT NULL,
75 X_Attribute15 VARCHAR2 DEFAULT NULL);
76
77 --
78 -- Procedure
79 -- Lock_Row
80 -- Purpose
81 -- used to lock an access detail record
82 -- History
83 -- 02-19-2001 T Cheng Created
84 -- 10-23-2001 T Cheng Change parameters
85 -- Notes
86 --
87 PROCEDURE Lock_Row(
88 X_Rowid VARCHAR2,
89 X_Access_Set_Id NUMBER,
90 X_Ledger_Id NUMBER,
91 X_All_Segment_Value_Flag VARCHAR2,
92 X_Segment_Value_Type_Code VARCHAR2,
93 X_Access_Privilege_Code VARCHAR2,
94 X_Record_Id NUMBER,
95 X_Last_Update_Date DATE,
96 X_Last_Updated_By NUMBER,
97 X_Creation_Date DATE,
98 X_Created_By NUMBER,
99 X_Last_Update_Login NUMBER,
100 X_Segment_Value VARCHAR2 DEFAULT NULL,
101 X_Start_Date DATE DEFAULT NULL,
102 X_End_Date DATE DEFAULT NULL,
103 X_Status_Code VARCHAR2 DEFAULT NULL,
104 X_Link_Id NUMBER DEFAULT NULL,
105 X_Request_Id NUMBER DEFAULT NULL,
106 X_Context VARCHAR2 DEFAULT NULL,
107 X_Attribute1 VARCHAR2 DEFAULT NULL,
108 X_Attribute2 VARCHAR2 DEFAULT NULL,
109 X_Attribute3 VARCHAR2 DEFAULT NULL,
110 X_Attribute4 VARCHAR2 DEFAULT NULL,
111 X_Attribute5 VARCHAR2 DEFAULT NULL,
112 X_Attribute6 VARCHAR2 DEFAULT NULL,
113 X_Attribute7 VARCHAR2 DEFAULT NULL,
114 X_Attribute8 VARCHAR2 DEFAULT NULL,
115 X_Attribute9 VARCHAR2 DEFAULT NULL,
116 X_Attribute10 VARCHAR2 DEFAULT NULL,
117 X_Attribute11 VARCHAR2 DEFAULT NULL,
118 X_Attribute12 VARCHAR2 DEFAULT NULL,
119 X_Attribute13 VARCHAR2 DEFAULT NULL,
120 X_Attribute14 VARCHAR2 DEFAULT NULL,
121 X_Attribute15 VARCHAR2 DEFAULT NULL);
122
123 --
124 -- Procedure
125 -- Delete_Row
126 -- Purpose
127 -- used to mark that an access detail record is to be deleted by
128 -- setting its status_code to 'D'
129 -- History
130 -- 02-19-2001 T Cheng Created
131 -- Notes
132 --
133 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
134
135 --
136 -- Procedure
137 -- check_duplicate
138 -- Purpose
139 -- used to prevent a user to assign the same ledger/ledger set with the
140 -- same privilege to the same data access set.
141 -- History
142 -- 08-27-2003 C Ma Created
143 -- Notes
144 --
145 PROCEDURE check_duplicate(
146 X_Access_Set_Id NUMBER,
147 X_Ledger_Id NUMBER,
148 X_All_Segment_Value_Flag VARCHAR2,
149 X_Segment_Value_Type_Code VARCHAR2,
150 X_Access_Privilege_Code VARCHAR2,
151 X_Segment_Value VARCHAR2);
152
153 --
154 -- Procedure
155 -- validate_access_detail
156 -- Purpose
157 -- For iSetup API: validate the access detail assignment
158 -- History
159 -- 05-04-2004 T Cheng Created
160 -- Notes
161 --
162 PROCEDURE validate_access_detail(X_Das_Coa_Id NUMBER,
163 X_Das_Period_Set_Name VARCHAR2,
164 X_Das_Period_Type VARCHAR2,
165 X_Das_Security_Code VARCHAR2,
166 X_Das_Value_Set_Id NUMBER,
167 X_Ledger_Id NUMBER,
168 X_All_Segment_Value_Flag VARCHAR2,
169 X_Segment_Value VARCHAR2,
170 X_Segment_Value_Type_Code VARCHAR2);
171
172
173 END gl_access_details_pkg;