[Home] [Help]
94: CURSOR def_fields_cur
95: IS
96: SELECT decision_make_id, decision_date, decision_reason_id,
97: pending_reason_id, offer_dt, offer_response_dt
98: FROM igs_ad_batc_def_det
99: WHERE
100: batch_id = p_batch_id AND
101: acad_cal_type = p_acad_cal_type AND
102: acad_ci_sequence_number = p_acad_ci_sequence_number AND
512:
513: END prc_adm_outcome_status;
514:
515: PROCEDURE import_adm_decision (
516: p_batch_id IN igs_ad_batc_def_det_all.batch_id%TYPE,
517: p_ucas_transaction IN VARCHAR2,
518: p_message_name OUT NOCOPY VARCHAR2,
519: p_msg_token_rec_prc_cnt OUT NOCOPY NUMBER
520: ) IS
524: l_return_status VARCHAR2(30);
525:
526: CURSOR c_batc_def_det IS
527: SELECT *
528: FROM igs_ad_batc_def_det_all abdd
529: WHERE batch_id = p_batch_id AND
530: ( (abdd.ACAD_CAL_TYPE IS NULL AND
531: abdd.ACAD_CI_SEQUENCE_NUMBER IS NULL AND
532: abdd.ADM_CAL_TYPE IS NULL AND
542: abdd.S_ADMISSION_PROCESS_TYPE IS NOT NULL) ) ;
543:
544: CURSOR c_admde_int IS
545: SELECT mdi.*
546: FROM igs_ad_admde_int_all mdi, igs_ad_batc_def_det_all abdd
547: WHERE mdi.batch_id = p_batch_id
548: AND mdi.batch_id = abdd.batch_id
549: AND EXISTS ( SELECT 1
550: FROM igs_ad_ps_appl_inst aplinst, igs_ad_appl appl
591: l_schema VARCHAR2(30);
592: l_gather_return BOOLEAN;
593: BEGIN
594: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
595: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_BATC_DEF_DET', cascade => TRUE);
596: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_ADMDE_INT', cascade => TRUE);
597: EXCEPTION
598: WHEN OTHERS THEN
599: NULL;
679: END import_adm_decision;
680:
681:
682: PROCEDURE discard_adm_decision (
683: p_batch_id IN igs_ad_batc_def_det_all.batch_id%TYPE,
684: p_message_name OUT NOCOPY VARCHAR2,
685: p_msg_token_rec_prc_cnt OUT NOCOPY NUMBER
686: ) IS
687: