APPS.GL_ALLOC_BATCHES_PKG dependencies on GL_ALLOC_BATCHES

Line 1: PACKAGE BODY gl_alloc_batches_pkg AS

1: PACKAGE BODY gl_alloc_batches_pkg AS
2: /* $Header: glimabab.pls 120.5.12010000.2 2009/07/13 06:25:18 sommukhe ship $ */
3:
4: --
5: -- PUBLIC FUNCTIONS

Line 11: FROM GL_ALLOC_BATCHES gab

7:
8: PROCEDURE check_unique(batch_name VARCHAR2, row_id VARCHAR2, coa_id NUMBER) IS
9: CURSOR chk_duplicates is
10: SELECT 'Duplicate'
11: FROM GL_ALLOC_BATCHES gab
12: WHERE gab.name = batch_name
13: AND ( row_id is null
14: OR gab.rowid <> row_id)
15: AND gab.chart_of_accounts_id = coa_id;

Line 34: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.check_unique');

30: WHEN app_exceptions.application_exception THEN
31: RAISE;
32: WHEN OTHERS THEN
33: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
34: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.check_unique');
35: RAISE;
36: END check_unique;
37:
38: FUNCTION get_unique_id RETURN NUMBER IS

Line 40: SELECT gl_alloc_batches_s.NEXTVAL

36: END check_unique;
37:
38: FUNCTION get_unique_id RETURN NUMBER IS
39: CURSOR get_new_id IS
40: SELECT gl_alloc_batches_s.NEXTVAL
41: FROM dual;
42: new_id number;
43: BEGIN
44: OPEN get_new_id;

Line 53: fnd_message.set_token('SEQUENCE', 'GL_ALLOC_BATCHES_S');

49: return(new_id);
50: ELSE
51: CLOSE get_new_id;
52: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
53: fnd_message.set_token('SEQUENCE', 'GL_ALLOC_BATCHES_S');
54: app_exception.raise_exception;
55: END IF;
56:
57: EXCEPTION

Line 62: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.get_unique_id');

58: WHEN app_exceptions.application_exception THEN
59: RAISE;
60: WHEN OTHERS THEN
61: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
62: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.get_unique_id');
63: RAISE;
64: END get_unique_id;
65:
66: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 81: CURSOR C IS SELECT rowid FROM GL_ALLOC_BATCHES

77: X_Description VARCHAR2,
78: X_Validation_Status VARCHAR2,
79: X_Validation_Request_Id NUMBER
80: ) IS
81: CURSOR C IS SELECT rowid FROM GL_ALLOC_BATCHES
82: WHERE allocation_batch_id = X_Allocation_Batch_Id;
83:
84: BEGIN
85:

Line 88: x_allocation_batch_id := gl_alloc_batches_pkg.get_unique_id;

84: BEGIN
85:
86: -- Get batch id if it was not provided
87: IF (X_allocation_batch_id IS NULL) THEN
88: x_allocation_batch_id := gl_alloc_batches_pkg.get_unique_id;
89: END IF;
90:
91: INSERT INTO GL_ALLOC_BATCHES(
92: allocation_batch_id,

Line 91: INSERT INTO GL_ALLOC_BATCHES(

87: IF (X_allocation_batch_id IS NULL) THEN
88: x_allocation_batch_id := gl_alloc_batches_pkg.get_unique_id;
89: END IF;
90:
91: INSERT INTO GL_ALLOC_BATCHES(
92: allocation_batch_id,
93: name,
94: chart_of_accounts_id,
95: validation_status,

Line 146: FROM GL_ALLOC_BATCHES

142:
143: ) IS
144: CURSOR C IS
145: SELECT *
146: FROM GL_ALLOC_BATCHES
147: WHERE rowid = X_Rowid
148: FOR UPDATE of Allocation_Batch_Id NOWAIT;
149: Recinfo C%ROWTYPE;
150: BEGIN

Line 198: UPDATE GL_ALLOC_BATCHES

194: X_Validation_Request_Id NUMBER
195:
196: ) IS
197: BEGIN
198: UPDATE GL_ALLOC_BATCHES
199: SET
200: allocation_batch_id = X_Allocation_Batch_Id,
201: name = X_Name,
202: chart_of_accounts_id = X_Chart_Of_Accounts_Id,

Line 242: DELETE FROM GL_ALLOC_BATCHES

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;
244:
245: if (SQL%NOTFOUND) then
246: Raise NO_DATA_FOUND;

Line 421: 'GL_ALLOC_BATCHES_PKG.Autocopy');

417: RAISE;
418: WHEN OTHERS THEN
419: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
420: fnd_message.set_token('PROCEDURE',
421: 'GL_ALLOC_BATCHES_PKG.Autocopy');
422: RAISE;
423:
424: END Autocopy;
425:

Line 448: END gl_alloc_batches_pkg;

444: END IF;
445:
446: END check_batch;
447:
448: END gl_alloc_batches_pkg;