DBA Data[Home] [Help]

APPS.GL_ALLOC_FORMULAS_PKG dependencies on GL_ALLOC_FORM_LINES_PKG

Line 107: gl_alloc_form_lines_pkg.delete_batch(batch_id);

103: END get_unique_id;
104:
105: PROCEDURE delete_rows(batch_id NUMBER) IS
106: BEGIN
107: gl_alloc_form_lines_pkg.delete_batch(batch_id);
108:
109: DELETE gl_alloc_formulas
110: WHERE allocation_batch_id = batch_id;
111: EXCEPTION

Line 151: IF (NOT gl_alloc_form_lines_pkg.complete_formula(

147: END IF;
148:
149: -- Make sure the user has completed all of the formula
150: -- lines.
151: IF (NOT gl_alloc_form_lines_pkg.complete_formula(
152: X_allocation_formula_id,
153: X_actual_flag)) THEN
154: IF (X_actual_flag = 'B') THEN
155: fnd_message.set_name('SQLGL', 'GL_COMPLETE_FOUR_FORMULA_LINES');

Line 167: gl_alloc_form_lines_pkg.check_target_ledger(X_Allocation_Formula_Id);

163: -- Make sure the ledger segment of target and offset lines are the same
164: check_ledger_selection(X_Allocation_Formula_Id);
165:
166: -- Make sure there isn't a currency conflict
167: gl_alloc_form_lines_pkg.check_target_ledger(X_Allocation_Formula_Id);
168:
169: INSERT INTO GL_ALLOC_FORMULAS(
170: allocation_formula_id,
171: allocation_batch_id,

Line 299: IF (NOT gl_alloc_form_lines_pkg.complete_formula(

295: ) IS
296: BEGIN
297: -- Make sure the user has completed all of the formula
298: -- lines.
299: IF (NOT gl_alloc_form_lines_pkg.complete_formula(
300: X_allocation_formula_id,
301: X_actual_flag)) THEN
302: IF (X_actual_flag = 'B') THEN
303: fnd_message.set_name('SQLGL', 'GL_COMPLETE_FOUR_FORMULA_LINES');

Line 312: IF (gl_alloc_form_lines_pkg.currency_changed(

308: END IF;
309: END IF;
310:
311: -- If the user has changed the currency, then update the lines
312: IF (gl_alloc_form_lines_pkg.currency_changed(
313: X_Allocation_Formula_Id,
314: X_Transaction_Currency)
315: OR X_Conversion_Method_Code = 'CV') THEN
316: gl_alloc_form_lines_pkg.update_currency(

Line 316: gl_alloc_form_lines_pkg.update_currency(

312: IF (gl_alloc_form_lines_pkg.currency_changed(
313: X_Allocation_Formula_Id,
314: X_Transaction_Currency)
315: OR X_Conversion_Method_Code = 'CV') THEN
316: gl_alloc_form_lines_pkg.update_currency(
317: X_Allocation_Formula_id,
318: X_Transaction_Currency,
319: X_Conversion_Method_Code);
320: Currency_Changed := 'Y';

Line 330: gl_alloc_form_lines_pkg.check_target_ledger(X_Allocation_Formula_Id);

326: check_ledger_selection(X_Allocation_Formula_Id);
327:
328: IF (Currency_Changed = 'Y') THEN
329: -- Make sure there isn't a currency conflict
330: gl_alloc_form_lines_pkg.check_target_ledger(X_Allocation_Formula_Id);
331: END IF;
332:
333: UPDATE GL_ALLOC_FORMULAS
334: SET

Line 360: gl_alloc_form_lines_pkg.delete_rows(

356: PROCEDURE Delete_Row(Allocation_formula_id NUMBER, X_Rowid VARCHAR2) IS
357: BEGIN
358:
359: -- Delete all of the associated formula lines
360: gl_alloc_form_lines_pkg.delete_rows(
361: allocation_formula_id);
362:
363: -- Delete the formula
364: DELETE FROM GL_ALLOC_FORMULAS