APPS.GL_SUMMARY_TEMPLATES_PKG dependencies on GL_SUMMARY_TEMPLATES_S

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 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 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