DBA Data[Home] [Help]

APPS.ICX_POR_CTX_SQL_PKG dependencies on ICX_POR_CTX_SQL_PKG

Line 1: PACKAGE BODY ICX_POR_CTX_SQL_PKG AS

1: PACKAGE BODY ICX_POR_CTX_SQL_PKG AS
2: -- $Header: ICXCTXB.pls 115.3 2004/03/31 21:56:26 vkartik ship $
3:
4: /* Constructs the sql required to populate icx_por_ctx_tl
5: - pCategoryId - Category Id, pass in 0 if constructing for the root attributes

Line 233: 'Exception at ICX_POR_CTX_SQL_PKG.build_ctx_sql1('||xErrLoc||'), '||SQLERRM);

229: EXCEPTION
230: WHEN OTHERS THEN
231: ROLLBACK;
232: RAISE_APPLICATION_ERROR (-20000,
233: 'Exception at ICX_POR_CTX_SQL_PKG.build_ctx_sql1('||xErrLoc||'), '||SQLERRM);
234: END build_ctx_sql;
235:
236: /* Constructs the sql required to populate icx_por_ctx_tl
237: - pCategoryId - Category Id, pass in 0 if constructing for the root attributes

Line 313: 'Exception at ICX_POR_CTX_SQL_PKG.build_ctx_sql2('||xErrLoc||'), '||SQLERRM );

309: EXCEPTION
310: WHEN OTHERS THEN
311: ROLLBACK;
312: RAISE_APPLICATION_ERROR (-20000,
313: 'Exception at ICX_POR_CTX_SQL_PKG.build_ctx_sql2('||xErrLoc||'), '||SQLERRM );
314: END build_ctx_sql;
315:
316: /* Constructs the sql required to populate icx_por_ctx_tl
317: - pCategoryId - Category Id, pass in 0 if constructing for the root attributes

Line 347: END ICX_POR_CTX_SQL_PKG;

343: build_ctx_sql(pCategoryId, pWhereClause, null, DEFAULT_MAX_LENGTH,
344: pInsertSQL, pUpdateSQL);
345: END build_ctx_sql;
346:
347: END ICX_POR_CTX_SQL_PKG;