APPS.JTF_SE_AUTHPR SQL Statements

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

Line: 2

procedure INSERT_ROW (
  X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
  X_PRINCIPAL_DESC_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_PRINCIPAL_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_USER_ID in NUMBER,
  X_IS_USER_FLAG in NUMBER,
  X_DAC_ROLE_FLAG in NUMBER,
  X_PRINCIPAL_DESC in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  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
begin
  JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW (
  X_JTF_AUTH_PRINCIPAL_ID,
  X_PRINCIPAL_DESC_ID,
  X_OBJECT_VERSION_NUMBER,
  X_PRINCIPAL_NAME,
  X_APPLICATION_ID,
  X_USER_ID,
  X_IS_USER_FLAG,
  X_DAC_ROLE_FLAG,
  X_PRINCIPAL_DESC,
  X_DESCRIPTION,
  X_CREATION_DATE,
  X_CREATED_BY,
  X_LAST_UPDATE_DATE,
  X_LAST_UPDATED_BY,
  X_LAST_UPDATE_LOGIN
);

Line: 37

end INSERT_ROW;

Line: 66

procedure UPDATE_ROW (
  X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
  X_PRINCIPAL_DESC_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_PRINCIPAL_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_USER_ID in NUMBER,
  X_IS_USER_FLAG in NUMBER,
  X_DAC_ROLE_FLAG in NUMBER,
  X_PRINCIPAL_DESC in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  JTF_AUTH_PRINCIPALS_PKG.UPDATE_ROW (
  X_JTF_AUTH_PRINCIPAL_ID,
  X_PRINCIPAL_DESC_ID,
  X_OBJECT_VERSION_NUMBER,
  X_PRINCIPAL_NAME,
  X_APPLICATION_ID,
  X_USER_ID,
  X_IS_USER_FLAG,
  X_DAC_ROLE_FLAG,
  X_PRINCIPAL_DESC,
  X_DESCRIPTION,
  X_LAST_UPDATE_DATE,
  X_LAST_UPDATED_BY,
  X_LAST_UPDATE_LOGIN
);

Line: 97

end UPDATE_ROW;

Line: 99

procedure DELETE_ROW (
  X_JTF_AUTH_PRINCIPAL_ID in NUMBER
) is
begin
  JTF_AUTH_PRINCIPALS_PKG.DELETE_ROW (
  X_JTF_AUTH_PRINCIPAL_ID
);

Line: 106

end DELETE_ROW;

Line: 108

PROCEDURE delete_row (
  p_principal_name IN VARCHAR2,
  p_is_user_flag IN VARCHAR2,
  x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
  x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
  x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS

  BEGIN

    jtf_auth_principals_pkg.delete_row(
	p_principal_name,
	p_is_user_flag,
	x_return_status,
	x_msg_count,
	x_msg_data);

Line: 125

  END delete_row;