APPS.GL_AUTO_ALLOC_BATCH_PKG dependencies on GL_AUTO_ALLOC_BATCHES

Line 39: FROM GL_AUTO_ALLOC_BATCHES

35: ) IS
36:
37: CURSOR C IS
38: SELECT rowid
39: FROM GL_AUTO_ALLOC_BATCHES
40: WHERE ALLOCATION_SET_ID = l_ALLOCATION_SET_ID
41: AND BATCH_ID = l_BATCH_ID
42: And BATCH_TYPE_CODE = l_BATCH_TYPE_CODE;
43:

Line 45: Insert Into GL_AUTO_ALLOC_BATCHES

41: AND BATCH_ID = l_BATCH_ID
42: And BATCH_TYPE_CODE = l_BATCH_TYPE_CODE;
43:
44: Begin
45: Insert Into GL_AUTO_ALLOC_BATCHES
46: (
47: ALLOCATION_SET_ID
48: , BATCH_ID
49: , BATCH_TYPE_CODE

Line 141: Update GL_AUTO_ALLOC_BATCHES

137: , l_ATTRIBUTE15 IN VARCHAR2
138: , l_CONTEXT IN VARCHAR2
139: ) IS
140: Begin
141: Update GL_AUTO_ALLOC_BATCHES
142: Set
143: Batch_id = l_BATCH_ID
144: , BATCH_TYPE_CODE = l_BATCH_TYPE_CODE
145: , STEP_NUMBER = l_STEP_NUMBER

Line 176: Delete From GL_AUTO_ALLOC_BATCHES

172: Procedure Delete_Allocation_batch(
173: l_Row_id IN VARCHAR2
174: ) Is
175: Begin
176: Delete From GL_AUTO_ALLOC_BATCHES
177: Where RowId = l_Row_id;
178: If (SQL%NOTFOUND) then
179: Raise NO_DATA_FOUND;
180: End If;

Line 214: FROM GL_AUTO_ALLOC_BATCHES

210: , l_CONTEXT IN VARCHAR2
211: ) IS
212: CURSOR C IS
213: SELECT *
214: FROM GL_AUTO_ALLOC_BATCHES
215: WHERE rowid = l_ROW_ID
216: FOR UPDATE NOWAIT;
217: Recinfo C%ROWTYPE;
218:

Line 307: From gl_auto_alloc_batches r

303: ,l_allocation_set_id IN NUMBER
304: ,l_step_label IN VARCHAR2 ) IS
305: Cursor c_dup IS
306: Select 'Duplicate'
307: From gl_auto_alloc_batches r
308: Where r.step_number = l_step_number
309: And r.allocation_set_id = l_allocation_set_id
310: And ( l_rowid is NULL
311: OR

Line 348: From gl_auto_alloc_batches r

344: ,l_Batch_Type_Code IN VARCHAR2
345: ,l_Return_Code IN OUT NOCOPY VARCHAR2 ) Is
346: Cursor c_dup IS
347: Select 'Duplicate'
348: From gl_auto_alloc_batches r
349: Where r.allocation_set_id = l_allocation_set_id
350: And r.Batch_Id = l_Batch_Id
351: And r.Batch_Type_Code = l_Batch_Type_Code
352: And ( l_rowid is NULL