APPS.GL_RECURRING_HEADERS_PKG dependencies on GL_RECURRING_HEADERS

Line 1: PACKAGE BODY GL_RECURRING_HEADERS_PKG as

1: PACKAGE BODY GL_RECURRING_HEADERS_PKG as
2: /* $Header: glirechb.pls 120.5 2005/05/05 01:19:57 kvora ship $ */
3:
4:
5: --

Line 15: FROM gl_recurring_headers head

11: x_recurring_batch_id NUMBER ) RETURN BOOLEAN IS
12:
13: CURSOR c_active IS
14: SELECT 'found'
15: FROM gl_recurring_headers head
16: WHERE head.LEDGER_ID = x_ledger_id
17: AND head.RECURRING_BATCH_ID = x_recurring_batch_id
18: AND TRUNC( sysdate )
19: BETWEEN NVL( head.START_DATE_ACTIVE, TRUNC( sysdate ) )

Line 44: 'GL_RECURRING_HEADERS_PKG.is_valid_header_exist');

40: RAISE;
41: WHEN OTHERS THEN
42: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
43: fnd_message.set_token('PROCEDURE',
44: 'GL_RECURRING_HEADERS_PKG.is_valid_header_exist');
45: RAISE;
46:
47: END is_valid_header_exist;
48:

Line 56: FROM gl_recurring_headers h

52: x_name VARCHAR2,
53: x_batchid NUMBER ) IS
54: CURSOR c_dup IS
55: SELECT 'Duplicate'
56: FROM gl_recurring_headers h
57: WHERE upper( h.name) = upper( x_name )
58: AND h.recurring_batch_id = x_batchid
59: AND ( x_rowid is NULL
60: OR

Line 83: 'GL_RECURRING_HEADERS_PKG.check_unique');

79: RAISE;
80: WHEN OTHERS THEN
81: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
82: fnd_message.set_token('PROCEDURE',
83: 'GL_RECURRING_HEADERS_PKG.check_unique');
84: RAISE;
85:
86: END check_unique;
87:

Line 93: SELECT GL_RECURRING_HEADERS_S.NEXTVAL

89:
90: FUNCTION get_unique_id RETURN NUMBER IS
91:
92: CURSOR c_getid IS
93: SELECT GL_RECURRING_HEADERS_S.NEXTVAL
94: FROM dual;
95:
96: id number;
97:

Line 108: fnd_message.set_token('SEQUENCE', 'GL_RECURRING_HEADERS_S');

104: RETURN( id );
105: ELSE
106: CLOSE c_getid;
107: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
108: fnd_message.set_token('SEQUENCE', 'GL_RECURRING_HEADERS_S');
109: app_exception.raise_exception;
110: END IF;
111:
112: EXCEPTION

Line 118: 'GL_RECURRING_HEADERS_PKG.get_unique_id');

114: RAISE;
115: WHEN OTHERS THEN
116: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
117: fnd_message.set_token('PROCEDURE',
118: 'GL_RECURRING_HEADERS_PKG.get_unique_id');
119: RAISE;
120:
121: END get_unique_id;
122:

Line 129: FROM GL_RECURRING_HEADERS h

125: PROCEDURE delete_rows( x_batch_id NUMBER ) IS
126:
127: CURSOR c_header IS
128: SELECT h.RECURRING_HEADER_ID
129: FROM GL_RECURRING_HEADERS h
130: WHERE h.RECURRING_BATCH_ID = x_batch_id;
131:
132: header_id NUMBER;
133:

Line 155: FROM GL_RECURRING_HEADERS

151:
152: CLOSE c_header;
153:
154: DELETE
155: FROM GL_RECURRING_HEADERS
156: WHERE RECURRING_BATCH_ID = x_batch_id;
157:
158: EXCEPTION
159: WHEN app_exceptions.application_exception THEN

Line 164: 'GL_RECURRING_HEADERS_PKG.delete_rows');

160: RAISE;
161: WHEN OTHERS THEN
162: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
163: fnd_message.set_token('PROCEDURE',
164: 'GL_RECURRING_HEADERS_PKG.delete_rows');
165: RAISE;
166:
167: END delete_rows;
168:

Line 206: FROM GL_RECURRING_HEADERS

202: ) IS
203:
204: CURSOR C IS
205: SELECT rowid
206: FROM GL_RECURRING_HEADERS
207: WHERE recurring_header_id = X_Recurring_Header_Id;
208:
209: CURSOR C2 IS
210: SELECT gl_recurring_headers_s.nextval

Line 210: SELECT gl_recurring_headers_s.nextval

206: FROM GL_RECURRING_HEADERS
207: WHERE recurring_header_id = X_Recurring_Header_Id;
208:
209: CURSOR C2 IS
210: SELECT gl_recurring_headers_s.nextval
211: FROM dual;
212:
213: BEGIN
214:

Line 230: INSERT INTO GL_RECURRING_HEADERS(

226:
227: -- Consolidating call to check unique to save on round trips
228: check_unique(X_rowid, X_name, X_Recurring_Batch_id);
229:
230: INSERT INTO GL_RECURRING_HEADERS(
231: recurring_header_id,
232: last_update_date,
233: last_updated_by,
234: ledger_id,

Line 335: FROM GL_RECURRING_HEADERS

331: X_Context VARCHAR2
332: ) IS
333: CURSOR C IS
334: SELECT *
335: FROM GL_RECURRING_HEADERS
336: WHERE rowid = X_Rowid
337: FOR UPDATE OF Recurring_Header_Id NOWAIT;
338: Recinfo C%ROWTYPE;
339:

Line 474: UPDATE GL_RECURRING_HEADERS

470:
471: -- Consolidating call to check unique to save on round trips
472: check_unique(X_rowid, X_name, X_Recurring_Batch_id);
473:
474: UPDATE GL_RECURRING_HEADERS
475: SET
476: recurring_header_id = X_Recurring_Header_Id,
477: last_update_date = X_Last_Update_Date,
478: last_updated_by = X_Last_Updated_By,

Line 517: FROM GL_RECURRING_HEADERS

513:
514: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
515: BEGIN
516: DELETE
517: FROM GL_RECURRING_HEADERS
518: WHERE rowid = X_Rowid;
519:
520: if (SQL%NOTFOUND) then
521: RAISE NO_DATA_FOUND;

Line 527: END GL_RECURRING_HEADERS_PKG;

523: END Delete_Row;
524:
525:
526:
527: END GL_RECURRING_HEADERS_PKG;