APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_AD_APPL_ALL

Line 378: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,

374: SELECT NVL(MAX(admission_appl_number),0) + 1
375: FROM igs_ad_appl
376: WHERE person_id = p_person_id;
377:
378: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
380: )
381: IS
382: SELECT admission_application_type

Line 379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE

375: FROM igs_ad_appl
376: WHERE person_id = p_person_id;
377:
378: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
380: )
381: IS
382: SELECT admission_application_type
383: FROM igs_ad_ss_appl_typ

Line 389: l_application_type igs_ad_appl_all.application_type%TYPE;

385: AND S_admission_process_type = cp_s_adm_prc_typ
386: AND System_default = 'Y'
387: AND NVL(closed_ind, 'N') <> 'Y';
388:
389: l_application_type igs_ad_appl_all.application_type%TYPE;
390: lv_rowid VARCHAR2(25);
391: l_org_id NUMBER(15);
392: BEGIN
393: -- Work out NOCOPY the new admission_appl_number.