APPS.IGR_GEN_001 dependencies on IGS_PE_PRSID_GRP_MEM

Line 453: p_group_id igs_pe_prsid_grp_mem.group_id%TYPE,

449: App_Exception.Raise_Exception;
450: END create_person_id_group;
451:
452: PROCEDURE create_person_id_group_member (
453: p_group_id igs_pe_prsid_grp_mem.group_id%TYPE,
454: p_person_id igs_pe_prsid_grp_mem.person_id%TYPE) IS
455: /****************************************************************************
456: Created By :
457: Date Created On :

Line 454: p_person_id igs_pe_prsid_grp_mem.person_id%TYPE) IS

450: END create_person_id_group;
451:
452: PROCEDURE create_person_id_group_member (
453: p_group_id igs_pe_prsid_grp_mem.group_id%TYPE,
454: p_person_id igs_pe_prsid_grp_mem.person_id%TYPE) IS
455: /****************************************************************************
456: Created By :
457: Date Created On :
458: Purpose :

Line 474: FROM igs_pe_prsid_grp_mem pigm

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
477: NVL(TRUNC(start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) AND
478: NVL(TRUNC(end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);

Line 487: IGS_PE_PRSID_GRP_MEM_Pkg.Insert_Row (

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',
489: X_RowId => lv_rowid,
490: X_Group_Id => p_group_id,
491: X_Person_Id => p_person_id,