APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_AD_BATC_DEF_DET_ALL

Line 516: p_batch_id IN igs_ad_batc_def_det_all.batch_id%TYPE,

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

Line 528: FROM igs_ad_batc_def_det_all abdd

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

Line 546: FROM igs_ad_admde_int_all mdi, igs_ad_batc_def_det_all abdd

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

Line 683: p_batch_id IN igs_ad_batc_def_det_all.batch_id%TYPE,

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: