DBA Data[Home] [Help]

APPS.GL_CONS_FLEX_MAP_PKG dependencies on GL_CONS_FLEXFIELD_MAP

Line 75: (SELECT 'X' FROM GL_CONS_FLEXFIELD_MAP fm

71:
72: CURSOR C1 IS SELECT 'Overlapping'
73: FROM DUAL
74: WHERE EXISTS
75: (SELECT 'X' FROM GL_CONS_FLEXFIELD_MAP fm
76: WHERE COA_MAPPING_ID = X_Coa_Mapping_Id
77: AND (row_id IS null OR fm.rowid <> row_id)
78: AND (nvl(segment30_low, 'X') <= nvl(X_Segment30_High,'X')
79: AND nvl(segment30_high,'X') >= nvl(X_Segment30_Low, 'X')

Line 156: select GL_CONS_FLEXFIELD_MAP_S.NEXTVAL

152:
153: PROCEDURE Get_New_Id(next_val IN OUT NOCOPY NUMBER) IS
154:
155: BEGIN
156: select GL_CONS_FLEXFIELD_MAP_S.NEXTVAL
157: into next_val
158: from dual;
159:
160: IF (next_val is NULL) THEN

Line 162: fnd_message.set_token('TAB_S', 'GL_CONS_FLEXFIELD_MAP_S');

158: from dual;
159:
160: IF (next_val is NULL) THEN
161: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
162: fnd_message.set_token('TAB_S', 'GL_CONS_FLEXFIELD_MAP_S');
163: app_exception.raise_exception;
164: END IF;
165: END Get_New_Id;
166: