APPS.GCS_SYSTEM_TASKS_PKG SQL Statements

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

Line: 6

  PROCEDURE Insert_Row(	row_id	IN OUT NOCOPY	                VARCHAR2,
				task_code			VARCHAR2,
                        	status_code	                VARCHAR2,
				creation_date			DATE,
				created_by			NUMBER,
				last_update_date		DATE,
				last_updated_by			NUMBER,
				last_update_login		NUMBER,
                        	object_version_number           NUMBER) IS
    CURSOR	task_row IS
    SELECT	row_id
    FROM	gcs_system_tasks st
    WHERE	st.task_code= insert_row.task_code;

Line: 24

    INSERT INTO gcs_system_tasks(task_code,
                                 status_code,
                                 creation_date,
                                 created_by,
                                 last_update_date,
                                 last_updated_by,
                                 last_update_login,
                                 object_version_number)
    SELECT	task_code,
                status_code,
                creation_date,
                created_by,
                last_update_date,
                last_updated_by,
                last_update_login,
                object_version_number
    FROM	dual
    WHERE	NOT EXISTS
		(SELECT	1
		 FROM	gcs_system_tasks st
		 WHERE	st.task_code= insert_row.task_code);

Line: 55

  END Insert_Row;

Line: 57

  PROCEDURE Update_Row(		row_id	IN OUT NOCOPY	        VARCHAR2,
				task_code			VARCHAR2,
                        	status_code	                VARCHAR2,
				creation_date			DATE,
				created_by			NUMBER,
				last_update_date		DATE,
				last_updated_by			NUMBER,
				last_update_login		NUMBER,
                        	object_version_number           NUMBER) IS
  BEGIN
      UPDATE	gcs_system_tasks st
      SET		status_code			= update_row.status_code,
  			last_update_date		= update_row.last_update_date,
  			last_updated_by			= update_row.last_updated_by,
  			last_update_login		= update_row.last_update_login,
  			object_version_number		= update_row.object_version_number
      WHERE		st.task_code 			= update_row.task_code;

Line: 79

  END Update_Row;

Line: 85

				last_update_date		VARCHAR2,
				custom_mode			VARCHAR2,
				status_code		        VARCHAR2,
                		object_version_number           NUMBER) IS

    row_id	VARCHAR2(64);

Line: 92

    f_ludate	DATE;	-- Task update date in file

Line: 94

    db_ludate	DATE;	-- Task update date in db

Line: 100

    f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 103

      SELECT	st.last_updated_by,
                st.last_update_date
      INTO	db_luby,
                db_ludate
      FROM	GCS_SYSTEM_TASKS st
      WHERE	st.task_code = Load_Row.task_code;

Line: 116

        update_row(		row_id				=> row_id,
				task_code			=> TASK_CODE,
				status_code			=> STATUS_CODE,
				creation_date			=> f_ludate,
				created_by			=> f_luby,
				last_update_date		=> f_ludate,
				last_updated_by			=> f_luby,
				last_update_login		=> 0,
                        	object_version_number   	=> OBJECT_VERSION_NUMBER);

Line: 128

        insert_row(		row_id				=> row_id,
				task_code			=> TASK_CODE,
				status_code			=> STATUS_CODE,
				creation_date			=> f_ludate,
				created_by			=> f_luby,
				last_update_date		=> f_ludate,
				last_updated_by			=> f_luby,
				last_update_login		=> 0,
				object_version_number		=> OBJECT_VERSION_NUMBER);