APPS.PAY_FUNCTIONAL_USAGES_PKG SQL Statements

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

Line: 14

	    SELECT  *
	    FROM    pay_functional_usages
	    WHERE   rowid = p_row_id
	    FOR UPDATE OF
	            usage_id NOWAIT;

Line: 53

	PROCEDURE insert_row(
	  p_row_id            IN out nocopy VARCHAR2,
	  p_usage_id          IN out nocopy NUMBER,
	  p_area_id           IN NUMBER,
	  p_legislation_code  IN VARCHAR2,
	  p_business_group_id IN NUMBER,
	  p_payroll_id        IN NUMBER
	) IS
 	  --
 	  CURSOR csr_new_id IS
 	    SELECT  pay_functional_usages_s.NEXTVAL
 	    FROM    dual;

Line: 67

 	    SELECT  rowid
 	    FROM    pay_functional_usages
 	    WHERE   usage_id = p_usage_id;

Line: 77

    INSERT INTO pay_functional_usages(
      usage_id,
      area_id,
      legislation_code,
      business_group_id,
      payroll_id
    ) VALUES (
      p_usage_id,
      p_area_id,
      p_legislation_code,
      p_business_group_id,
      p_payroll_id
    );

Line: 98

        'PAY_FUNCTIONAL_USAGES_PKG.INSERT_ROW'
      );

Line: 103

	END insert_row;

Line: 105

	PROCEDURE update_row(
	  p_row_id            IN VARCHAR2,
	  p_usage_id          IN NUMBER,
	  p_area_id           IN NUMBER,
	  p_legislation_code  IN VARCHAR2,
	  p_business_group_id IN NUMBER,
	  p_payroll_id        IN NUMBER
	) IS
  BEGIN
    UPDATE  pay_functional_usages
    SET     usage_id          = p_usage_id,
            area_id           = p_area_id,
            legislation_code  = p_legislation_code,
            business_group_id = p_business_group_id,
            payroll_id        = p_payroll_id
    WHERE   rowid             = p_row_id;

Line: 126

        'PAY_FUNCTIONAL_USAGES_PKG.UPDATE_ROW'
      );

Line: 129

	END update_row;

Line: 131

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

Line: 144

        'PAY_FUNCTIONAL_USAGES_PKG.DELETE_ROW'
      );

Line: 147

	END delete_row;