APPS.IGR_GEN_001 dependencies on IGS_PE_PERSON

Line 394: v_user_id IGS_PE_PERSON.person_id%TYPE;

390: -- kamohan Bug 2382418
391: -- Changed from ADMISSION ENQUIRY to ADMISSION INQUIRY
392:
393: cst_admission_enquiry CONSTANT VARCHAR2(20) := 'ADMISSION INQUIRY';
394: v_user_id IGS_PE_PERSON.person_id%TYPE;
395: v_group_id IGS_PE_PERSID_GROUP.group_id%TYPE;
396: lv_rowid VARCHAR2(25);
397: l_org_id NUMBER(15);
398: CURSOR c_get_next_seq IS

Line 466: v_user_id igs_pe_person.person_id%TYPE;

462: (reverse chronological order - newest change first)
463: *****************************************************************************/
464: BEGIN
465: DECLARE
466: v_user_id igs_pe_person.person_id%TYPE;
467: v_group_id igs_pe_persid_group.group_id%TYPE;
468: lv_rowid VARCHAR2(25);
469: l_org_id NUMBER(15);
470: CURSOR c_pigm (

Line 472: cp_person_id igs_pe_person.person_id%TYPE) IS

468: lv_rowid VARCHAR2(25);
469: l_org_id NUMBER(15);
470: CURSOR c_pigm (
471: cp_group_id igs_pe_persid_group.group_id%TYPE,
472: cp_person_id igs_pe_person.person_id%TYPE) IS
473: SELECT 'X'
474: FROM igs_pe_prsid_grp_mem pigm
475: WHERE pigm.group_id = cp_group_id AND
476: pigm.person_id = cp_person_id AND

Line 484: IF c_pigm%NOTFOUND THEN -- IGS_PE_PERSON not already in group

480: OPEN c_pigm(
481: p_group_id,
482: p_person_id);
483: FETCH c_pigm INTO v_dummy;
484: IF c_pigm%NOTFOUND THEN -- IGS_PE_PERSON not already in group
485: CLOSE c_pigm;
486: l_org_id := igs_ge_gen_003.get_org_id;
487: IGS_PE_PRSID_GRP_MEM_Pkg.Insert_Row (
488: X_Mode => 'R',