APPS.PAY_FUNCTIONAL_TRIGGERS_PKG SQL Statements

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

Line: 12

	    SELECT  *
	    FROM    pay_functional_triggers
	    WHERE   rowid = p_row_id
	    FOR UPDATE OF
	            trigger_id NOWAIT;

Line: 47

	PROCEDURE insert_row(
	  p_row_id      IN out nocopy VARCHAR2,
	  p_trigger_id  IN out nocopy NUMBER,
	  p_area_id     IN NUMBER,
	  p_event_id    IN NUMBER
	) IS
 	  --
 	  CURSOR csr_new_id IS
 	    SELECT  pay_functional_triggers_s.NEXTVAL
 	    FROM    dual;

Line: 59

 	    SELECT  rowid
 	    FROM    pay_functional_triggers
 	    WHERE   trigger_id = p_trigger_id;

Line: 69

    INSERT INTO pay_functional_triggers(
      trigger_id,
      area_id,
      event_id
    ) VALUES (
      p_trigger_id,
      p_area_id,
      p_event_id
    );

Line: 86

        'PAY_FUNCTIONAL_TRIGGERS_PKG.INSERT_ROW'
      );

Line: 91

	END insert_row;

Line: 93

	PROCEDURE update_row(
	  p_row_id      IN VARCHAR2,
	  p_trigger_id  IN NUMBER,
	  p_area_id     IN NUMBER,
	  p_event_id    IN NUMBER
	) IS
	BEGIN
    UPDATE  pay_functional_triggers
    SET     trigger_id  = p_trigger_id,
            area_id     = p_area_id,
            event_id    = p_event_id
    WHERE   rowid       = p_row_id;

Line: 110

        'PAY_FUNCTIONAL_TRIGGERS_PKG.UPDATE_ROW'
      );

Line: 113

	END update_row;

Line: 115

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

Line: 128

        'PAY_FUNCTIONAL_TRIGGERS_PKG.DELETE_ROW'
      );

Line: 131

	END delete_row;