APPS.GL_ALLOC_FORM_LINES_PKG dependencies on GL_ALLOC_FORMULA_LINES

Line 12: FROM GL_ALLOC_FORMULA_LINES gafl

8: FUNCTION complete_formula(formula_id NUMBER,
9: actual_flag VARCHAR2) RETURN BOOLEAN IS
10: CURSOR count_lines is
11: SELECT count(*)
12: FROM GL_ALLOC_FORMULA_LINES gafl
13: WHERE gafl.allocation_formula_id = formula_id;
14:
15: line_count NUMBER;
16: BEGIN

Line 40: 'PROCEDURE', 'gl_alloc_formula_lines_pkg.complete_formula');

36: RAISE;
37: WHEN OTHERS THEN
38: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
39: fnd_message.set_token(
40: 'PROCEDURE', 'gl_alloc_formula_lines_pkg.complete_formula');
41: RAISE;
42: END complete_formula;
43:
44: PROCEDURE delete_rows(formula_id NUMBER) IS

Line 46: DELETE gl_alloc_formula_lines

42: END complete_formula;
43:
44: PROCEDURE delete_rows(formula_id NUMBER) IS
45: BEGIN
46: DELETE gl_alloc_formula_lines
47: WHERE allocation_formula_id = formula_id;
48: EXCEPTION
49: WHEN NO_DATA_FOUND THEN
50: null;

Line 55: DELETE gl_alloc_formula_lines

51: END delete_rows;
52:
53: PROCEDURE delete_batch(batch_id NUMBER) IS
54: BEGIN
55: DELETE gl_alloc_formula_lines
56: WHERE allocation_formula_id IN
57: (SELECT allocation_formula_id
58: FROM gl_alloc_formulas
59: WHERE allocation_batch_id = batch_id);

Line 85: FROM gl_alloc_formula_lines

81:
82: PROCEDURE check_target_ledger(x_allocation_formula_id NUMBER) IS
83: CURSOR target_line IS
84: SELECT ledger_id, actual_flag, transaction_currency
85: FROM gl_alloc_formula_lines
86: WHERE allocation_formula_id = x_allocation_formula_id
87: AND line_number = 4;
88:
89: target_ledger_id NUMBER;

Line 189: FROM gl_alloc_formula_lines

185: transaction_currency VARCHAR2,
186: conversion_method VARCHAR2) IS
187: CURSOR check_curr IS
188: SELECT 'x'
189: FROM gl_alloc_formula_lines
190: WHERE allocation_formula_id = formula_id
191: AND line_number = 1
192: AND ( ( currency_type = 'T'
193: AND ledger_currency <> update_currency.transaction_currency)

Line 215: UPDATE gl_alloc_formula_lines

211: CLOSE check_curr;
212:
213: END IF;
214:
215: UPDATE gl_alloc_formula_lines
216: SET transaction_currency = update_currency.transaction_currency
217: WHERE allocation_formula_id = formula_id;
218:
219: EXCEPTION

Line 231: FROM GL_ALLOC_FORMULA_LINES gafl

227: FUNCTION currency_changed(formula_id NUMBER,
228: transaction_currency VARCHAR2) RETURN BOOLEAN IS
229: CURSOR check_lines is
230: SELECT 'Changed'
231: FROM GL_ALLOC_FORMULA_LINES gafl
232: WHERE gafl.allocation_formula_id = currency_changed.formula_id
233: AND gafl.amount IS NULL
234: AND gafl.transaction_currency <> currency_changed.transaction_currency
235: AND rownum < 2;

Line 306: CURSOR C IS SELECT rowid FROM GL_ALLOC_FORMULA_LINES

302: X_Segment28 VARCHAR2,
303: X_Segment29 VARCHAR2,
304: X_Segment30 VARCHAR2
305: ) IS
306: CURSOR C IS SELECT rowid FROM GL_ALLOC_FORMULA_LINES
307: WHERE allocation_formula_id = X_Allocation_Formula_Id
308: AND line_number = X_Line_Number;
309:
310: BEGIN

Line 317: INSERT INTO GL_ALLOC_FORMULA_LINES(

313: IF (x_allocation_formula_id IS NULL) THEN
314: x_allocation_formula_id := gl_alloc_formulas_pkg.get_unique_id;
315: END IF;
316:
317: INSERT INTO GL_ALLOC_FORMULA_LINES(
318: allocation_formula_id,
319: line_number,
320: line_type,
321: operator,

Line 490: FROM GL_ALLOC_FORMULA_LINES

486: X_Segment30 VARCHAR2
487: ) IS
488: CURSOR C IS
489: SELECT *
490: FROM GL_ALLOC_FORMULA_LINES
491: WHERE rowid = X_Rowid
492: FOR UPDATE of Allocation_Formula_Id NOWAIT;
493: Recinfo C%ROWTYPE;
494:

Line 715: UPDATE GL_ALLOC_FORMULA_LINES

711: X_Segment29 VARCHAR2,
712: X_Segment30 VARCHAR2
713: ) IS
714: BEGIN
715: UPDATE GL_ALLOC_FORMULA_LINES
716: SET
717:
718: allocation_formula_id = X_Allocation_Formula_Id,
719: line_number = X_Line_Number,

Line 780: DELETE FROM GL_ALLOC_FORMULA_LINES

776: END Update_Row;
777:
778: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
779: BEGIN
780: DELETE FROM GL_ALLOC_FORMULA_LINES
781: WHERE rowid = X_Rowid;
782:
783: if (SQL%NOTFOUND) then
784: RAISE NO_DATA_FOUND;