APPS.IGS_AD_GEN_002 dependencies on IGS_PE_PERSENC_EFFCT

Line 53: cst_sus_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=

49: fp_input UTL_FILE.FILE_TYPE;
50: fp_output UTL_FILE.FILE_TYPE;
51: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
52: 'ENROLLED';
53: cst_sus_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=
54: 'SUS_SRVC';
55: cst_rvk_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=
56: 'RVK_SRVC';
57: v_record_type VARCHAR2(1);

Line 55: cst_rvk_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=

51: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
52: 'ENROLLED';
53: cst_sus_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=
54: 'SUS_SRVC';
55: cst_rvk_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=
56: 'RVK_SRVC';
57: v_record_type VARCHAR2(1);
58: v_input_string VARCHAR2(158);
59: v_previous_name_records_cnt NUMBER(2);

Line 195: cst_result_blk CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=

191: p_target_person_id IN IGS_PE_PERSON.person_id%TYPE,
192: p_basis_of_match IN VARCHAR2,
193: p_number_of_matches IN OUT NOCOPY NUMBER)
194: IS
195: cst_result_blk CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=
196: 'RESULT_BLK';
197: v_number_of_matches NUMBER(4);
198: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;
199: v_reason_code VARCHAR2(1);

Line 198: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;

194: IS
195: cst_result_blk CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=
196: 'RESULT_BLK';
197: v_number_of_matches NUMBER(4);
198: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;
199: v_reason_code VARCHAR2(1);
200: CURSOR c_pee IS
201: SELECT pee.person_id
202: FROM IGS_PE_PERSENC_EFFCT pee

Line 202: FROM IGS_PE_PERSENC_EFFCT pee

198: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;
199: v_reason_code VARCHAR2(1);
200: CURSOR c_pee IS
201: SELECT pee.person_id
202: FROM IGS_PE_PERSENC_EFFCT pee
203: WHERE pee.person_id = p_target_person_id AND
204: pee.s_encmb_effect_type IN (
205: cst_result_blk,
206: cst_sus_srvc,

Line 1416: FROM IGS_PE_PERSENC_EFFCT pee

1412: WHERE cty.course_type = cp_course_type;
1413: CURSOR c_pee (
1414: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
1415: SELECT pee.s_encmb_effect_type
1416: FROM IGS_PE_PERSENC_EFFCT pee
1417: WHERE pee.person_id = cp_person_id AND
1418: pee.s_encmb_effect_type IN (
1419: cst_sus_srvc,
1420: cst_rvk_srvc);