DBA Data[Home] [Help]

APPS.CSM_QUERY_PUB dependencies on CSM_QUERY_PKG

Line 65: CSM_QUERY_PKG.INSERT_QUERY

61: FND_LOG.LEVEL_ERROR);
62:
63: SAVEPOINT CSM_INSERT_QUERY_PUB;
64:
65: CSM_QUERY_PKG.INSERT_QUERY
66: ( p_QUERY_ID => p_QUERY_ID,
67: p_QUERY_NAME => p_QUERY_NAME,
68: P_QUERY_DESC => p_QUERY_DESC,
69: P_QUERY_TYPE => p_QUERY_TYPE,

Line 175: CSM_QUERY_PKG.UPDATE_QUERY

171: FND_LOG.LEVEL_ERROR);
172:
173: SAVEPOINT CSM_UPDATE_QUERY_PUB;
174:
175: CSM_QUERY_PKG.UPDATE_QUERY
176: ( p_QUERY_ID => p_QUERY_ID,
177: p_QUERY_NAME => p_QUERY_NAME,
178: P_QUERY_DESC => p_QUERY_DESC,
179: P_QUERY_TYPE => p_QUERY_TYPE,

Line 257: CSM_QUERY_PKG.DELETE_QUERY

253: FND_LOG.LEVEL_ERROR);
254:
255: SAVEPOINT CSM_DELETE_QUERY_PUB;
256:
257: CSM_QUERY_PKG.DELETE_QUERY
258: (
259: p_QUERY_ID => p_QUERY_ID,
260: x_return_status => x_return_status,
261: x_error_message => x_error_message

Line 314: CSM_QUERY_PKG.EXECUTE_QUERY

310: FND_LOG.LEVEL_ERROR);
311: --Query Execution status update
312: SAVEPOINT CSM_EXECUTE_QUERY_PUB;
313:
314: CSM_QUERY_PKG.EXECUTE_QUERY
315: (
316: p_USER_ID => p_USER_ID,
317: p_QUERY_ID => p_QUERY_ID,
318: p_INSTANCE_ID => p_INSTANCE_ID,

Line 380: CSM_QUERY_PKG.INSERT_INSTANCE

376: FND_LOG.LEVEL_ERROR);
377:
378: SAVEPOINT CSM_INSERT_INSTANCE_PUB;
379:
380: CSM_QUERY_PKG.INSERT_INSTANCE
381: ( p_USER_ID => p_USER_ID,
382: p_QUERY_ID => p_QUERY_ID,
383: p_INSTANCE_ID => p_INSTANCE_ID,
384: p_INSTANCE_NAME => p_INSTANCE_NAME,

Line 443: CSM_QUERY_PKG.DELETE_INSTANCE

439: FND_LOG.LEVEL_ERROR);
440:
441: SAVEPOINT CSM_DELETE_INSTANCE_PUB;
442:
443: CSM_QUERY_PKG.DELETE_INSTANCE
444: ( p_USER_ID => p_USER_ID,
445: p_QUERY_ID => p_QUERY_ID,
446: p_INSTANCE_ID => p_INSTANCE_ID,
447: p_commit => p_COMMIT,

Line 504: CSM_QUERY_PKG.INSERT_RESULT

500: FND_LOG.LEVEL_ERROR);
501:
502: SAVEPOINT CSM_INSERT_RESULT_PUB;
503:
504: CSM_QUERY_PKG.INSERT_RESULT
505: ( p_USER_ID => p_USER_ID,
506: p_QUERY_ID => p_QUERY_ID,
507: p_INSTANCE_ID => p_INSTANCE_ID,
508: p_QUERY_RESULT => p_QUERY_RESULT,