APPS.PAY_FUNCTIONAL_AREAS_PKG SQL Statements

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

Line: 12

 	    SELECT  *
 	    FROM    pay_functional_areas
 	    WHERE   rowid = p_row_id
 	    FOR UPDATE OF
 	            area_id NOWAIT;

Line: 48

PROCEDURE insert_row(
		p_row_id        IN out nocopy VARCHAR2,
 		p_area_id	IN out nocopy NUMBER,
 		p_short_name	IN VARCHAR2,
 		p_description 	IN VARCHAR2
 	) IS
 	  --
 	  CURSOR csr_new_id IS
 	    SELECT  pay_functional_areas_s.NEXTVAL
 	    FROM    dual;

Line: 60

 	    SELECT  rowid
 	    FROM    pay_functional_areas
 	    WHERE   area_id = p_area_id;

Line: 70

    INSERT INTO pay_functional_areas(
      area_id,
      short_name,
      description
    ) VALUES (
      p_area_id,
      p_short_name,
      p_description
    );

Line: 87

        'PAY_FUNCTIONAL_AREAS_PKG.INSERT_ROW'
      );

Line: 92

 END insert_row;

Line: 95

PROCEDURE update_row(
		p_row_id        IN VARCHAR2,
 		p_area_id	IN NUMBER,
 		p_short_name	IN VARCHAR2,
 		p_description 	IN VARCHAR2
 	) IS
 BEGIN
    UPDATE  pay_functional_areas
    SET     area_id                     = p_area_id,
            short_name                  = p_short_name,
            description                 = p_description
    WHERE   rowid                       = p_row_id;

Line: 112

        'PAY_FUNCTIONAL_AREAS_PKG.UPDATE_ROW'
      );

Line: 115

 END update_row;

Line: 117

PROCEDURE delete_row(
		p_row_id        IN VARCHAR2,
 		p_area_id	IN NUMBER
 	) IS
BEGIN
    DELETE
    FROM    pay_functional_areas
    WHERE   rowid = p_row_id;

Line: 130

        'PAY_FUNCTIONAL_AREAS_PKG.DELETE_ROW'
      );

Line: 133

END delete_row;

Line: 152

	select null
	from pay_functional_areas pfa
	where pfa.short_name = p_short_name
	and (pfa.area_id <> p_area_id
	     or p_area_id is null);