APPS.PA_CI_IMPACT_TYPE_USAGE_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID out NOCOPY VARCHAR2,
  X_CI_IMPACT_TYPE_USAGE_ID out NOCOPY NUMBER,

  x_impact_type_code IN varchar2,
  x_ci_type_class_code IN VARCHAR2,
  X_CI_TYPE_ID in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from PA_CI_IMPACT_TYPE_USAGE
    where CI_IMPACT_TYPE_USAGE_ID = X_CI_IMPACT_TYPE_USAGE_ID
    ;

Line: 20

  SELECT pa_ci_impact_type_usage_s.NEXTVAL
  INTO X_CI_IMPACT_TYPE_USAGE_ID
  FROM sys.dual;

Line: 24

  insert into PA_CI_IMPACT_TYPE_USAGE (
				       CI_IMPACT_TYPE_USAGE_ID ,
				       impact_type_code  ,
				       ci_type_class_code ,
				       CI_TYPE_ID ,
				       CREATION_DATE ,
				       CREATED_BY ,
				       LAST_UPDATE_DATE ,
				       LAST_UPDATED_BY,
				       LAST_UPDATE_LOGIN
  ) values (
	    X_CI_IMPACT_TYPE_USAGE_ID ,
	    x_impact_type_code ,
	    x_ci_type_class_code ,
	    X_CI_TYPE_ID ,
	    nvl(X_CREATION_DATE, sysdate),
            nvl(X_CREATED_BY, fnd_global.user_id),
            nvl(X_LAST_UPDATE_DATE, sysdate),
            nvl(X_LAST_UPDATED_BY, fnd_global.user_id),
	    nvl(X_LAST_UPDATE_LOGIN, fnd_global.login_id)
	    	    );

Line: 54

end INSERT_ROW;

Line: 62

  cursor c is select
      impact_type_code,
      ci_type_class_code,
      ci_type_id
    from PA_CI_IMPACT_TYPE_USAGE
    where ci_impact_type_usage_id = X_CI_IMPACT_TYPE_USAGE_ID
    for update of CI_impact_TYPE_USAGE_ID nowait;

Line: 76

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 94

procedure DELETE_ROW (
  X_CI_IMPACT_TYPE_USAGE_ID in NUMBER
) is
begin
  delete from PA_CI_IMPACT_TYPE_USAGE
  where CI_IMPACT_TYPE_USAGE_ID = X_CI_IMPACT_TYPE_USAGE_ID;

Line: 104

end DELETE_ROW;