APPS.GL_AUTO_ALLOC_SET_PKG dependencies on GL_AUTO_ALLOC_BATCHES

Line 335: DELETE From GL_AUTO_ALLOC_BATCHES

331: l_allocation_set_id IN NUMBER
332: ) Is
333: Begin
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;

Line 367: FROM gl_auto_alloc_batches

363: v_batch_type VARCHAR2(1);
364:
365: CURSOR get_type IS
366: SELECT batch_type_code
367: FROM gl_auto_alloc_batches
368: WHERE allocation_set_id = X_Allocation_Set_Id;
369: BEGIN
370: X_Contain_Actual := FALSE;
371: X_Contain_Budget := FALSE;

Line 457: FROM gl_auto_alloc_batches

453: X_Batch_Id IN NUMBER,
454: X_Ledger_Id IN NUMBER) RETURN NUMBER IS
455: CURSOR random_batch IS
456: SELECT batch_id,batch_type_code
457: FROM gl_auto_alloc_batches
458: WHERE allocation_set_id = x_batch_id
459: ORDER BY (decode(batch_type_code, 'A', 1, 'R', 2, 'E', 3, 'P',4));
460:
461: CURSOR rje_ledger(random_bid number) IS