The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
) AS
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_AD_CAL_CONF
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;
PROCEDURE BeforeRowInsertUpdate1(
p_inserting IN BOOLEAN DEFAULT FALSE,
p_updating IN BOOLEAN DEFAULT FALSE,
p_deleting IN BOOLEAN DEFAULT FALSE
) AS
v_message_name VARCHAR2(30);
IF p_inserting OR
((NVL(old_references.adm_appl_offer_resp_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_offer_resp_dt_alias, 'NULL')) AND
new_references.adm_appl_offer_resp_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_offer_resp_dt_alias,
'ADM_APPL_OFFER_RESP_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_chng_of_pref_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_chng_of_pref_dt_alias, 'NULL')) AND
new_references.adm_appl_chng_of_pref_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_chng_of_pref_dt_alias,
'ADM_APPL_CHNG_OF_PREF_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_due_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_due_dt_alias, 'NULL')) AND
new_references.adm_appl_due_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_due_dt_alias,
'ADM_APPL_DUE_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_final_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_final_dt_alias, 'NULL')) AND
new_references.adm_appl_final_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_final_dt_alias,
'ADM_APPL_FINAL_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.initialise_adm_perd_dt_alias, 'NULL') <>
NVL(new_references.initialise_adm_perd_dt_alias, 'NULL')) AND
new_references.initialise_adm_perd_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.initialise_adm_perd_dt_alias,
'INITIALISE_ADM_PERD_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_encmb_chk_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_encmb_chk_dt_alias, 'NULL')) AND
new_references.adm_appl_encmb_chk_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_encmb_chk_dt_alias,
'ADM_APPL_ENCMB_CHK_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_course_strt_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_course_strt_dt_alias, 'NULL')) AND
new_references.adm_appl_course_strt_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_course_strt_dt_alias,
'ADM_APPL_COURSE_STRT_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_short_strt_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_short_strt_dt_alias, 'NULL')) AND
new_references.adm_appl_short_strt_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_short_strt_dt_alias,
'ADM_APPL_SHORT_STRT_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_e_comp_perd_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_e_comp_perd_dt_alias, 'NULL')) AND
new_references.adm_appl_e_comp_perd_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_e_comp_perd_dt_alias,
'ADM_APPL_E_COMP_PERD_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_m_comp_perd_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_m_comp_perd_dt_alias, 'NULL')) AND
new_references.adm_appl_m_comp_perd_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_m_comp_perd_dt_alias,
'ADM_APPL_M_COMP_PERD_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
((NVL(old_references.adm_appl_s_comp_perd_dt_alias, 'NULL') <>
NVL(new_references.adm_appl_s_comp_perd_dt_alias, 'NULL')) AND
new_references.adm_appl_s_comp_perd_dt_alias IS NOT NULL) THEN
IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
new_references.adm_appl_s_comp_perd_dt_alias,
'ADM_APPL_S_COMP_PERD_DT_ALIAS',
v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
END BeforeRowInsertUpdate1;
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
SELECT rowid
FROM IGS_AD_CAL_CONF
WHERE s_control_num = x_s_control_num
FOR UPDATE NOWAIT;
SELECT rowid
FROM IGS_AD_CAL_CONF
WHERE adm_appl_course_strt_dt_alias = x_dt_alias
OR adm_appl_final_dt_alias = x_dt_alias
OR adm_appl_due_dt_alias = x_dt_alias
OR adm_appl_encmb_chk_dt_alias = x_dt_alias
OR adm_appl_e_comp_perd_dt_alias = x_dt_alias
OR initialise_adm_perd_dt_alias = x_dt_alias
OR adm_appl_m_comp_perd_dt_alias = x_dt_alias
OR adm_appl_chng_of_pref_dt_alias = x_dt_alias
OR adm_appl_offer_resp_dt_alias = x_dt_alias
OR adm_appl_short_strt_dt_alias = x_dt_alias
OR adm_appl_s_comp_perd_dt_alias = x_dt_alias;
SELECT rowid
FROM IGS_AD_CAL_CONF
WHERE inq_cal_type = x_cal_type;
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
) AS
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_s_control_num,
x_initialise_adm_perd_dt_alias,
x_adm_appl_encmb_chk_dt_alias,
x_ad_appl_course_strt_dt_alias,
x_adm_appl_short_strt_dt_alias,
x_adm_appl_due_dt_alias,
x_adm_appl_final_dt_alias,
x_ad_appl_chg_of_pref_dt_alias,
x_adm_appl_offer_resp_dt_alias,
x_ad_appl_e_comp_perd_dt_alias,
x_ad_appl_m_comp_perd_dt_alias,
x_ad_appl_s_comp_perd_dt_alias,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
X_ADM_PRC_TRK_DT_ALIAS,
X_POST_ADM_TRK_DT_ALIAS,
X_INQ_CAL_TYPE
);
IF (p_action = 'INSERT') THEN
BeforeRowInsertUpdate1 ( p_inserting => TRUE );
ELSIF (p_action = 'UPDATE') THEN
BeforeRowInsertUpdate1 ( p_updating => TRUE );
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF Get_PK_For_Validation (
new_references.s_control_num
) THEN
Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
Check_Constraints;
procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_S_CONTROL_NUM in out NOCOPY NUMBER,
X_INITIALISE_AD_PERD_DT_ALIAS in VARCHAR2,
X_AD_APPL_ENCMB_CHK_DT_ALIAS in VARCHAR2,
X_AD_APPL_COURSE_STRT_DT_ALIAS in VARCHAR2,
X_AD_APPL_SHORT_STRT_DT_ALIAS in VARCHAR2,
X_AD_APPL_DUE_DT_ALIAS in VARCHAR2,
X_AD_APPL_FINAL_DT_ALIAS in VARCHAR2,
X_AD_APPL_CHG_OF_PREF_DT_ALIAS in VARCHAR2,
X_AD_APPL_OFFER_RESP_DT_ALIAS in VARCHAR2,
X_AD_APPL_E_COMP_PERD_DT_ALIAS in VARCHAR2,
X_AD_APPL_M_COMP_PERD_DT_ALIAS in VARCHAR2,
X_AD_APPL_S_COMP_PERD_DT_ALIAS in VARCHAR2,
X_MODE in VARCHAR2 default 'R',
X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
) AS
cursor C is select ROWID from IGS_AD_CAL_CONF
where S_CONTROL_NUM = NEW_REFERENCES.S_CONTROL_NUM;
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;
p_action => 'INSERT',
x_rowid => X_ROWID,
x_s_control_num => Nvl(X_S_CONTROL_NUM, 1),
x_initialise_adm_perd_dt_alias => X_INITIALISE_AD_PERD_DT_ALIAS,
x_adm_appl_encmb_chk_dt_alias => X_AD_APPL_ENCMB_CHK_DT_ALIAS,
x_ad_appl_course_strt_dt_alias => X_AD_APPL_COURSE_STRT_DT_ALIAS,
x_adm_appl_short_strt_dt_alias => X_AD_APPL_SHORT_STRT_DT_ALIAS,
x_adm_appl_due_dt_alias => X_AD_APPL_DUE_DT_ALIAS,
x_adm_appl_final_dt_alias => X_AD_APPL_FINAL_DT_ALIAS,
x_ad_appl_chg_of_pref_dt_alias => X_AD_APPL_CHG_OF_PREF_DT_ALIAS,
x_adm_appl_offer_resp_dt_alias => X_AD_APPL_OFFER_RESP_DT_ALIAS,
x_ad_appl_e_comp_perd_dt_alias => X_AD_APPL_E_COMP_PERD_DT_ALIAS,
x_ad_appl_m_comp_perd_dt_alias => X_AD_APPL_M_COMP_PERD_DT_ALIAS,
x_ad_appl_s_comp_perd_dt_alias => X_AD_APPL_S_COMP_PERD_DT_ALIAS,
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_ADM_PRC_TRK_DT_ALIAS => X_ADM_PRC_TRK_DT_ALIAS,
X_POST_ADM_TRK_DT_ALIAS => X_POST_ADM_TRK_DT_ALIAS,
X_INQ_CAL_TYPE => X_INQ_CAL_TYPE
);
insert into IGS_AD_CAL_CONF (
S_CONTROL_NUM,
INITIALISE_ADM_PERD_DT_ALIAS,
ADM_APPL_ENCMB_CHK_DT_ALIAS,
ADM_APPL_COURSE_STRT_DT_ALIAS,
ADM_APPL_SHORT_STRT_DT_ALIAS,
ADM_APPL_DUE_DT_ALIAS,
ADM_APPL_FINAL_DT_ALIAS,
ADM_APPL_CHNG_OF_PREF_DT_ALIAS,
ADM_APPL_OFFER_RESP_DT_ALIAS,
ADM_APPL_E_COMP_PERD_DT_ALIAS,
ADM_APPL_M_COMP_PERD_DT_ALIAS,
ADM_APPL_S_COMP_PERD_DT_ALIAS,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
ADM_PRC_TRK_DT_ALIAS,
POST_ADM_TRK_DT_ALIAS,
INQ_CAL_TYPE
) values (
NEW_REFERENCES.S_CONTROL_NUM,
NEW_REFERENCES.INITIALISE_ADM_PERD_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_ENCMB_CHK_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_COURSE_STRT_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_SHORT_STRT_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_DUE_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_FINAL_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_CHNG_OF_PREF_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_OFFER_RESP_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_E_COMP_PERD_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_M_COMP_PERD_DT_ALIAS,
NEW_REFERENCES.ADM_APPL_S_COMP_PERD_DT_ALIAS,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN ,
NEW_REFERENCES.ADM_PRC_TRK_DT_ALIAS,
NEW_REFERENCES.POST_ADM_TRK_DT_ALIAS,
NEW_REFERENCES.INQ_CAL_TYPE
);
p_action => 'INSERT',
x_rowid => X_ROWID);
end INSERT_ROW;
cursor c1 is select
INITIALISE_ADM_PERD_DT_ALIAS,
ADM_APPL_ENCMB_CHK_DT_ALIAS,
ADM_APPL_COURSE_STRT_DT_ALIAS,
ADM_APPL_SHORT_STRT_DT_ALIAS,
ADM_APPL_DUE_DT_ALIAS,
ADM_APPL_FINAL_DT_ALIAS,
ADM_APPL_CHNG_OF_PREF_DT_ALIAS,
ADM_APPL_OFFER_RESP_DT_ALIAS,
ADM_APPL_E_COMP_PERD_DT_ALIAS,
ADM_APPL_M_COMP_PERD_DT_ALIAS,
ADM_APPL_S_COMP_PERD_DT_ALIAS,
ADM_PRC_TRK_DT_ALIAS,
POST_ADM_TRK_DT_ALIAS,
INQ_CAL_TYPE
from IGS_AD_CAL_CONF
where ROWID = X_ROWID for update nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
procedure UPDATE_ROW (
X_ROWID in VARCHAR2,
X_S_CONTROL_NUM in NUMBER,
X_INITIALISE_AD_PERD_DT_ALIAS in VARCHAR2,
X_AD_APPL_ENCMB_CHK_DT_ALIAS in VARCHAR2,
X_AD_APPL_COURSE_STRT_DT_ALIAS in VARCHAR2,
X_AD_APPL_SHORT_STRT_DT_ALIAS in VARCHAR2,
X_AD_APPL_DUE_DT_ALIAS in VARCHAR2,
X_AD_APPL_FINAL_DT_ALIAS in VARCHAR2,
X_AD_APPL_CHG_OF_PREF_DT_ALIAS in VARCHAR2,
X_AD_APPL_OFFER_RESP_DT_ALIAS in VARCHAR2,
X_AD_APPL_E_COMP_PERD_DT_ALIAS in VARCHAR2,
X_AD_APPL_M_COMP_PERD_DT_ALIAS in VARCHAR2,
X_AD_APPL_S_COMP_PERD_DT_ALIAS in VARCHAR2,
X_MODE in VARCHAR2 default 'R',
X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
) 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;
p_action => 'UPDATE',
x_rowid => X_ROWID,
x_s_control_num => X_S_CONTROL_NUM,
x_initialise_adm_perd_dt_alias => X_INITIALISE_AD_PERD_DT_ALIAS,
x_adm_appl_encmb_chk_dt_alias => X_AD_APPL_ENCMB_CHK_DT_ALIAS,
x_ad_appl_course_strt_dt_alias => X_AD_APPL_COURSE_STRT_DT_ALIAS,
x_adm_appl_short_strt_dt_alias => X_AD_APPL_SHORT_STRT_DT_ALIAS,
x_adm_appl_due_dt_alias => X_AD_APPL_DUE_DT_ALIAS,
x_adm_appl_final_dt_alias => X_AD_APPL_FINAL_DT_ALIAS,
x_ad_appl_chg_of_pref_dt_alias => X_AD_APPL_CHG_OF_PREF_DT_ALIAS,
x_adm_appl_offer_resp_dt_alias => X_AD_APPL_OFFER_RESP_DT_ALIAS,
x_ad_appl_e_comp_perd_dt_alias => X_AD_APPL_E_COMP_PERD_DT_ALIAS,
x_ad_appl_m_comp_perd_dt_alias => X_AD_APPL_M_COMP_PERD_DT_ALIAS,
x_ad_appl_s_comp_perd_dt_alias => X_AD_APPL_S_COMP_PERD_DT_ALIAS,
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_ADM_PRC_TRK_DT_ALIAS => X_ADM_PRC_TRK_DT_ALIAS,
X_POST_ADM_TRK_DT_ALIAS => X_POST_ADM_TRK_DT_ALIAS,
X_INQ_CAL_TYPE => X_INQ_CAL_TYPE
);
update IGS_AD_CAL_CONF set
INITIALISE_ADM_PERD_DT_ALIAS = NEW_REFERENCES.INITIALISE_ADM_PERD_DT_ALIAS,
ADM_APPL_ENCMB_CHK_DT_ALIAS = NEW_REFERENCES.ADM_APPL_ENCMB_CHK_DT_ALIAS,
ADM_APPL_COURSE_STRT_DT_ALIAS = NEW_REFERENCES.ADM_APPL_COURSE_STRT_DT_ALIAS,
ADM_APPL_SHORT_STRT_DT_ALIAS = NEW_REFERENCES.ADM_APPL_SHORT_STRT_DT_ALIAS,
ADM_APPL_DUE_DT_ALIAS = NEW_REFERENCES.ADM_APPL_DUE_DT_ALIAS,
ADM_APPL_FINAL_DT_ALIAS = NEW_REFERENCES.ADM_APPL_FINAL_DT_ALIAS,
ADM_APPL_CHNG_OF_PREF_DT_ALIAS = NEW_REFERENCES.ADM_APPL_CHNG_OF_PREF_DT_ALIAS,
ADM_APPL_OFFER_RESP_DT_ALIAS = NEW_REFERENCES.ADM_APPL_OFFER_RESP_DT_ALIAS,
ADM_APPL_E_COMP_PERD_DT_ALIAS = NEW_REFERENCES.ADM_APPL_E_COMP_PERD_DT_ALIAS,
ADM_APPL_M_COMP_PERD_DT_ALIAS = NEW_REFERENCES.ADM_APPL_M_COMP_PERD_DT_ALIAS,
ADM_APPL_S_COMP_PERD_DT_ALIAS = NEW_REFERENCES.ADM_APPL_S_COMP_PERD_DT_ALIAS,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
ADM_PRC_TRK_DT_ALIAS = NEW_REFERENCES.ADM_PRC_TRK_DT_ALIAS,
POST_ADM_TRK_DT_ALIAS = NEW_REFERENCES.POST_ADM_TRK_DT_ALIAS,
INQ_CAL_TYPE = NEW_REFERENCES.INQ_CAL_TYPE
where ROWID = X_ROWID;
p_action => 'UPDATE',
x_rowid => X_ROWID);
end UPDATE_ROW;
cursor c1 is select rowid from IGS_AD_CAL_CONF
where S_CONTROL_NUM = NVL(X_S_CONTROL_NUM,1);
INSERT_ROW (
X_ROWID,
X_S_CONTROL_NUM,
X_INITIALISE_AD_PERD_DT_ALIAS,
X_AD_APPL_ENCMB_CHK_DT_ALIAS,
X_AD_APPL_COURSE_STRT_DT_ALIAS,
X_AD_APPL_SHORT_STRT_DT_ALIAS,
X_AD_APPL_DUE_DT_ALIAS,
X_AD_APPL_FINAL_DT_ALIAS,
X_AD_APPL_CHG_OF_PREF_DT_ALIAS,
X_AD_APPL_OFFER_RESP_DT_ALIAS,
X_AD_APPL_E_COMP_PERD_DT_ALIAS,
X_AD_APPL_M_COMP_PERD_DT_ALIAS,
X_AD_APPL_S_COMP_PERD_DT_ALIAS,
X_MODE,
X_ADM_PRC_TRK_DT_ALIAS ,
X_POST_ADM_TRK_DT_ALIAS,
X_INQ_CAL_TYPE
);
UPDATE_ROW (
X_ROWID,
X_S_CONTROL_NUM,
X_INITIALISE_AD_PERD_DT_ALIAS,
X_AD_APPL_ENCMB_CHK_DT_ALIAS,
X_AD_APPL_COURSE_STRT_DT_ALIAS,
X_AD_APPL_SHORT_STRT_DT_ALIAS,
X_AD_APPL_DUE_DT_ALIAS,
X_AD_APPL_FINAL_DT_ALIAS,
X_AD_APPL_CHG_OF_PREF_DT_ALIAS,
X_AD_APPL_OFFER_RESP_DT_ALIAS,
X_AD_APPL_E_COMP_PERD_DT_ALIAS,
X_AD_APPL_M_COMP_PERD_DT_ALIAS,
X_AD_APPL_S_COMP_PERD_DT_ALIAS,
X_MODE,
X_ADM_PRC_TRK_DT_ALIAS ,
X_POST_ADM_TRK_DT_ALIAS,
X_INQ_CAL_TYPE
);
procedure DELETE_ROW (
X_ROWID in VARCHAR2
) AS
begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID);
delete from IGS_AD_CAL_CONF
where ROWID = X_ROWID;
p_action => 'DELETE',
x_rowid => X_ROWID);
end DELETE_ROW;