APPS.GL_SUMMARY_TEMPLATES_PKG dependencies on GL_SUMMARY_TEMPLATES

Line 1: PACKAGE BODY GL_SUMMARY_TEMPLATES_PKG AS

1: PACKAGE BODY GL_SUMMARY_TEMPLATES_PKG AS
2: /* $Header: gliactpb.pls 120.5 2005/07/11 05:22:34 agovil ship $ */
3:
4:
5: --

Line 14: FROM GL_SUMMARY_TEMPLATES st

10: x_ledger_id NUMBER ) RETURN BOOLEAN IS
11:
12: CURSOR c_not_fc IS
13: SELECT 'found'
14: FROM GL_SUMMARY_TEMPLATES st
15: WHERE st.ledger_id = x_ledger_id
16: AND EXISTS (SELECT 'found'
17: FROM GL_SUMMARY_BC_OPTIONS sb
18: WHERE st.template_id = sb.template_id);

Line 43: 'GL_SUMMARY_TEMPLATES_PKG.is_funds_check_not_none');

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

Line 60: FROM GL_SUMMARY_TEMPLATES st

56: BEGIN
57:
58: SELECT 1
59: INTO X_name
60: FROM GL_SUMMARY_TEMPLATES st
61: WHERE ((X_rowid is NULL) OR (X_rowid <> st.rowid))
62: AND X_ledger_id = st.ledger_id
63: AND X_template_name = st.template_name;
64:

Line 117: FROM GL_SUMMARY_TEMPLATES st

113: BEGIN
114:
115: SELECT 1
116: INTO X_template
117: FROM GL_SUMMARY_TEMPLATES st
118: WHERE ((X_rowid is NULL) OR (X_rowid <> st.rowid))
119: AND X_ledger_id = st.ledger_id
120: AND nvl(X_segment1_type,'*') = nvl(st.segment1_type,'*')
121: AND nvl(X_segment2_type,'*') = nvl(st.segment2_type,'*')

Line 163: 'GL_SUMMARY_TEMPLATES_PKG.check_unique_template');

159: RETURN(FALSE);
160: WHEN OTHERS THEN
161: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
162: fnd_message.set_token('PROCEDURE',
163: 'GL_SUMMARY_TEMPLATES_PKG.check_unique_template');
164: RAISE;
165:
166: END check_unique_template;
167:

Line 171: SELECT GL_SUMMARY_TEMPLATES_S.NEXTVAL

167:
168:
169: FUNCTION get_unique_id RETURN NUMBER IS
170: CURSOR c_getid IS
171: SELECT GL_SUMMARY_TEMPLATES_S.NEXTVAL
172: FROM dual;
173: id NUMBER;
174:
175: BEGIN

Line 185: fnd_message.set_token('SEQUENCE', 'GL_SUMMARY_TEMPLATES_S');

181: RETURN( id );
182: ELSE
183: CLOSE c_getid;
184: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
185: fnd_message.set_token('SEQUENCE', 'GL_SUMMARY_TEMPLATES_S');
186: app_exception.raise_exception;
187: END IF;
188:
189: EXCEPTION

Line 195: 'gl_summary_templates_pkg.get_unique_id');

191: RAISE;
192: WHEN OTHERS THEN
193: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
194: fnd_message.set_token('PROCEDURE',
195: 'gl_summary_templates_pkg.get_unique_id');
196: RAISE;
197: END get_unique_id;
198:
199: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 254: CURSOR C IS SELECT rowid FROM GL_SUMMARY_TEMPLATES

250: X_Attribute7 VARCHAR2,
251: X_Attribute8 VARCHAR2,
252: X_Context VARCHAR2
253: ) IS
254: CURSOR C IS SELECT rowid FROM GL_SUMMARY_TEMPLATES
255: WHERE template_id = X_Template_Id;
256: BEGIN
257: INSERT INTO GL_SUMMARY_TEMPLATES(
258: template_id,

Line 257: INSERT INTO GL_SUMMARY_TEMPLATES(

253: ) IS
254: CURSOR C IS SELECT rowid FROM GL_SUMMARY_TEMPLATES
255: WHERE template_id = X_Template_Id;
256: BEGIN
257: INSERT INTO GL_SUMMARY_TEMPLATES(
258: template_id,
259: ledger_id,
260: status,
261: last_update_date,

Line 433: FROM GL_SUMMARY_TEMPLATES

429: X_Context VARCHAR2
430: ) IS
431: CURSOR C IS
432: SELECT *
433: FROM GL_SUMMARY_TEMPLATES
434: WHERE rowid = X_Rowid
435: FOR UPDATE of Ledger_Id NOWAIT;
436: Recinfo C%ROWTYPE;
437: BEGIN

Line 670: UPDATE GL_SUMMARY_TEMPLATES

666: X_Context VARCHAR2
667: ) IS
668:
669: BEGIN
670: UPDATE GL_SUMMARY_TEMPLATES
671: SET
672: template_id = X_Template_Id,
673: ledger_id = X_Ledger_id,
674: status = X_Status,

Line 732: END GL_SUMMARY_TEMPLATES_PKG;

728: end if;
729: END Update_Row;
730:
731:
732: END GL_SUMMARY_TEMPLATES_PKG;