APPS.JE_GR_IE_RULE_LINES_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW (
  p_rule_line_id 		IN OUT NOCOPY NUMBER,
  p_rule_id 			IN 	NUMBER,
  p_application_id		IN 	NUMBER,
  p_lookup_type 		IN 	VARCHAR2,
  p_lookup_code 		IN 	VARCHAR2,
  p_exclude_flag		IN 	VARCHAR2,
  p_attribute_category     	IN      VARCHAR2,
  p_attribute1			IN 	VARCHAR2,
  p_attribute2			IN 	VARCHAR2,
  p_attribute3			IN 	VARCHAR2,
  p_attribute4			IN 	VARCHAR2,
  p_attribute5			IN 	VARCHAR2,
  p_attribute6			IN 	VARCHAR2,
  p_attribute7			IN 	VARCHAR2,
  p_attribute8			IN 	VARCHAR2,
  p_attribute9			IN 	VARCHAR2,
  p_attribute10			IN 	VARCHAR2,
  p_attribute11			IN 	VARCHAR2,
  p_attribute12			IN 	VARCHAR2,
  p_attribute13			IN 	VARCHAR2,
  p_attribute14			IN 	VARCHAR2,
  p_attribute15			IN 	VARCHAR2,
  p_creation_date 		IN 	DATE,
  p_created_by 			IN 	NUMBER,
  p_last_update_date 		IN 	DATE,
  p_last_updated_by 		IN 	NUMBER,
  p_last_update_login 		IN 	NUMBER

) IS

 l_rule_line_id                 je_gr_trnovr_rule_lines.trnovr_rule_line_id%TYPE;

Line: 47

     'JE_GR_IE_RULE_LINES_PKG.INSERT_ROW';

Line: 51

  SELECT je_gr_trnovr_rule_lines_s.nextval INTO l_rule_line_id FROM dual;

Line: 53

  debug_info := 'Insert row in je_gr_trnovr_rule_lines';

Line: 55

  INSERT INTO je_gr_trnovr_rule_lines (
    trnovr_rule_line_id,
    trnovr_rule_id,
    application_id,
    lookup_type,
    lookup_code,
    exclude_flag,
    attribute_category  ,
    attribute1		,
    attribute2		,
    attribute3		,
    attribute4		,
    attribute5		,
    attribute6		,
    attribute7		,
    attribute8		,
    attribute9		,
    attribute10		,
    attribute11		,
    attribute12		,
    attribute13		,
    attribute14		,
    attribute15		,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login
    )
    SELECT
     l_rule_line_id,
     p_rule_id,
     p_application_id,
     p_lookup_type,
     p_lookup_code,
     p_exclude_flag,
     p_attribute_category     ,
     p_attribute1		,
     p_attribute2		,
     p_attribute3		,
     p_attribute4		,
     p_attribute5		,
     p_attribute6		,
     p_attribute7		,
     p_attribute8		,
     p_attribute9		,
     p_attribute10		,
     p_attribute11		,
     p_attribute12		,
     p_attribute13		,
     p_attribute14		,
     p_attribute15		,
     p_creation_date,
     p_created_by,
     p_last_update_date,
     p_last_updated_by,
     p_last_update_login
   FROM DUAL
   WHERE NOT EXISTS ( SELECT NULL
                      FROM je_gr_trnovr_rule_lines
		      WHERE trnovr_rule_id = p_rule_id
		      AND   application_id = p_application_id
		      AND   lookup_type = p_lookup_type
		      AND   lookup_code = p_lookup_code);

Line: 136

  		||'p_last_update_date = '||to_char(p_last_update_date)
  		||'p_last_updated_by = '||to_char(p_last_updated_by)
  		||'p_last_update_login = '||to_char(p_last_update_login));

Line: 146

END INSERT_ROW;

