[Home] [Help]
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_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
X_DECISION_REASON_ID NUMBER DEFAULT NULL,
X_PENDING_REASON_ID NUMBER DEFAULT NULL,
X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
) AS
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_AD_PS_APLINSTHST_ALL
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;
SELECT rowid
FROM IGS_AD_PS_APLINSTHST_ALL
WHERE person_id = x_person_id
AND admission_appl_number = x_admission_appl_number
AND nominated_course_cd = x_nominated_course_cd
AND sequence_number = x_sequence_number
AND hist_start_dt = x_hist_start_dt
FOR UPDATE NOWAIT;
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_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
X_DECISION_REASON_ID NUMBER DEFAULT NULL,
X_PENDING_REASON_ID NUMBER DEFAULT NULL,
X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
) AS
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_org_id,
x_course_cd,
x_crv_version_number,
x_location_cd,
x_attendance_mode,
x_attendance_type,
x_unit_set_cd,
x_us_version_number,
x_preference_number,
x_adm_doc_status,
x_adm_entry_qual_status,
x_late_adm_fee_status,
x_adm_outcome_status,
x_adm_otcm_status_auth_per_id,
x_adm_outcome_status_auth_dt,
x_adm_outcome_status_reason,
x_offer_dt,
x_offer_response_dt,
x_prpsd_commencement_dt,
x_adm_cndtnl_offer_status,
x_cndtnl_offer_satisfied_dt,
x_cndtnl_ofr_must_be_stsfd_ind,
x_adm_offer_resp_status,
x_actual_response_dt,
x_adm_offer_dfrmnt_status,
x_deferred_adm_cal_type,
x_deferred_adm_ci_sequence_num,
x_deferred_tracking_id,
x_ass_rank,
x_secondary_ass_rank,
x_intrntnl_accept_advice_num,
x_ass_tracking_id,
x_fee_cat,
x_hecs_payment_option,
x_expected_completion_yr,
x_expected_completion_perd,
x_correspondence_cat,
x_enrolment_cat,
x_funding_source,
x_cndtnl_offer_cndtn,
x_applicant_acptnce_cndtn,
x_person_id,
x_admission_appl_number,
x_nominated_course_cd,
x_sequence_number,
x_hist_start_dt,
x_hist_end_dt,
x_hist_who,
x_hist_offer_round_number,
x_adm_cal_type,
x_adm_ci_sequence_number,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_appl_inst_status, --arvsrini igsm
x_decision_date , -- begin APADEGAL adtd001 igs.m
x_decision_make_id ,
x_decision_reason_id ,
x_pending_reason_id ,
x_waitlist_status ,
x_waitlist_rank ,
x_future_acad_cal_type ,
x_future_acad_ci_sequence_num ,
x_future_adm_cal_type ,
x_future_adm_ci_sequence_num ,
x_def_acad_cal_type ,
x_def_acad_ci_sequence_num ,
x_reconsider_flag ,
x_decline_ofr_reason -- end APADEGAL adtd001 igs.m
);
IF (p_action = 'INSERT') THEN
IF Get_PK_For_Validation (
new_references.person_id,
new_references.admission_appl_number,
new_references.nominated_course_cd,
new_references.sequence_number,
new_references.hist_start_dt
) THEN
Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
ELSIF (p_action = 'UPDATE') THEN
Check_Constraints;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF Get_PK_For_Validation (
new_references.person_id,
new_references.admission_appl_number,
new_references.nominated_course_cd,
new_references.sequence_number,
new_references.hist_start_dt
) THEN
Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
Check_Constraints;
procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_ORG_ID in NUMBER,
X_PERSON_ID in NUMBER,
X_ADMISSION_APPL_NUMBER in NUMBER,
X_NOMINATED_COURSE_CD in VARCHAR2,
X_SEQUENCE_NUMBER in NUMBER,
X_HIST_START_DT in DATE,
X_APPLICANT_ACPTNCE_CNDTN in VARCHAR2,
X_CNDTNL_OFFER_CNDTN in VARCHAR2,
X_HIST_END_DT in DATE,
X_HIST_WHO in NUMBER,
X_HIST_OFFER_ROUND_NUMBER in NUMBER,
X_ADM_CAL_TYPE in VARCHAR2,
X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
X_COURSE_CD in VARCHAR2,
X_CRV_VERSION_NUMBER in NUMBER,
X_LOCATION_CD in VARCHAR2,
X_ATTENDANCE_MODE in VARCHAR2,
X_ATTENDANCE_TYPE in VARCHAR2,
X_UNIT_SET_CD in VARCHAR2,
X_US_VERSION_NUMBER in NUMBER,
X_PREFERENCE_NUMBER in NUMBER,
X_ADM_DOC_STATUS in VARCHAR2,
X_ADM_ENTRY_QUAL_STATUS in VARCHAR2,
X_LATE_ADM_FEE_STATUS in VARCHAR2,
X_ADM_OUTCOME_STATUS in VARCHAR2,
X_ADM_OTCM_STATUS_AUTH_PER_ID in NUMBER,
X_ADM_OUTCOME_STATUS_AUTH_DT in DATE,
X_ADM_OUTCOME_STATUS_REASON in VARCHAR2,
X_OFFER_DT in DATE,
X_OFFER_RESPONSE_DT in DATE,
X_PRPSD_COMMENCEMENT_DT in DATE,
X_ADM_CNDTNL_OFFER_STATUS in VARCHAR2,
X_CNDTNL_OFFER_SATISFIED_DT in DATE,
X_CNDTNL_OFR_MUST_BE_STSFD_IND in VARCHAR2,
X_ADM_OFFER_RESP_STATUS in VARCHAR2,
X_ACTUAL_RESPONSE_DT in DATE,
X_ADM_OFFER_DFRMNT_STATUS in VARCHAR2,
X_DEFERRED_ADM_CAL_TYPE in VARCHAR2,
X_DEFERRED_ADM_CI_SEQUENCE_NUM in NUMBER,
X_DEFERRED_TRACKING_ID in NUMBER,
X_ASS_RANK in NUMBER,
X_SECONDARY_ASS_RANK in NUMBER,
X_INTRNTNL_ACCEPT_ADVICE_NUM in NUMBER,
X_ASS_TRACKING_ID in NUMBER,
X_FEE_CAT in VARCHAR2,
X_HECS_PAYMENT_OPTION in VARCHAR2,
X_EXPECTED_COMPLETION_YR in NUMBER,
X_EXPECTED_COMPLETION_PERD in VARCHAR2,
X_CORRESPONDENCE_CAT in VARCHAR2,
X_ENROLMENT_CAT in VARCHAR2,
X_FUNDING_SOURCE in VARCHAR2,
X_MODE in VARCHAR2,
X_APPL_INST_STATUS IN VARCHAR2, --arvsrini igsm
X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
X_DECISION_REASON_ID NUMBER DEFAULT NULL,
X_PENDING_REASON_ID NUMBER DEFAULT NULL,
X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
) as
cursor C is select ROWID from IGS_AD_PS_APLINSTHST_ALL
where PERSON_ID = X_PERSON_ID
and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
and HIST_START_DT = X_HIST_START_DT;
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_org_id => igs_ge_gen_003.get_org_id,
x_course_cd => X_COURSE_CD,
x_crv_version_number => X_CRV_VERSION_NUMBER,
x_location_cd => X_LOCATION_CD,
x_attendance_mode=>X_ATTENDANCE_MODE,
x_attendance_type=>X_ATTENDANCE_TYPE,
x_unit_set_cd=>X_UNIT_SET_CD,
x_us_version_number =>X_US_VERSION_NUMBER,
x_preference_number =>X_PREFERENCE_NUMBER,
x_adm_doc_status =>X_ADM_DOC_STATUS,
x_adm_entry_qual_status =>X_ADM_ENTRY_QUAL_STATUS,
x_late_adm_fee_status =>X_LATE_ADM_FEE_STATUS,
x_adm_outcome_status =>X_ADM_OUTCOME_STATUS,
x_adm_otcm_status_auth_per_id =>X_ADM_OTCM_STATUS_AUTH_PER_ID,
x_adm_outcome_status_auth_dt =>X_ADM_OUTCOME_STATUS_AUTH_DT,
x_adm_outcome_status_reason =>X_ADM_OUTCOME_STATUS_REASON,
x_offer_dt =>X_OFFER_DT,
x_offer_response_dt =>X_OFFER_RESPONSE_DT,
x_prpsd_commencement_dt =>X_PRPSD_COMMENCEMENT_DT,
x_adm_cndtnl_offer_status =>X_ADM_CNDTNL_OFFER_STATUS,
x_cndtnl_offer_satisfied_dt =>X_CNDTNL_OFFER_SATISFIED_DT,
x_cndtnl_ofr_must_be_stsfd_ind => NVL(X_CNDTNL_OFR_MUST_BE_STSFD_IND,'N'),
x_adm_offer_resp_status => X_ADM_OFFER_RESP_STATUS,
x_actual_response_dt => X_ACTUAL_RESPONSE_DT,
x_adm_offer_dfrmnt_status =>X_ADM_OFFER_DFRMNT_STATUS,
x_deferred_adm_cal_type =>X_DEFERRED_ADM_CAL_TYPE,
x_deferred_adm_ci_sequence_num =>X_DEFERRED_ADM_CI_SEQUENCE_NUM,
x_deferred_tracking_id =>X_DEFERRED_TRACKING_ID,
x_ass_rank =>X_ASS_RANK,
x_secondary_ass_rank =>X_SECONDARY_ASS_RANK,
x_intrntnl_accept_advice_num =>X_INTRNTNL_ACCEPT_ADVICE_NUM,
x_ass_tracking_id =>X_ASS_TRACKING_ID,
x_fee_cat =>X_FEE_CAT,
x_hecs_payment_option =>X_HECS_PAYMENT_OPTION,
x_expected_completion_yr =>X_EXPECTED_COMPLETION_YR,
x_expected_completion_perd =>X_EXPECTED_COMPLETION_PERD,
x_correspondence_cat =>X_CORRESPONDENCE_CAT,
x_enrolment_cat =>X_ENROLMENT_CAT,
x_funding_source =>X_FUNDING_SOURCE,
x_cndtnl_offer_cndtn =>X_CNDTNL_OFFER_CNDTN,
x_applicant_acptnce_cndtn =>X_APPLICANT_ACPTNCE_CNDTN,
x_person_id =>X_PERSON_ID,
x_admission_appl_number =>X_ADMISSION_APPL_NUMBER,
x_nominated_course_cd =>X_NOMINATED_COURSE_CD,
x_sequence_number =>X_SEQUENCE_NUMBER,
x_hist_start_dt =>X_HIST_START_DT,
x_hist_end_dt =>X_HIST_END_DT,
x_hist_who =>X_HIST_WHO,
x_hist_offer_round_number=>X_HIST_OFFER_ROUND_NUMBER,
x_adm_cal_type =>X_ADM_CAL_TYPE,
x_adm_ci_sequence_number =>X_ADM_CI_SEQUENCE_NUMBER,
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_appl_inst_status => X_APPL_INST_STATUS, --arvsrini igsm
x_decision_date => x_decision_date , -- begin apadegal td001 igsm
x_decision_make_id => x_decision_make_id ,
x_decision_reason_id => x_decision_reason_id ,
x_pending_reason_id => x_pending_reason_id ,
x_waitlist_status => x_waitlist_status ,
x_waitlist_rank => x_waitlist_rank ,
x_future_acad_cal_type => x_future_acad_cal_type ,
x_future_acad_ci_sequence_num => x_future_acad_ci_sequence_num ,
x_future_adm_cal_type => x_future_adm_cal_type ,
x_future_adm_ci_sequence_num => x_future_adm_ci_sequence_num ,
x_def_acad_cal_type => x_def_acad_cal_type ,
x_def_acad_ci_sequence_num => x_def_acad_ci_sequence_num ,
x_reconsider_flag => x_reconsider_flag ,
x_decline_ofr_reason => x_decline_ofr_reason -- end apadegal td001 igsm
);
insert into IGS_AD_PS_APLINSTHST_ALL (
ORG_ID,
APPLICANT_ACPTNCE_CNDTN,
CNDTNL_OFFER_CNDTN,
PERSON_ID,
ADMISSION_APPL_NUMBER,
NOMINATED_COURSE_CD,
SEQUENCE_NUMBER,
HIST_START_DT,
HIST_END_DT,
HIST_WHO,
HIST_OFFER_ROUND_NUMBER,
ADM_CAL_TYPE,
ADM_CI_SEQUENCE_NUMBER,
COURSE_CD,
CRV_VERSION_NUMBER,
LOCATION_CD,
ATTENDANCE_MODE,
ATTENDANCE_TYPE,
UNIT_SET_CD,
US_VERSION_NUMBER,
PREFERENCE_NUMBER,
ADM_DOC_STATUS,
ADM_ENTRY_QUAL_STATUS,
LATE_ADM_FEE_STATUS,
ADM_OUTCOME_STATUS,
ADM_OTCM_STATUS_AUTH_PERSON_ID,
ADM_OUTCOME_STATUS_AUTH_DT,
ADM_OUTCOME_STATUS_REASON,
OFFER_DT,
OFFER_RESPONSE_DT,
PRPSD_COMMENCEMENT_DT,
ADM_CNDTNL_OFFER_STATUS,
CNDTNL_OFFER_SATISFIED_DT,
CNDTNL_OFFER_MUST_BE_STSFD_IND,
ADM_OFFER_RESP_STATUS,
ACTUAL_RESPONSE_DT,
ADM_OFFER_DFRMNT_STATUS,
DEFERRED_ADM_CAL_TYPE,
DEFERRED_ADM_CI_SEQUENCE_NUM,
DEFERRED_TRACKING_ID,
ASS_RANK,
SECONDARY_ASS_RANK,
INTRNTNL_ACCEPTANCE_ADVICE_NUM,
ASS_TRACKING_ID,
FEE_CAT,
HECS_PAYMENT_OPTION,
EXPECTED_COMPLETION_YR,
EXPECTED_COMPLETION_PERD,
CORRESPONDENCE_CAT,
ENROLMENT_CAT,
FUNDING_SOURCE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
APPL_INST_STATUS, --arvsrini igsm
DECISION_DATE , -- BEGIN APADEGAL TD001 IGSM
DECISION_MAKE_ID ,
DECISION_REASON_ID ,
PENDING_REASON_ID ,
WAITLIST_STATUS ,
WAITLIST_RANK ,
FUTURE_ACAD_CAL_TYPE ,
FUTURE_ACAD_CI_SEQUENCE_NUM ,
FUTURE_ADM_CAL_TYPE ,
FUTURE_ADM_CI_SEQUENCE_NUM ,
DEF_ACAD_CAL_TYPE ,
DEF_ACAD_CI_SEQUENCE_NUM ,
RECONSIDER_FLAG ,
DECLINE_OFR_REASON -- end APADEGAL TD001 IGSM
) values (
NEW_REFERENCES.ORG_ID,
NEW_REFERENCES.APPLICANT_ACPTNCE_CNDTN,
NEW_REFERENCES.CNDTNL_OFFER_CNDTN,
NEW_REFERENCES.PERSON_ID,
NEW_REFERENCES.ADMISSION_APPL_NUMBER,
NEW_REFERENCES.NOMINATED_COURSE_CD,
NEW_REFERENCES.SEQUENCE_NUMBER,
NEW_REFERENCES.HIST_START_DT,
NEW_REFERENCES.HIST_END_DT,
NEW_REFERENCES.HIST_WHO,
NEW_REFERENCES.HIST_OFFER_ROUND_NUMBER,
NEW_REFERENCES.ADM_CAL_TYPE,
NEW_REFERENCES.ADM_CI_SEQUENCE_NUMBER,
NEW_REFERENCES.COURSE_CD,
NEW_REFERENCES.CRV_VERSION_NUMBER,
NEW_REFERENCES.LOCATION_CD,
NEW_REFERENCES.ATTENDANCE_MODE,
NEW_REFERENCES.ATTENDANCE_TYPE,
NEW_REFERENCES.UNIT_SET_CD,
NEW_REFERENCES.US_VERSION_NUMBER,
NEW_REFERENCES.PREFERENCE_NUMBER,
NEW_REFERENCES.ADM_DOC_STATUS,
NEW_REFERENCES.ADM_ENTRY_QUAL_STATUS,
NEW_REFERENCES.LATE_ADM_FEE_STATUS,
NEW_REFERENCES.ADM_OUTCOME_STATUS,
NEW_REFERENCES.ADM_OTCM_STATUS_AUTH_PERSON_ID,
NEW_REFERENCES.ADM_OUTCOME_STATUS_AUTH_DT,
NEW_REFERENCES.ADM_OUTCOME_STATUS_REASON,
NEW_REFERENCES.OFFER_DT,
NEW_REFERENCES.OFFER_RESPONSE_DT,
NEW_REFERENCES.PRPSD_COMMENCEMENT_DT,
NEW_REFERENCES.ADM_CNDTNL_OFFER_STATUS,
NEW_REFERENCES.CNDTNL_OFFER_SATISFIED_DT,
NEW_REFERENCES.CNDTNL_OFFER_MUST_BE_STSFD_IND,
NEW_REFERENCES.ADM_OFFER_RESP_STATUS,
NEW_REFERENCES.ACTUAL_RESPONSE_DT,
NEW_REFERENCES.ADM_OFFER_DFRMNT_STATUS,
NEW_REFERENCES.DEFERRED_ADM_CAL_TYPE,
NEW_REFERENCES.DEFERRED_ADM_CI_SEQUENCE_NUM,
NEW_REFERENCES.DEFERRED_TRACKING_ID,
NEW_REFERENCES.ASS_RANK,
NEW_REFERENCES.SECONDARY_ASS_RANK,
NEW_REFERENCES.INTRNTNL_ACCEPTANCE_ADVICE_NUM,
NEW_REFERENCES.ASS_TRACKING_ID,
NEW_REFERENCES.FEE_CAT,
NEW_REFERENCES.HECS_PAYMENT_OPTION,
NEW_REFERENCES.EXPECTED_COMPLETION_YR,
NEW_REFERENCES.EXPECTED_COMPLETION_PERD,
NEW_REFERENCES.CORRESPONDENCE_CAT,
NEW_REFERENCES.ENROLMENT_CAT,
NEW_REFERENCES.FUNDING_SOURCE,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
NEW_REFERENCES.APPL_INST_STATUS, --arvsrini igsm
NEW_REFERENCES.DECISION_DATE , -- BEGIN APADEGAL TD001 IGSM
NEW_REFERENCES.DECISION_MAKE_ID ,
NEW_REFERENCES.DECISION_REASON_ID ,
NEW_REFERENCES.PENDING_REASON_ID ,
NEW_REFERENCES.WAITLIST_STATUS ,
NEW_REFERENCES.WAITLIST_RANK ,
NEW_REFERENCES.FUTURE_ACAD_CAL_TYPE ,
NEW_REFERENCES.FUTURE_ACAD_CI_SEQUENCE_NUM ,
NEW_REFERENCES.FUTURE_ADM_CAL_TYPE ,
NEW_REFERENCES.FUTURE_ADM_CI_SEQUENCE_NUM ,
NEW_REFERENCES.DEF_ACAD_CAL_TYPE ,
NEW_REFERENCES.DEF_ACAD_CI_SEQUENCE_NUM ,
NEW_REFERENCES.RECONSIDER_FLAG ,
NEW_REFERENCES.DECLINE_OFR_REASON -- end APADEGAL TD001 IGSM
);
p_action =>'INSERT',
x_rowid => X_ROWID
);
end INSERT_ROW;
cursor c1 is select
APPLICANT_ACPTNCE_CNDTN,
CNDTNL_OFFER_CNDTN,
HIST_END_DT,
HIST_WHO,
HIST_OFFER_ROUND_NUMBER,
ADM_CAL_TYPE,
ADM_CI_SEQUENCE_NUMBER,
COURSE_CD,
CRV_VERSION_NUMBER,
LOCATION_CD,
ATTENDANCE_MODE,
ATTENDANCE_TYPE,
UNIT_SET_CD,
US_VERSION_NUMBER,
PREFERENCE_NUMBER,
ADM_DOC_STATUS,
ADM_ENTRY_QUAL_STATUS,
LATE_ADM_FEE_STATUS,
ADM_OUTCOME_STATUS,
ADM_OTCM_STATUS_AUTH_PERSON_ID,
ADM_OUTCOME_STATUS_AUTH_DT,
ADM_OUTCOME_STATUS_REASON,
OFFER_DT,
OFFER_RESPONSE_DT,
PRPSD_COMMENCEMENT_DT,
ADM_CNDTNL_OFFER_STATUS,
CNDTNL_OFFER_SATISFIED_DT,
CNDTNL_OFFER_MUST_BE_STSFD_IND,
ADM_OFFER_RESP_STATUS,
ACTUAL_RESPONSE_DT,
ADM_OFFER_DFRMNT_STATUS,
DEFERRED_ADM_CAL_TYPE,
DEFERRED_ADM_CI_SEQUENCE_NUM,
DEFERRED_TRACKING_ID,
ASS_RANK,
SECONDARY_ASS_RANK,
INTRNTNL_ACCEPTANCE_ADVICE_NUM,
ASS_TRACKING_ID,
FEE_CAT,
HECS_PAYMENT_OPTION,
EXPECTED_COMPLETION_YR,
EXPECTED_COMPLETION_PERD,
CORRESPONDENCE_CAT,
ENROLMENT_CAT,
FUNDING_SOURCE,
APPL_INST_STATUS, --arvsrini igsm
DECISION_DATE , -- begin APADEGAL adtd001 igs.m
DECISION_MAKE_ID ,
DECISION_REASON_ID ,
PENDING_REASON_ID ,
WAITLIST_STATUS ,
WAITLIST_RANK ,
FUTURE_ACAD_CAL_TYPE ,
FUTURE_ACAD_CI_SEQUENCE_NUM ,
FUTURE_ADM_CAL_TYPE ,
FUTURE_ADM_CI_SEQUENCE_NUM ,
DEF_ACAD_CAL_TYPE ,
DEF_ACAD_CI_SEQUENCE_NUM ,
RECONSIDER_FLAG ,
DECLINE_OFR_REASON -- end APADEGAL adtd001 igs.m
from IGS_AD_PS_APLINSTHST_ALL
where ROWID = X_ROWID for update nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
procedure UPDATE_ROW (
X_ROWID in VARCHAR2,
X_PERSON_ID in NUMBER,
X_ADMISSION_APPL_NUMBER in NUMBER,
X_NOMINATED_COURSE_CD in VARCHAR2,
X_SEQUENCE_NUMBER in NUMBER,
X_HIST_START_DT in DATE,
X_APPLICANT_ACPTNCE_CNDTN in VARCHAR2,
X_CNDTNL_OFFER_CNDTN in VARCHAR2,
X_HIST_END_DT in DATE,
X_HIST_WHO in NUMBER,
X_HIST_OFFER_ROUND_NUMBER in NUMBER,
X_ADM_CAL_TYPE in VARCHAR2,
X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
X_COURSE_CD in VARCHAR2,
X_CRV_VERSION_NUMBER in NUMBER,
X_LOCATION_CD in VARCHAR2,
X_ATTENDANCE_MODE in VARCHAR2,
X_ATTENDANCE_TYPE in VARCHAR2,
X_UNIT_SET_CD in VARCHAR2,
X_US_VERSION_NUMBER in NUMBER,
X_PREFERENCE_NUMBER in NUMBER,
X_ADM_DOC_STATUS in VARCHAR2,
X_ADM_ENTRY_QUAL_STATUS in VARCHAR2,
X_LATE_ADM_FEE_STATUS in VARCHAR2,
X_ADM_OUTCOME_STATUS in VARCHAR2,
X_ADM_OTCM_STATUS_AUTH_PER_ID in NUMBER,
X_ADM_OUTCOME_STATUS_AUTH_DT in DATE,
X_ADM_OUTCOME_STATUS_REASON in VARCHAR2,
X_OFFER_DT in DATE,
X_OFFER_RESPONSE_DT in DATE,
X_PRPSD_COMMENCEMENT_DT in DATE,
X_ADM_CNDTNL_OFFER_STATUS in VARCHAR2,
X_CNDTNL_OFFER_SATISFIED_DT in DATE,
X_CNDTNL_OFR_MUST_BE_STSFD_IND in VARCHAR2,
X_ADM_OFFER_RESP_STATUS in VARCHAR2,
X_ACTUAL_RESPONSE_DT in DATE,
X_ADM_OFFER_DFRMNT_STATUS in VARCHAR2,
X_DEFERRED_ADM_CAL_TYPE in VARCHAR2,
X_DEFERRED_ADM_CI_SEQUENCE_NUM in NUMBER,
X_DEFERRED_TRACKING_ID in NUMBER,
X_ASS_RANK in NUMBER,
X_SECONDARY_ASS_RANK in NUMBER,
X_INTRNTNL_ACCEPT_ADVICE_NUM in NUMBER,
X_ASS_TRACKING_ID in NUMBER,
X_FEE_CAT in VARCHAR2,
X_HECS_PAYMENT_OPTION in VARCHAR2,
X_EXPECTED_COMPLETION_YR in NUMBER,
X_EXPECTED_COMPLETION_PERD in VARCHAR2,
X_CORRESPONDENCE_CAT in VARCHAR2,
X_ENROLMENT_CAT in VARCHAR2,
X_FUNDING_SOURCE in VARCHAR2,
X_MODE in VARCHAR2, --arvsrini igsm
X_APPL_INST_STATUS IN VARCHAR2,
X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
X_DECISION_REASON_ID NUMBER DEFAULT NULL,
X_PENDING_REASON_ID NUMBER DEFAULT NULL,
X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
) 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_course_cd => X_COURSE_CD,
x_crv_version_number => X_CRV_VERSION_NUMBER,
x_location_cd => X_LOCATION_CD,
x_attendance_mode=>X_ATTENDANCE_MODE,
x_attendance_type=>X_ATTENDANCE_TYPE,
x_unit_set_cd=>X_UNIT_SET_CD,
x_us_version_number =>X_US_VERSION_NUMBER,
x_preference_number =>X_PREFERENCE_NUMBER,
x_adm_doc_status =>X_ADM_DOC_STATUS,
x_adm_entry_qual_status =>X_ADM_ENTRY_QUAL_STATUS,
x_late_adm_fee_status =>X_LATE_ADM_FEE_STATUS,
x_adm_outcome_status =>X_ADM_OUTCOME_STATUS,
x_adm_otcm_status_auth_per_id =>X_ADM_OTCM_STATUS_AUTH_PER_ID,
x_adm_outcome_status_auth_dt =>X_ADM_OUTCOME_STATUS_AUTH_DT,
x_adm_outcome_status_reason =>X_ADM_OUTCOME_STATUS_REASON,
x_offer_dt =>X_OFFER_DT,
x_offer_response_dt =>X_OFFER_RESPONSE_DT,
x_prpsd_commencement_dt =>X_PRPSD_COMMENCEMENT_DT,
x_adm_cndtnl_offer_status =>X_ADM_CNDTNL_OFFER_STATUS,
x_cndtnl_offer_satisfied_dt =>X_CNDTNL_OFFER_SATISFIED_DT,
x_cndtnl_ofr_must_be_stsfd_ind => X_CNDTNL_OFR_MUST_BE_STSFD_IND,
x_adm_offer_resp_status => X_ADM_OFFER_RESP_STATUS,
x_actual_response_dt => X_ACTUAL_RESPONSE_DT,
x_adm_offer_dfrmnt_status =>X_ADM_OFFER_DFRMNT_STATUS,
x_deferred_adm_cal_type =>X_DEFERRED_ADM_CAL_TYPE,
x_deferred_adm_ci_sequence_num =>X_DEFERRED_ADM_CI_SEQUENCE_NUM,
x_deferred_tracking_id =>X_DEFERRED_TRACKING_ID,
x_ass_rank =>X_ASS_RANK,
x_secondary_ass_rank =>X_SECONDARY_ASS_RANK,
x_intrntnl_accept_advice_num =>X_INTRNTNL_ACCEPT_ADVICE_NUM,
x_ass_tracking_id =>X_ASS_TRACKING_ID,
x_fee_cat =>X_FEE_CAT,
x_hecs_payment_option =>X_HECS_PAYMENT_OPTION,
x_expected_completion_yr =>X_EXPECTED_COMPLETION_YR,
x_expected_completion_perd =>X_EXPECTED_COMPLETION_PERD,
x_correspondence_cat =>X_CORRESPONDENCE_CAT,
x_enrolment_cat =>X_ENROLMENT_CAT,
x_funding_source =>X_FUNDING_SOURCE,
x_cndtnl_offer_cndtn =>X_CNDTNL_OFFER_CNDTN,
x_applicant_acptnce_cndtn =>X_APPLICANT_ACPTNCE_CNDTN,
x_person_id =>X_PERSON_ID,
x_admission_appl_number =>X_ADMISSION_APPL_NUMBER,
x_nominated_course_cd =>X_NOMINATED_COURSE_CD,
x_sequence_number =>X_SEQUENCE_NUMBER,
x_hist_start_dt =>X_HIST_START_DT,
x_hist_end_dt =>X_HIST_END_DT,
x_hist_who =>X_HIST_WHO,
x_hist_offer_round_number=>X_HIST_OFFER_ROUND_NUMBER,
x_adm_cal_type =>X_ADM_CAL_TYPE,
x_adm_ci_sequence_number =>X_ADM_CI_SEQUENCE_NUMBER,
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_appl_inst_status => X_APPL_INST_STATUS, --arvsrini igsm
x_decision_date => x_decision_date , -- begin apadegal td001 igsm
x_decision_make_id => x_decision_make_id ,
x_decision_reason_id => x_decision_reason_id ,
x_pending_reason_id => x_pending_reason_id ,
x_waitlist_status => x_waitlist_status ,
x_waitlist_rank => x_waitlist_rank ,
x_future_acad_cal_type => x_future_acad_cal_type ,
x_future_acad_ci_sequence_num => x_future_acad_ci_sequence_num ,
x_future_adm_cal_type => x_future_adm_cal_type ,
x_future_adm_ci_sequence_num => x_future_adm_ci_sequence_num ,
x_def_acad_cal_type => x_def_acad_cal_type ,
x_def_acad_ci_sequence_num => x_def_acad_ci_sequence_num ,
x_reconsider_flag => x_reconsider_flag ,
x_decline_ofr_reason => x_decline_ofr_reason -- end apadegal td001 igsm
);
update IGS_AD_PS_APLINSTHST_ALL set
APPLICANT_ACPTNCE_CNDTN = NEW_REFERENCES.APPLICANT_ACPTNCE_CNDTN,
CNDTNL_OFFER_CNDTN = NEW_REFERENCES.CNDTNL_OFFER_CNDTN,
HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
HIST_WHO = NEW_REFERENCES.HIST_WHO,
HIST_OFFER_ROUND_NUMBER = NEW_REFERENCES.HIST_OFFER_ROUND_NUMBER,
ADM_CAL_TYPE = NEW_REFERENCES.ADM_CAL_TYPE,
ADM_CI_SEQUENCE_NUMBER = NEW_REFERENCES.ADM_CI_SEQUENCE_NUMBER,
COURSE_CD = NEW_REFERENCES.COURSE_CD,
CRV_VERSION_NUMBER = NEW_REFERENCES.CRV_VERSION_NUMBER,
LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
UNIT_SET_CD = NEW_REFERENCES.UNIT_SET_CD,
US_VERSION_NUMBER = NEW_REFERENCES.US_VERSION_NUMBER,
PREFERENCE_NUMBER = NEW_REFERENCES.PREFERENCE_NUMBER,
ADM_DOC_STATUS = NEW_REFERENCES.ADM_DOC_STATUS,
ADM_ENTRY_QUAL_STATUS = NEW_REFERENCES.ADM_ENTRY_QUAL_STATUS,
LATE_ADM_FEE_STATUS = NEW_REFERENCES.LATE_ADM_FEE_STATUS,
ADM_OUTCOME_STATUS = NEW_REFERENCES.ADM_OUTCOME_STATUS,
ADM_OTCM_STATUS_AUTH_PERSON_ID = NEW_REFERENCES.ADM_OTCM_STATUS_AUTH_PERSON_ID,
ADM_OUTCOME_STATUS_AUTH_DT = NEW_REFERENCES.ADM_OUTCOME_STATUS_AUTH_DT,
ADM_OUTCOME_STATUS_REASON = NEW_REFERENCES.ADM_OUTCOME_STATUS_REASON,
OFFER_DT = NEW_REFERENCES.OFFER_DT,
OFFER_RESPONSE_DT = NEW_REFERENCES.OFFER_RESPONSE_DT,
PRPSD_COMMENCEMENT_DT = NEW_REFERENCES.PRPSD_COMMENCEMENT_DT,
ADM_CNDTNL_OFFER_STATUS = NEW_REFERENCES.ADM_CNDTNL_OFFER_STATUS,
CNDTNL_OFFER_SATISFIED_DT = NEW_REFERENCES.CNDTNL_OFFER_SATISFIED_DT,
CNDTNL_OFFER_MUST_BE_STSFD_IND = NEW_REFERENCES.CNDTNL_OFFER_MUST_BE_STSFD_IND,
ADM_OFFER_RESP_STATUS = NEW_REFERENCES.ADM_OFFER_RESP_STATUS,
ACTUAL_RESPONSE_DT = NEW_REFERENCES.ACTUAL_RESPONSE_DT,
ADM_OFFER_DFRMNT_STATUS = NEW_REFERENCES.ADM_OFFER_DFRMNT_STATUS,
DEFERRED_ADM_CAL_TYPE = NEW_REFERENCES.DEFERRED_ADM_CAL_TYPE,
DEFERRED_ADM_CI_SEQUENCE_NUM = NEW_REFERENCES.DEFERRED_ADM_CI_SEQUENCE_NUM,
DEFERRED_TRACKING_ID = NEW_REFERENCES.DEFERRED_TRACKING_ID,
ASS_RANK = NEW_REFERENCES.ASS_RANK,
SECONDARY_ASS_RANK = NEW_REFERENCES.SECONDARY_ASS_RANK,
INTRNTNL_ACCEPTANCE_ADVICE_NUM = NEW_REFERENCES.INTRNTNL_ACCEPTANCE_ADVICE_NUM,
ASS_TRACKING_ID = NEW_REFERENCES.ASS_TRACKING_ID,
FEE_CAT = NEW_REFERENCES.FEE_CAT,
HECS_PAYMENT_OPTION = NEW_REFERENCES.HECS_PAYMENT_OPTION,
EXPECTED_COMPLETION_YR = NEW_REFERENCES.EXPECTED_COMPLETION_YR,
EXPECTED_COMPLETION_PERD = NEW_REFERENCES.EXPECTED_COMPLETION_PERD,
CORRESPONDENCE_CAT = NEW_REFERENCES.CORRESPONDENCE_CAT,
ENROLMENT_CAT = NEW_REFERENCES.ENROLMENT_CAT,
FUNDING_SOURCE = NEW_REFERENCES.FUNDING_SOURCE,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
APPL_INST_STATUS =X_APPL_INST_STATUS, --arvsrini igsm
decision_date = new_references.decision_date , -- begin apadegal td001 igsm
decision_make_id = new_references.decision_make_id ,
decision_reason_id = new_references.decision_reason_id ,
pending_reason_id = new_references.pending_reason_id ,
waitlist_status = new_references.waitlist_status ,
waitlist_rank = new_references.waitlist_rank ,
future_acad_cal_type = new_references.future_acad_cal_type ,
future_acad_ci_sequence_num = new_references.future_acad_ci_sequence_num ,
future_adm_cal_type = new_references.future_adm_cal_type ,
future_adm_ci_sequence_num = new_references.future_adm_ci_sequence_num ,
def_acad_cal_type = new_references.def_acad_cal_type ,
def_acad_ci_sequence_num = new_references.def_acad_ci_sequence_num ,
reconsider_flag = new_references.reconsider_flag ,
decline_ofr_reason = new_references.decline_ofr_reason -- end apadegal td001 igsm
where ROWID = X_ROWID
;
p_action =>'UPDATE',
x_rowid => X_ROWID
);
end UPDATE_ROW;
cursor c1 is select rowid from IGS_AD_PS_APLINSTHST_ALL
where PERSON_ID = X_PERSON_ID
and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
and HIST_START_DT = X_HIST_START_DT
;
INSERT_ROW (
X_ROWID,
X_ORG_ID,
X_PERSON_ID,
X_ADMISSION_APPL_NUMBER,
X_NOMINATED_COURSE_CD,
X_SEQUENCE_NUMBER,
X_HIST_START_DT,
X_APPLICANT_ACPTNCE_CNDTN,
X_CNDTNL_OFFER_CNDTN,
X_HIST_END_DT,
X_HIST_WHO,
X_HIST_OFFER_ROUND_NUMBER,
X_ADM_CAL_TYPE,
X_ADM_CI_SEQUENCE_NUMBER,
X_COURSE_CD,
X_CRV_VERSION_NUMBER,
X_LOCATION_CD,
X_ATTENDANCE_MODE,
X_ATTENDANCE_TYPE,
X_UNIT_SET_CD,
X_US_VERSION_NUMBER,
X_PREFERENCE_NUMBER,
X_ADM_DOC_STATUS,
X_ADM_ENTRY_QUAL_STATUS,
X_LATE_ADM_FEE_STATUS,
X_ADM_OUTCOME_STATUS,
X_ADM_OTCM_STATUS_AUTH_PER_ID,
X_ADM_OUTCOME_STATUS_AUTH_DT,
X_ADM_OUTCOME_STATUS_REASON,
X_OFFER_DT,
X_OFFER_RESPONSE_DT,
X_PRPSD_COMMENCEMENT_DT,
X_ADM_CNDTNL_OFFER_STATUS,
X_CNDTNL_OFFER_SATISFIED_DT,
X_CNDTNL_OFR_MUST_BE_STSFD_IND,
X_ADM_OFFER_RESP_STATUS,
X_ACTUAL_RESPONSE_DT,
X_ADM_OFFER_DFRMNT_STATUS,
X_DEFERRED_ADM_CAL_TYPE,
X_DEFERRED_ADM_CI_SEQUENCE_NUM,
X_DEFERRED_TRACKING_ID,
X_ASS_RANK,
X_SECONDARY_ASS_RANK,
X_INTRNTNL_ACCEPT_ADVICE_NUM,
X_ASS_TRACKING_ID,
X_FEE_CAT,
X_HECS_PAYMENT_OPTION,
X_EXPECTED_COMPLETION_YR,
X_EXPECTED_COMPLETION_PERD,
X_CORRESPONDENCE_CAT,
X_ENROLMENT_CAT,
X_FUNDING_SOURCE,
X_MODE,
X_APPL_INST_STATUS, --arvsrini igsm
X_DECISION_DATE , -- begin APADEGAL adtd001 igs.m
X_DECISION_MAKE_ID ,
X_DECISION_REASON_ID ,
X_PENDING_REASON_ID ,
X_WAITLIST_STATUS ,
X_WAITLIST_RANK ,
X_FUTURE_ACAD_CAL_TYPE ,
X_FUTURE_ACAD_CI_SEQUENCE_NUM ,
X_FUTURE_ADM_CAL_TYPE ,
X_FUTURE_ADM_CI_SEQUENCE_NUM ,
X_DEF_ACAD_CAL_TYPE ,
X_DEF_ACAD_CI_SEQUENCE_NUM ,
X_RECONSIDER_FLAG ,
X_DECLINE_OFR_REASON -- end APADEGAL adtd001 igs.m
);
UPDATE_ROW (
X_ROWID,
X_PERSON_ID,
X_ADMISSION_APPL_NUMBER,
X_NOMINATED_COURSE_CD,
X_SEQUENCE_NUMBER,
X_HIST_START_DT,
X_APPLICANT_ACPTNCE_CNDTN,
X_CNDTNL_OFFER_CNDTN,
X_HIST_END_DT,
X_HIST_WHO,
X_HIST_OFFER_ROUND_NUMBER,
X_ADM_CAL_TYPE,
X_ADM_CI_SEQUENCE_NUMBER,
X_COURSE_CD,
X_CRV_VERSION_NUMBER,
X_LOCATION_CD,
X_ATTENDANCE_MODE,
X_ATTENDANCE_TYPE,
X_UNIT_SET_CD,
X_US_VERSION_NUMBER,
X_PREFERENCE_NUMBER,
X_ADM_DOC_STATUS,
X_ADM_ENTRY_QUAL_STATUS,
X_LATE_ADM_FEE_STATUS,
X_ADM_OUTCOME_STATUS,
X_ADM_OTCM_STATUS_AUTH_PER_ID,
X_ADM_OUTCOME_STATUS_AUTH_DT,
X_ADM_OUTCOME_STATUS_REASON,
X_OFFER_DT,
X_OFFER_RESPONSE_DT,
X_PRPSD_COMMENCEMENT_DT,
X_ADM_CNDTNL_OFFER_STATUS,
X_CNDTNL_OFFER_SATISFIED_DT,
X_CNDTNL_OFR_MUST_BE_STSFD_IND,
X_ADM_OFFER_RESP_STATUS,
X_ACTUAL_RESPONSE_DT,
X_ADM_OFFER_DFRMNT_STATUS,
X_DEFERRED_ADM_CAL_TYPE,
X_DEFERRED_ADM_CI_SEQUENCE_NUM,
X_DEFERRED_TRACKING_ID,
X_ASS_RANK,
X_SECONDARY_ASS_RANK,
X_INTRNTNL_ACCEPT_ADVICE_NUM,
X_ASS_TRACKING_ID,
X_FEE_CAT,
X_HECS_PAYMENT_OPTION,
X_EXPECTED_COMPLETION_YR,
X_EXPECTED_COMPLETION_PERD,
X_CORRESPONDENCE_CAT,
X_ENROLMENT_CAT,
X_FUNDING_SOURCE,
X_MODE,
X_APPL_INST_STATUS,
X_DECISION_DATE , -- begin APADEGAL adtd001 igs.m
X_DECISION_MAKE_ID ,
X_DECISION_REASON_ID ,
X_PENDING_REASON_ID ,
X_WAITLIST_STATUS ,
X_WAITLIST_RANK ,
X_FUTURE_ACAD_CAL_TYPE ,
X_FUTURE_ACAD_CI_SEQUENCE_NUM ,
X_FUTURE_ADM_CAL_TYPE ,
X_FUTURE_ADM_CI_SEQUENCE_NUM ,
X_DEF_ACAD_CAL_TYPE ,
X_DEF_ACAD_CI_SEQUENCE_NUM ,
X_RECONSIDER_FLAG ,
X_DECLINE_OFR_REASON -- end APADEGAL adtd001 igs.m
);
procedure DELETE_ROW (
X_ROWID in VARCHAR2
) as
begin
Before_DML(
p_action =>'DELETE',
x_rowid => X_ROWID
);
delete from IGS_AD_PS_APLINSTHST_ALL
where ROWID = X_ROWID;
p_action =>'DELETE',
x_rowid => X_ROWID
);
end DELETE_ROW;