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 214: UPDATE gl_alloc_formula_lines

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

Line 230: FROM GL_ALLOC_FORMULA_LINES gafl

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

Line 305: CURSOR C IS SELECT rowid FROM GL_ALLOC_FORMULA_LINES

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

Line 316: INSERT INTO GL_ALLOC_FORMULA_LINES(

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

Line 489: FROM GL_ALLOC_FORMULA_LINES

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

Line 714: UPDATE GL_ALLOC_FORMULA_LINES

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

Line 779: DELETE FROM GL_ALLOC_FORMULA_LINES

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