Line: 174

    SELECT
       	lookup_type ,
    	lookup_code   ,
    	exclude_flag        ,
    	attribute_category ,
    	attribute1	,
    	attribute2	,
    	attribute3	,
    	attribute4	,
    	attribute5	,
    	attribute6 	,
    	attribute7	,
    	attribute8	,
    	attribute9	,
    	attribute10,
    	attribute11,
    	attribute12,
    	attribute13,
    	attribute14,
    	attribute15
    FROM je_gr_trnovr_rule_lines
    WHERE trnovr_rule_line_id = p_rule_line_id
    AND   trnovr_rule_id = p_rule_id
    AND   application_id = p_application_id
    FOR UPDATE OF trnovr_rule_line_id nowait;

Line: 251

PROCEDURE UPDATE_ROW (
  p_rule_line_id 		IN  	NUMBER,
  p_rule_id 			IN 	NUMBER,
  p_application_id		IN 	NUMBER,
  p_lookup_type 		IN 	VARCHAR2,
  p_lookup_code 		IN 	VARCHAR2,
  p_exclude_flag		IN 	VARCHAR2,
  p_attribute_category     	IN      VARCHAR2,
  p_attribute1			IN 	VARCHAR2,
  p_attribute2			IN 	VARCHAR2,
  p_attribute3			IN 	VARCHAR2,
  p_attribute4			IN 	VARCHAR2,
  p_attribute5			IN 	VARCHAR2,
  p_attribute6			IN 	VARCHAR2,
  p_attribute7			IN 	VARCHAR2,
  p_attribute8			IN 	VARCHAR2,
  p_attribute9			IN 	VARCHAR2,
  p_attribute10			IN 	VARCHAR2,
  p_attribute11			IN 	VARCHAR2,
  p_attribute12			IN 	VARCHAR2,
  p_attribute13			IN 	VARCHAR2,
  p_attribute14			IN 	VARCHAR2,
  p_attribute15			IN 	VARCHAR2,
  p_last_update_date 		IN 	DATE,
  p_last_updated_by 		IN 	NUMBER,
  p_last_update_login 		IN 	NUMBER
) IS

 debug_info                   VARCHAR2(250);

Line: 287

     'JE_GR_IE_RULE_LINES_PKG.UPDATE_ROW';

Line: 289

  debug_info := 'Update row in je_gr_trnovr_rule_lines';

Line: 291

  UPDATE je_gr_trnovr_rule_lines
  SET
    lookup_type 	= p_lookup_type,
    lookup_code   	= p_lookup_code,
    exclude_flag        = p_exclude_flag,
    attribute_category  = p_attribute_category,
    attribute1		= p_attribute1,
    attribute2		= p_attribute2,
    attribute3		= p_attribute3,
    attribute4		= p_attribute4,
    attribute5		= p_attribute5,
    attribute6 		= p_attribute6,
    attribute7		= p_attribute7,
    attribute8		= p_attribute8,
    attribute9		= p_attribute9,
    attribute10		= p_attribute10,
    attribute11 	= p_attribute11,
    attribute12 	= p_attribute12,
    attribute13		= p_attribute13,
    attribute14		= p_attribute14,
    attribute15		= p_attribute15,
    last_update_date 	= p_last_update_date,
    last_updated_by 	= p_last_updated_by,
    last_update_login 	= p_last_update_login
  WHERE application_id  = p_application_id
  AND   trnovr_rule_id 	= p_rule_id
  AND 	trnovr_rule_line_id 	= p_rule_line_id;

Line: 329

  		||'p_last_update_date = '||to_char(p_last_update_date)
  		||'p_last_updated_by = '||to_char(p_last_updated_by)
  		||'p_last_update_login = '||to_char(p_last_update_login));

Line: 336

END UPDATE_ROW;

Line: 338

PROCEDURE DELETE_ROW (
  p_rule_line_id 	IN 	NUMBER,
  p_rule_id 		IN 	NUMBER
) IS

 debug_info                   VARCHAR2(250);

Line: 351

     'JE_GR_IE_RULE_LINES_PKG.DELETE_ROW';

Line: 353

  debug_info := 'delete row in je_gr_trnovr_rule_lines';

Line: 355

  DELETE FROM je_gr_trnovr_rule_lines
  WHERE  trnovr_rule_id = p_rule_id
  and    trnovr_rule_line_id = p_rule_line_id;

Line: 373

END DELETE_ROW;