eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_AD_OFFRESP_INT

Line 30: PROCEDURE logdetail(l_id IN igs_ad_offresp_int.offresp_int_id%TYPE,

26: admission_appl_number = cp_admission_appl_number AND
27: nominated_course_cd = cp_nominated_course_cd AND
28: sequence_number = cp_sequence_number;
29:
30: PROCEDURE logdetail(l_id IN igs_ad_offresp_int.offresp_int_id%TYPE,
31: l_err_code IN igs_ad_offresp_err.error_code%TYPE,
32: l_err_msg IN igs_ad_offresp_err.error_text%TYPE,
33: l_debug_msg IN VARCHAR2,
34: l_first_flag IN VARCHAR2) IS

Line 123: --Procedure to Update igs_ad_offresp_int with the Error status and insert the corresponding Error record into igs_ad_offresp_err.

119: END IF;
120: FND_FILE.PUT_LINE(FND_FILE.LOG,'logdetail: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);
121: END logdetail;
122:
123: --Procedure to Update igs_ad_offresp_int with the Error status and insert the corresponding Error record into igs_ad_offresp_err.
124: PROCEDURE insert_int_error( p_offresp_int_id IN igs_ad_offresp_int.offresp_int_id%TYPE,
125: p_error_code IN igs_ad_offresp_err.error_code%TYPE,
126: p_message_name IN VARCHAR2
127: ) IS

Line 124: PROCEDURE insert_int_error( p_offresp_int_id IN igs_ad_offresp_int.offresp_int_id%TYPE,

120: FND_FILE.PUT_LINE(FND_FILE.LOG,'logdetail: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);
121: END logdetail;
122:
123: --Procedure to Update igs_ad_offresp_int with the Error status and insert the corresponding Error record into igs_ad_offresp_err.
124: PROCEDURE insert_int_error( p_offresp_int_id IN igs_ad_offresp_int.offresp_int_id%TYPE,
125: p_error_code IN igs_ad_offresp_err.error_code%TYPE,
126: p_message_name IN VARCHAR2
127: ) IS
128: ---------------------------------------------------------------------------------------------------------------------------------------

Line 184: p_offresp_int_id IN igs_ad_offresp_int.OFFRESP_INT_ID%TYPE,

180: END insert_int_error;
181:
182:
183: PROCEDURE validate_off_resp_dtls(
184: p_offresp_int_id IN igs_ad_offresp_int.OFFRESP_INT_ID%TYPE,
185: p_batch_id IN igs_ad_offresp_int.BATCH_ID%TYPE,
186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,

Line 185: p_batch_id IN igs_ad_offresp_int.BATCH_ID%TYPE,

181:
182:
183: PROCEDURE validate_off_resp_dtls(
184: p_offresp_int_id IN igs_ad_offresp_int.OFFRESP_INT_ID%TYPE,
185: p_batch_id IN igs_ad_offresp_int.BATCH_ID%TYPE,
186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,

Line 186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,

182:
183: PROCEDURE validate_off_resp_dtls(
184: p_offresp_int_id IN igs_ad_offresp_int.OFFRESP_INT_ID%TYPE,
185: p_batch_id IN igs_ad_offresp_int.BATCH_ID%TYPE,
186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,

Line 187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,

183: PROCEDURE validate_off_resp_dtls(
184: p_offresp_int_id IN igs_ad_offresp_int.OFFRESP_INT_ID%TYPE,
185: p_batch_id IN igs_ad_offresp_int.BATCH_ID%TYPE,
186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm

Line 188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,

184: p_offresp_int_id IN igs_ad_offresp_int.OFFRESP_INT_ID%TYPE,
185: p_batch_id IN igs_ad_offresp_int.BATCH_ID%TYPE,
186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,

Line 189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,

185: p_batch_id IN igs_ad_offresp_int.BATCH_ID%TYPE,
186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,

Line 190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,

186: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,

Line 191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm

187: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,

Line 192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,

188: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,

Line 193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,

189: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,

Line 194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,

190: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,

Line 195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,

191: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE, --arvsrini igsm
192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
199: p_status IN igs_ad_offresp_int.status%TYPE ,

Line 196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,

192: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
199: p_status IN igs_ad_offresp_int.status%TYPE ,
200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,

Line 197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,

193: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
199: p_status IN igs_ad_offresp_int.status%TYPE ,
200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,
201: p_adm_offer_defr_status OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,

Line 198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,

194: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
199: p_status IN igs_ad_offresp_int.status%TYPE ,
200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,
201: p_adm_offer_defr_status OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
202: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,

Line 199: p_status IN igs_ad_offresp_int.status%TYPE ,

195: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
199: p_status IN igs_ad_offresp_int.status%TYPE ,
200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,
201: p_adm_offer_defr_status OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
202: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
203: appl_rec IN igs_ad_appl_all%ROWTYPE,

Line 200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,

196: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
197: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
199: p_status IN igs_ad_offresp_int.status%TYPE ,
200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,
201: p_adm_offer_defr_status OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
202: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
203: appl_rec IN igs_ad_appl_all%ROWTYPE,
204: acaiv_rec IN cur_ad_ps_appl_inst%ROWTYPE,

Line 202: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,

198: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
199: p_status IN igs_ad_offresp_int.status%TYPE ,
200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,
201: p_adm_offer_defr_status OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
202: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
203: appl_rec IN igs_ad_appl_all%ROWTYPE,
204: acaiv_rec IN cur_ad_ps_appl_inst%ROWTYPE,
205: p_yes_no IN VARCHAR2,
206: p_validation_success OUT NOCOPY VARCHAR2) IS

Line 875: -- 5. If the record is succesfully imported then Delete the interface record from IGS_AD_OFFRESP_INT.

871: -- 3. If any of the validations fail then insert Error record into the interface error table IGS_AD_OFFRESP_ERR.
872: -- 3. If validations Successful then Update the OSS table IGS_AD_PS_APPL_INST_ALL with Interface Offer Response details.
873: -- 4. If the Offer Response status of Application Instance is updated to 'ACCEPTED' then perform the Pre enrollment by calling
874: -- the corresponding job.
875: -- 5. If the record is succesfully imported then Delete the interface record from IGS_AD_OFFRESP_INT.
876: -- 6. If All the interface records for the given batch_id are succesfully imported then delete the Batch record from IGS_AD_OFFRESP_BATCH.
877: -- 7. Once all the pending records are processed then invoke the Import Offer Response Error Rerport (IGSADS21).
878: -- Know limitations, enhancements or remarks
879: -- Change History

Line 886: TYPE offresp_int_idType IS TABLE OF igs_ad_offresp_int.offresp_int_id%TYPE;

882: -- rboddu 11/17/2003 Added p_prpsd_commencement_date declartions and import of it.
883: ---------------------------------------------------------------------------------------------------------------------------------------
884:
885: /* Variable Declaration for BULK COLLECT feature (PL/SQL tables which hold the data for each column of interface table)*/
886: TYPE offresp_int_idType IS TABLE OF igs_ad_offresp_int.offresp_int_id%TYPE;
887: TYPE batch_idType IS TABLE OF igs_ad_offresp_int.batch_id%TYPE;
888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;
889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;

Line 887: TYPE batch_idType IS TABLE OF igs_ad_offresp_int.batch_id%TYPE;

883: ---------------------------------------------------------------------------------------------------------------------------------------
884:
885: /* Variable Declaration for BULK COLLECT feature (PL/SQL tables which hold the data for each column of interface table)*/
886: TYPE offresp_int_idType IS TABLE OF igs_ad_offresp_int.offresp_int_id%TYPE;
887: TYPE batch_idType IS TABLE OF igs_ad_offresp_int.batch_id%TYPE;
888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;
889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;

Line 888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;

884:
885: /* Variable Declaration for BULK COLLECT feature (PL/SQL tables which hold the data for each column of interface table)*/
886: TYPE offresp_int_idType IS TABLE OF igs_ad_offresp_int.offresp_int_id%TYPE;
887: TYPE batch_idType IS TABLE OF igs_ad_offresp_int.batch_id%TYPE;
888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;
889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;

Line 889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;

885: /* Variable Declaration for BULK COLLECT feature (PL/SQL tables which hold the data for each column of interface table)*/
886: TYPE offresp_int_idType IS TABLE OF igs_ad_offresp_int.offresp_int_id%TYPE;
887: TYPE batch_idType IS TABLE OF igs_ad_offresp_int.batch_id%TYPE;
888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;
889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;

Line 890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;

886: TYPE offresp_int_idType IS TABLE OF igs_ad_offresp_int.offresp_int_id%TYPE;
887: TYPE batch_idType IS TABLE OF igs_ad_offresp_int.batch_id%TYPE;
888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;
889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;

Line 891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;

887: TYPE batch_idType IS TABLE OF igs_ad_offresp_int.batch_id%TYPE;
888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;
889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;

Line 892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;

888: TYPE person_idType IS TABLE OF igs_ad_offresp_int.person_id%TYPE;
889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;

Line 893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;

889: TYPE admission_appl_numberType IS TABLE OF igs_ad_offresp_int.admission_appl_number%TYPE;
890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;

Line 894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;

890: TYPE nominated_course_cdType IS TABLE OF igs_ad_offresp_int.nominated_course_cd%TYPE;
891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;

Line 895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;

891: TYPE sequence_numberType IS TABLE OF igs_ad_offresp_int.sequence_number%TYPE;
892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;

Line 896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;

892: TYPE adm_offer_resp_statusType IS TABLE OF igs_ad_offresp_int.adm_offer_resp_status%TYPE;
893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;
900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;

Line 897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;

893: TYPE decline_ofr_reasonType IS TABLE OF igs_ad_offresp_int.decline_ofr_reason%TYPE;
894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;
900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;
901: TYPE statusType IS TABLE OF igs_ad_offresp_int.status%TYPE;

Line 898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;

894: TYPE actual_offer_response_dtType IS TABLE OF igs_ad_offresp_int.actual_offer_response_dt%TYPE;
895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;
900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;
901: TYPE statusType IS TABLE OF igs_ad_offresp_int.status%TYPE;
902: TYPE prpsd_commencement_dateType IS TABLE OF igs_ad_offresp_int.prpsd_commencement_date%TYPE;

Line 899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;

895: TYPE attent_other_inst_cdType IS TABLE OF igs_ad_offresp_int.attent_other_inst_cd%TYPE;
896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;
900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;
901: TYPE statusType IS TABLE OF igs_ad_offresp_int.status%TYPE;
902: TYPE prpsd_commencement_dateType IS TABLE OF igs_ad_offresp_int.prpsd_commencement_date%TYPE;
903:

Line 900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;

896: TYPE applicant_acptnce_cndtnType IS TABLE OF igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE;
897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;
900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;
901: TYPE statusType IS TABLE OF igs_ad_offresp_int.status%TYPE;
902: TYPE prpsd_commencement_dateType IS TABLE OF igs_ad_offresp_int.prpsd_commencement_date%TYPE;
903:
904: t_offresp_int_id offresp_int_idType;

Line 901: TYPE statusType IS TABLE OF igs_ad_offresp_int.status%TYPE;

897: TYPE def_acad_cal_typeType IS TABLE OF igs_ad_offresp_int.def_acad_cal_type%TYPE;
898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;
900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;
901: TYPE statusType IS TABLE OF igs_ad_offresp_int.status%TYPE;
902: TYPE prpsd_commencement_dateType IS TABLE OF igs_ad_offresp_int.prpsd_commencement_date%TYPE;
903:
904: t_offresp_int_id offresp_int_idType;
905: t_batch_id batch_idType;

Line 902: TYPE prpsd_commencement_dateType IS TABLE OF igs_ad_offresp_int.prpsd_commencement_date%TYPE;

898: TYPE def_acad_ci_seq_numType IS TABLE OF igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE;
899: TYPE def_adm_cal_typeType IS TABLE OF igs_ad_offresp_int.def_adm_cal_type%TYPE;
900: TYPE def_adm_ci_sequence_numberType IS TABLE OF igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE;
901: TYPE statusType IS TABLE OF igs_ad_offresp_int.status%TYPE;
902: TYPE prpsd_commencement_dateType IS TABLE OF igs_ad_offresp_int.prpsd_commencement_date%TYPE;
903:
904: t_offresp_int_id offresp_int_idType;
905: t_batch_id batch_idType;
906: t_person_id person_idType;

Line 943: igs_ad_offresp_int ofresp

939: ofresp.def_adm_ci_sequence_number,
940: ofresp.status,
941: ofresp.prpsd_commencement_date
942: FROM
943: igs_ad_offresp_int ofresp
944: WHERE
945: ofresp.batch_id = p_batch_id AND
946: ofresp.status = '2';
947:

Line 949: CURSOR int_record_status(p_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE) IS

945: ofresp.batch_id = p_batch_id AND
946: ofresp.status = '2';
947:
948: -- Cursor to get the Record status, which indicates whether the Record is succesfully Imported or not.
949: CURSOR int_record_status(p_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE) IS
950: SELECT ofresp.status
951: FROM
952: igs_ad_offresp_int ofresp
953: WHERE

Line 952: igs_ad_offresp_int ofresp

948: -- Cursor to get the Record status, which indicates whether the Record is succesfully Imported or not.
949: CURSOR int_record_status(p_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE) IS
950: SELECT ofresp.status
951: FROM
952: igs_ad_offresp_int ofresp
953: WHERE
954: ofresp.offresp_int_id = p_offresp_id;
955:
956: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,

Line 963: --Cursor to check if there is any Pending or Error interface Offer Response record is present in IGS_AD_OFFRESP_INT;

959: FROM igs_ad_appl_all appl
960: WHERE person_id = cp_person_id AND
961: admission_appl_number = cp_admission_appl_number;
962:
963: --Cursor to check if there is any Pending or Error interface Offer Response record is present in IGS_AD_OFFRESP_INT;
964: CURSOR c_processed_recs(p_batch_id igs_ad_offresp_batch.batch_id%TYPE) IS
965: SELECT offresp_int_id
966: FROM igs_ad_offresp_int
967: WHERE batch_id = p_batch_id AND

Line 966: FROM igs_ad_offresp_int

962:
963: --Cursor to check if there is any Pending or Error interface Offer Response record is present in IGS_AD_OFFRESP_INT;
964: CURSOR c_processed_recs(p_batch_id igs_ad_offresp_batch.batch_id%TYPE) IS
965: SELECT offresp_int_id
966: FROM igs_ad_offresp_int
967: WHERE batch_id = p_batch_id AND
968: status IN ('2','3');
969:
970: CURSOR get_conc_desctiption(l_name fnd_concurrent_programs_vl.concurrent_program_name%TYPE) IS

Line 981: l_processed_Rec_Stat igs_ad_offresp_int.status%TYPE;

977: v_warn_level VARCHAR2(10);
978: l_request_id NUMBER;
979: l_tot_rec_processed PLS_INTEGER;
980:
981: l_processed_Rec_Stat igs_ad_offresp_int.status%TYPE;
982: l_adm_offer_defr_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE;
983: l_validation_success VARCHAR2(1);
984: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;
985: l_appl_rec igs_ad_appl_all%ROWTYPE;

Line 986: l_calc_actual_ofr_resp_dt igs_ad_offresp_int.actual_offer_response_dt%TYPE;

982: l_adm_offer_defr_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE;
983: l_validation_success VARCHAR2(1);
984: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;
985: l_appl_rec igs_ad_appl_all%ROWTYPE;
986: l_calc_actual_ofr_resp_dt igs_ad_offresp_int.actual_offer_response_dt%TYPE;
987: l_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE;
988: l_conc_description fnd_concurrent_programs_vl.description%TYPE;
989: l_space_string VARCHAR2(300);
990:

Line 987: l_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE;

983: l_validation_success VARCHAR2(1);
984: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;
985: l_appl_rec igs_ad_appl_all%ROWTYPE;
986: l_calc_actual_ofr_resp_dt igs_ad_offresp_int.actual_offer_response_dt%TYPE;
987: l_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE;
988: l_conc_description fnd_concurrent_programs_vl.description%TYPE;
989: l_space_string VARCHAR2(300);
990:
991:

Line 1025: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_INT', cascade => TRUE);

1021:
1022: BEGIN
1023: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
1024: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_BATCH', cascade => TRUE);
1025: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_INT', cascade => TRUE);
1026: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_ERR', cascade => TRUE);
1027: EXCEPTION WHEN OTHERS THEN
1028: NULL;
1029: END;

Line 1033: DELETE igs_ad_offresp_err WHERE offresp_int_id IN (SELECT offresp_int_id FROM igs_ad_offresp_int WHERE batch_id = p_batch_id);

1029: END;
1030:
1031:
1032: -- Delete all the records from the error table for the currently processed Batch ID
1033: DELETE igs_ad_offresp_err WHERE offresp_int_id IN (SELECT offresp_int_id FROM igs_ad_offresp_int WHERE batch_id = p_batch_id);
1034:
1035: --Fetch All the Pending (Status = '2) Offer Response Interface records from IGS_AD_OFFRESP_INT (for the given batch id.)
1036: OPEN int_off_resp_cur;
1037: FETCH int_off_resp_cur BULK COLLECT INTO

Line 1035: --Fetch All the Pending (Status = '2) Offer Response Interface records from IGS_AD_OFFRESP_INT (for the given batch id.)

1031:
1032: -- Delete all the records from the error table for the currently processed Batch ID
1033: DELETE igs_ad_offresp_err WHERE offresp_int_id IN (SELECT offresp_int_id FROM igs_ad_offresp_int WHERE batch_id = p_batch_id);
1034:
1035: --Fetch All the Pending (Status = '2) Offer Response Interface records from IGS_AD_OFFRESP_INT (for the given batch id.)
1036: OPEN int_off_resp_cur;
1037: FETCH int_off_resp_cur BULK COLLECT INTO
1038: t_offresp_int_id,
1039: t_batch_id,

Line 1123: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);

1119:
1120:
1121: lv_un_conf_prg_atmpt := TRUE;
1122: IF l_validation_success = 'N' THEN
1123: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);
1124: ELSE
1125:
1126:
1127:

Line 1153: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);

1149: EXCEPTION --Update operation failed
1150: WHEN OTHERS THEN
1151: ROLLBACK TO current_rec_savepoint;
1152: l_completed_flag := 'N';
1153: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);
1154:
1155: x_dummy := FND_MESSAGE.GET;
1156: insert_int_error(t_offresp_int_id (t_idx),NULL,x_dummy);
1157:

Line 1305: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);

1301: EXCEPTION --Update operation failed
1302: WHEN OTHERS THEN
1303: ROLLBACK TO current_rec_savepoint;
1304: l_completed_flag := 'N';
1305: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);
1306: insert_int_error(t_offresp_int_id (t_idx),'E621',NULL);
1307:
1308: logdetail(t_offresp_int_id(t_idx), 'E621', NULL,'imp_off_resp: igs_ad_ps_appl_inst_pkg.update_row',NULL);
1309:

Line 1342: -- Update the Status of interface record and insert the error Code / Message text into Error table igs_ad_offresp_int.

1338: 'Y', -- Confirm course indicator.
1339: 'Y', -- Perform eligibility check indicator.
1340: v_message_name) = FALSE THEN
1341: ROLLBACK TO current_rec_savepoint;
1342: -- Update the Status of interface record and insert the error Code / Message text into Error table igs_ad_offresp_int.
1343: l_completed_flag := 'N';
1344: l_pre_enrol_success := 'N';
1345: insert_int_error(t_offresp_int_id (t_idx),NULL,v_message_name);
1346: logdetail(t_offresp_int_id(t_idx), NULL, v_message_name,'imp_off_resp: IF igs_ad_upd_initialise.perform_pre_enrol',NULL);

Line 1347: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);

1343: l_completed_flag := 'N';
1344: l_pre_enrol_success := 'N';
1345: insert_int_error(t_offresp_int_id (t_idx),NULL,v_message_name);
1346: logdetail(t_offresp_int_id(t_idx), NULL, v_message_name,'imp_off_resp: IF igs_ad_upd_initialise.perform_pre_enrol',NULL);
1347: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);
1348: END IF; -- Of call to Pre Enrollment job
1349: END IF;
1350:
1351:

Line 1356: DELETE igs_ad_offresp_int WHERE offresp_int_id = t_offresp_int_id (t_idx);

1352: -- Pre enrollment job is successful so put the Successful record information in the Concurrent LOG.
1353: IF NVL(l_pre_enrol_success,'Y') = 'Y' THEN
1354: logdetail(t_offresp_int_id(t_idx), NULL, NULL,NULL,NULL);
1355: -- Delete the succesfully imported Interface record from the corresponding interface table.
1356: DELETE igs_ad_offresp_int WHERE offresp_int_id = t_offresp_int_id (t_idx);
1357: END IF;
1358:
1359: END IF; --End of l_completed_flag = 'Y'
1360:

Line 1364: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);

1360:
1361:
1362: ELSE --Application instance is not found in the OSS System table.
1363: insert_int_error(t_offresp_int_id (t_idx),'E605',NULL);
1364: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);
1365: logdetail(t_offresp_int_id (t_idx), 'E605', NULL, 'imp_off_resp: IF acaiv_rec.person_id' ,NULL);
1366: END IF;
1367: CLOSE cur_ad_ps_appl_inst;
1368: