The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_closed_ind IN VARCHAR2 ,
x_single_response_flag IN VARCHAR2 ,
x_include_sr_in_rollover_flag IN VARCHAR2
) AS
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_AD_PRD_AD_PRC_CA
WHERE rowid = x_rowid;
IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
Close cur_old_ref_values;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
SELECT rowid
FROM IGS_AD_PRD_AD_PRC_CA
WHERE adm_cal_type = x_adm_cal_type
AND adm_ci_sequence_number = x_adm_ci_sequence_number
AND admission_cat = x_admission_cat
AND s_admission_process_type = x_s_admission_process_type AND
closed_ind = NVL(x_closed_ind,closed_ind);
SELECT rowid
FROM IGS_AD_PRD_AD_PRC_CA
WHERE adm_cal_type = x_adm_cal_type
AND adm_ci_sequence_number = x_adm_ci_sequence_number
AND admission_cat = x_admission_cat ;
SELECT rowid
FROM IGS_AD_PRD_AD_PRC_CA
WHERE admission_cat = x_admission_cat
AND s_admission_process_type = x_s_admission_process_type ;
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_closed_ind IN VARCHAR2,
x_single_response_flag IN VARCHAR2,
x_include_sr_in_rollover_flag IN VARCHAR2
) AS
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_adm_cal_type,
x_adm_ci_sequence_number,
x_admission_cat,
x_s_admission_process_type,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login ,
x_closed_ind,
x_single_response_flag,
x_include_sr_in_rollover_flag
);
IF (p_action = 'INSERT') THEN
Null;
ELSIF (p_action = 'UPDATE') THEN
Check_Constraints;
ELSIF (p_action = 'DELETE') THEN
Check_Child_Existance;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF Get_PK_For_Validation (
new_references.adm_cal_type,
new_references.adm_ci_sequence_number,
new_references.admission_cat,
new_references.s_admission_process_type
) THEN
Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
Check_Constraints;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
Check_Child_Existance;
IF p_action IN ('INSERT', 'UPDATE', 'VALIDATE_INSERT', 'VALIDATE_UPDATE') THEN
IF NVL(new_references.include_sr_in_rollover_flag,'N') = 'Y' AND NVL(new_references.single_response_flag,'N') = 'N' THEN
Fnd_Message.Set_Name ('IGS', 'IGS_AD_SR_CHECK_VALUE'); -- Single Response Rollover checkbox cannot be checked without checking Single Response checkbox.
PROCEDURE INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_ADM_CAL_TYPE in VARCHAR2,
X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
X_ADMISSION_CAT in VARCHAR2,
X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
X_MODE in VARCHAR2 ,
x_closed_ind IN VARCHAR2,
x_single_response_flag IN VARCHAR2,
x_include_sr_in_rollover_flag IN VARCHAR2
) AS
cursor C is select ROWID from IGS_AD_PRD_AD_PRC_CA
where ADM_CAL_TYPE = X_ADM_CAL_TYPE
and ADM_CI_SEQUENCE_NUMBER = X_ADM_CI_SEQUENCE_NUMBER
and ADMISSION_CAT = X_ADMISSION_CAT
and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE;
X_LAST_UPDATE_DATE DATE;
X_LAST_UPDATED_BY NUMBER;
X_LAST_UPDATE_LOGIN NUMBER;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
IF X_LAST_UPDATED_BY is NULL THEN
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
IF X_LAST_UPDATE_LOGIN is NULL THEN
X_LAST_UPDATE_LOGIN := -1;
Before_DML(p_action =>'INSERT',
x_rowid =>X_ROWID,
x_adm_cal_type => X_ADM_CAL_TYPE,
x_adm_ci_sequence_number => X_ADM_CI_SEQUENCE_NUMBER,
x_admission_cat => X_ADMISSION_CAT,
x_s_admission_process_type => X_S_ADMISSION_PROCESS_TYPE,
x_creation_date => X_LAST_UPDATE_DATE,
x_created_by => X_LAST_UPDATED_BY,
x_last_update_date => X_LAST_UPDATE_DATE,
x_last_updated_by => X_LAST_UPDATED_BY,
x_last_update_login => X_LAST_UPDATE_LOGIN,
x_closed_ind => x_closed_ind,
x_single_response_flag => x_single_response_flag,
x_include_sr_in_rollover_flag => x_include_sr_in_rollover_flag
);
INSERT INTO IGS_AD_PRD_AD_PRC_CA (
ADM_CAL_TYPE,
ADM_CI_SEQUENCE_NUMBER,
ADMISSION_CAT,
S_ADMISSION_PROCESS_TYPE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CLOSED_IND,
SINGLE_RESPONSE_FLAG,
INCLUDE_SR_IN_ROLLOVER_FLAG
) values (
NEW_REFERENCES.ADM_CAL_TYPE,
NEW_REFERENCES.ADM_CI_SEQUENCE_NUMBER,
NEW_REFERENCES.ADMISSION_CAT,
NEW_REFERENCES.S_ADMISSION_PROCESS_TYPE,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
NEW_REFERENCES.CLOSED_IND,
NEW_REFERENCES.SINGLE_RESPONSE_FLAG,
NEW_REFERENCES.INCLUDE_SR_IN_ROLLOVER_FLAG
);
p_action =>'INSERT',
x_rowid => X_ROWID
);
END INSERT_ROW;
PROCEDURE update_row (
X_ROWID in VARCHAR2,
X_ADM_CAL_TYPE in VARCHAR2,
X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
X_ADMISSION_CAT in VARCHAR2,
X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
X_MODE in VARCHAR2 ,
x_closed_ind IN VARCHAR2,
x_single_response_flag IN VARCHAR2,
x_include_sr_in_rollover_flag IN VARCHAR2
) AS
X_LAST_UPDATE_DATE DATE;
X_LAST_UPDATED_BY NUMBER;
X_LAST_UPDATE_LOGIN NUMBER;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
if X_LAST_UPDATED_BY is NULL then
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
if X_LAST_UPDATE_LOGIN is NULL then
X_LAST_UPDATE_LOGIN := -1;
Before_DML(p_action =>'UPDATE',
x_rowid =>X_ROWID,
x_adm_cal_type => X_ADM_CAL_TYPE,
x_adm_ci_sequence_number => X_ADM_CI_SEQUENCE_NUMBER,
x_admission_cat => X_ADMISSION_CAT,
x_s_admission_process_type => X_S_ADMISSION_PROCESS_TYPE,
x_creation_date => X_LAST_UPDATE_DATE,
x_created_by => X_LAST_UPDATED_BY,
x_last_update_date => X_LAST_UPDATE_DATE,
x_last_updated_by => X_LAST_UPDATED_BY,
x_last_update_login => X_LAST_UPDATE_LOGIN,
x_closed_ind => x_closed_ind,
x_single_response_flag => x_single_response_flag,
x_include_sr_in_rollover_flag => x_include_sr_in_rollover_flag
);
UPDATE IGS_AD_PRD_AD_PRC_CA SET
ADM_CAL_TYPE = new_references.adm_cal_type,
ADM_CI_SEQUENCE_NUMBER = new_references.adm_ci_sequence_number,
ADMISSION_CAT = new_references.admission_cat,
S_ADMISSION_PROCESS_TYPE = new_references.s_admission_process_type,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
CLOSED_IND = X_CLOSED_IND,
SINGLE_RESPONSE_FLAG = X_SINGLE_RESPONSE_FLAG,
INCLUDE_SR_IN_ROLLOVER_FLAG = X_INCLUDE_SR_IN_ROLLOVER_FLAG
WHERE
ROWID = X_ROWID;
p_action =>'UPDATE',
x_rowid => X_ROWID
);
END update_row;
CURSOR c1 IS SELECT
rowid
FROM IGS_AD_PRD_AD_PRC_CA
WHERE ROWID = X_ROWID for update nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE DELETE_ROW (
X_ROWID in VARCHAR2
) AS
BEGIN
Before_DML(
p_action =>'DELETE',
x_rowid => X_ROWID
);
DELETE FROM IGS_AD_PRD_AD_PRC_CA
WHERE ROWID = X_ROWID;
p_action =>'DELETE',
x_rowid => X_ROWID
);
END DELETE_ROW;