APPS.GL_AUTO_ALLOC_SET_PKG dependencies on GL_AUTO_ALLOC_SETS

Line 8: SELECT gl_auto_alloc_sets_s.NEXTVAL

4: FAILURE CONSTANT VARCHAR2(1) := 'F';
5:
6: FUNCTION get_unique_set_id RETURN NUMBER IS
7: CURSOR get_new_id IS
8: SELECT gl_auto_alloc_sets_s.NEXTVAL
9: FROM dual;
10: new_id number;
11: BEGIN
12: OPEN get_new_id;

Line 73: FROM GL_AUTO_ALLOC_SETS

69: , l_CONTEXT IN VARCHAR2
70: ) IS
71: CURSOR C_SET IS
72: SELECT rowid
73: FROM GL_AUTO_ALLOC_SETS
74: WHERE ALLOCATION_SET_ID = l_ALLOCATION_SET_ID;
75:
76: Begin
77: Insert Into GL_AUTO_ALLOC_SETS (

Line 77: Insert Into GL_AUTO_ALLOC_SETS (

73: FROM GL_AUTO_ALLOC_SETS
74: WHERE ALLOCATION_SET_ID = l_ALLOCATION_SET_ID;
75:
76: Begin
77: Insert Into GL_AUTO_ALLOC_SETS (
78: ALLOCATION_SET_ID
79: , ALLOCATION_SET_TYPE_CODE
80: , ALLOCATION_SET_NAME
81: , ALLOCATION_CODE

Line 182: Update GL_AUTO_ALLOC_SETS

178: , l_ATTRIBUTE15 IN VARCHAR2
179: , l_CONTEXT IN VARCHAR2
180: ) IS
181: Begin
182: Update GL_AUTO_ALLOC_SETS
183: SET
184: ALLOCATION_SET_NAME = l_ALLOCATION_SET_NAME
185: , LAST_UPDATE_DATE = l_LAST_UPDATE_DATE
186: , LAST_UPDATED_BY = l_LAST_UPDATED_BY

Line 245: FROM GL_AUTO_ALLOC_SETS

241: , l_CONTEXT IN VARCHAR2
242: ) IS
243: CURSOR C IS
244: SELECT *
245: FROM GL_AUTO_ALLOC_SETS
246: WHERE rowid = l_ROW_ID
247: FOR UPDATE NOWAIT;
248: Recinfo C%ROWTYPE;
249: Begin

Line 338: DELETE From GL_AUTO_ALLOC_SETS

334: --delete batches
335: DELETE From GL_AUTO_ALLOC_BATCHES
336: Where Allocation_Set_Id = l_allocation_set_id;
337: --Now delete set
338: DELETE From GL_AUTO_ALLOC_SETS
339: Where Allocation_Set_Id = l_allocation_set_id;
340:
341: If (SQL%NOTFOUND) then
342: Raise NO_DATA_FOUND;

Line 560: FROM gl_auto_alloc_sets

556: X_Alloc_Set_Id IN NUMBER) RETURN VARCHAR IS
557:
558: CURSOR get_set_name IS
559: SELECT allocation_set_name
560: FROM gl_auto_alloc_sets
561: WHERE allocation_set_id = X_Alloc_Set_Id;
562:
563: CURSOR get_alloc_name IS
564: SELECT name