APPS.GL_ACCESS_DETAILS_PKG dependencies on GL_ACCESS_SET_NORM_ASSIGN

Line 6: SELECT GL_ACCESS_SET_NORM_ASSIGN_S.NEXTVAL

2: /* $Header: glistadb.pls 120.7 2005/05/05 01:21:59 kvora ship $ */
3:
4: FUNCTION get_record_id RETURN NUMBER IS
5: CURSOR get_new_id IS
6: SELECT GL_ACCESS_SET_NORM_ASSIGN_S.NEXTVAL
7: FROM dual;
8: new_id NUMBER;
9: BEGIN
10: OPEN get_new_id;

Line 19: fnd_message.set_token('SEQUENCE', 'GL_ACCESS_SET_NORM_ASSIGN_S');

15: RETURN (new_id);
16: ELSE
17: CLOSE get_new_id;
18: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
19: fnd_message.set_token('SEQUENCE', 'GL_ACCESS_SET_NORM_ASSIGN_S');
20: app_exception.raise_exception;
21: END IF;
22:
23: EXCEPTION

Line 80: FROM GL_ACCESS_SET_NORM_ASSIGN

76: X_Attribute15 VARCHAR2 DEFAULT NULL
77: ) IS
78: CURSOR C IS
79: SELECT rowid
80: FROM GL_ACCESS_SET_NORM_ASSIGN
81: WHERE access_set_id = X_Access_Set_Id
82: AND ledger_id = X_Ledger_Id
83: AND all_segment_value_flag = X_All_Segment_Value_Flag
84: AND segment_value_type_code = X_Segment_Value_Type_Code

Line 90: INSERT INTO GL_ACCESS_SET_NORM_ASSIGN (

86: AND (segment_value = X_Segment_Value OR segment_value IS NULL)
87: AND (start_date = X_Start_Date OR start_date IS NULL)
88: AND (end_date = X_End_Date OR end_date IS NULL);
89: BEGIN
90: INSERT INTO GL_ACCESS_SET_NORM_ASSIGN (
91: access_set_id,
92: ledger_id,
93: all_segment_value_flag,
94: segment_value_type_code,

Line 207: FROM GL_ACCESS_SET_NORM_ASSIGN

203: X_Attribute15 VARCHAR2 DEFAULT NULL
204: ) IS
205: CURSOR C IS
206: SELECT *
207: FROM GL_ACCESS_SET_NORM_ASSIGN
208: WHERE rowid = X_Rowid
209: FOR UPDATE of Access_Set_Id NOWAIT;
210: Recinfo C%ROWTYPE;
211: BEGIN

Line 331: UPDATE GL_ACCESS_SET_NORM_ASSIGN

327: END Lock_Row;
328:
329: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
330: BEGIN
331: UPDATE GL_ACCESS_SET_NORM_ASSIGN
332: SET status_code = 'D'
333: WHERE rowid = X_Rowid;
334:
335: if SQL%NOTFOUND then

Line 349: FROM gl_access_set_norm_assign

345: X_Access_Privilege_Code VARCHAR2,
346: X_Segment_Value VARCHAR2) IS
347: CURSOR get_duplicate IS
348: SELECT 'duplicate'
349: FROM gl_access_set_norm_assign
350: WHERE access_set_id = X_Access_Set_Id
351: AND ledger_id = X_Ledger_Id
352: AND all_segment_value_flag = X_All_Segment_Value_Flag
353: AND segment_value_type_code = X_Segment_Value_Type_Code