APPS.GL_ALLOC_BATCHES_PKG dependencies on GL_ALLOC_FORMULAS

Line 239: gl_alloc_formulas_pkg.delete_rows(

235:
236: CLOSE chk_autoalloc_set;
237:
238: -- Delete all of the associated formulas
239: gl_alloc_formulas_pkg.delete_rows(
240: allocation_batch_id);
241:
242: DELETE FROM GL_ALLOC_BATCHES
243: WHERE rowid = X_Rowid;

Line 258: INSERT INTO GL_ALLOC_FORMULAS(

254:
255:
256: BEGIN
257:
258: INSERT INTO GL_ALLOC_FORMULAS(
259: allocation_formula_id,
260: allocation_batch_id,
261: name,
262: run_sequence,

Line 276: gl_alloc_formulas_s.nextval,

272: last_update_login,
273: description
274: ) (
275: Select
276: gl_alloc_formulas_s.nextval,
277: X_Trg_Batch_Id,
278: f.Name,
279: f.Run_Sequence,
280: f.Je_Category_Name,

Line 291: from GL_ALLOC_FORMULAS F

287: sysdate,
288: X_Last_Updated_By,
289: X_Last_Update_Login,
290: f.Description
291: from GL_ALLOC_FORMULAS F
292: where f.Allocation_batch_id = X_Src_Batch_ID
293: );
294:
295:

Line 407: from GL_ALLOC_FORMULA_LINES L, GL_ALLOC_FORMULAS New, GL_ALLOC_FORMULAS Old

403: L.Segment27,
404: L.Segment28,
405: L.Segment29,
406: L.Segment30
407: from GL_ALLOC_FORMULA_LINES L, GL_ALLOC_FORMULAS New, GL_ALLOC_FORMULAS Old
408: where L.allocation_formula_id = Old.Allocation_formula_id
409: AND New.allocation_batch_id = X_Trg_Batch_Id
410: AND New.name = Old.name
411: AND Old.allocation_batch_id = X_Src_Batch_Id