APPS.IGS_PR_GEN_004 dependencies on IGS_EN_DCNT_REASONCD

Line 317: v_discont_reason_cd IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;

313: v_key IGS_GE_s_log.KEY%TYPE;
314: v_process_next_spo BOOLEAN;
315: v_other_encumbrance BOOLEAN;
316: v_exit_procedure BOOLEAN DEFAULT FALSE;
317: v_discont_reason_cd IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
318: v_s_discont_reason_type IGS_EN_DCNT_REASONCD.s_discontinuation_reason_type%TYPE;
319: v_expiry_status VARCHAR2(10);
320: v_expiry_dt DATE;
321: v_authorising_person_id IGS_PE_person.person_id%TYPE;

Line 318: v_s_discont_reason_type IGS_EN_DCNT_REASONCD.s_discontinuation_reason_type%TYPE;

314: v_process_next_spo BOOLEAN;
315: v_other_encumbrance BOOLEAN;
316: v_exit_procedure BOOLEAN DEFAULT FALSE;
317: v_discont_reason_cd IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
318: v_s_discont_reason_type IGS_EN_DCNT_REASONCD.s_discontinuation_reason_type%TYPE;
319: v_expiry_status VARCHAR2(10);
320: v_expiry_dt DATE;
321: v_authorising_person_id IGS_PE_person.person_id%TYPE;
322: v_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;

Line 512: IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE) IS

508: spo.prg_ci_sequence_number;
509:
510: CURSOR c_dr (
511: cp_discontinuation_reason_cd
512: IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE) IS
513: SELECT s_discontinuation_reason_type
514: FROM IGS_EN_DCNT_REASONCD dr
515: WHERE dr.discontinuation_reason_cd = cp_discontinuation_reason_cd AND
516: dr.s_discontinuation_reason_type = cst_progress;

Line 514: FROM IGS_EN_DCNT_REASONCD dr

510: CURSOR c_dr (
511: cp_discontinuation_reason_cd
512: IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE) IS
513: SELECT s_discontinuation_reason_type
514: FROM IGS_EN_DCNT_REASONCD dr
515: WHERE dr.discontinuation_reason_cd = cp_discontinuation_reason_cd AND
516: dr.s_discontinuation_reason_type = cst_progress;
517: CURSOR c_spo_pot (
518: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,