APPS.ICX_POR_POPULATE_DESC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

** Synopsis  : Update the ctx_desc column
**
** Parameter:  p_jobno - number of the job to rebuild
** Parameter:  Rebuild = Y/N  - 'Y'  - rebuild all ctx_ columns
**                              'N'  - populate the ctx_ column for
**                                     all items where the column is null
*/
PROCEDURE populateCtxDescAll(p_jobno IN INTEGER := 0,
			     p_rebuildAll IN VARCHAR2 := 'N') IS

  xErrLoc PLS_INTEGER;

Line: 35

** Synopsis  : Update the ctx_desc column
**
** Parameter:  p_jobno - number of the job to rebuild
** Parameter:  Rebuild = Y/N  - 'Y'  - rebuild all ctx_ columns
**                              'N'  - populate the ctx_ column for
**                                     all items where the column is null
*/
PROCEDURE populateCtxDescAll(p_jobno IN INTEGER := 0,
                             p_rebuildAll IN VARCHAR2 := 'N',
                             p_loglevel IN NUMBER,
			     p_logfile IN VARCHAR2) IS
  xErrLoc PLS_INTEGER := 1000;

Line: 91

** Synopsis  : Update the ctx_desc column
*/
PROCEDURE populateDescAll(p_jobno IN INTEGER := 0) IS
    xErrLoc PLS_INTEGER := 100;

Line: 116

** Synopsis  : Update the ctx_desc column
**
*/
PROCEDURE rebuildAll IS

  xErrLoc PLS_INTEGER := 100;