APPS.IGS_PE_TYP_INSTANCES_PKG dependencies on FND_USER

Line 1008: CURSOR get_usr_id_cur(cp_person_id fnd_user.person_party_id%type) IS

1004: Added Business Event logic for INSERT, UPDATE and DELETE cases respectively
1005: (reverse chronological order - newest change first)
1006: ***************************************************************/
1007:
1008: CURSOR get_usr_id_cur(cp_person_id fnd_user.person_party_id%type) IS
1009: SELECT user_id
1010: FROM fnd_user
1011: WHERE person_party_id = cp_person_id;
1012:

Line 1010: FROM fnd_user

1006: ***************************************************************/
1007:
1008: CURSOR get_usr_id_cur(cp_person_id fnd_user.person_party_id%type) IS
1009: SELECT user_id
1010: FROM fnd_user
1011: WHERE person_party_id = cp_person_id;
1012:
1013: CURSOR person_type_cur(cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
1014: SELECT system_type

Line 1020: l_usr_id fnd_user.user_id%type;

1016: WHERE pt.person_type_code = cp_person_type;
1017:
1018:
1019: l_system_type igs_pe_person_types.system_type%TYPE;
1020: l_usr_id fnd_user.user_id%type;
1021: l_usr_d_id fnd_user.user_id%type;
1022: l_person_type_w_other varchar2(30) ; -- to hold the person_type value during insert of a person type for the first time.
1023: l_person_id_w_other number; -- to hold the person_id value during insert of a person type for the first time.
1024:

Line 1021: l_usr_d_id fnd_user.user_id%type;

1017:
1018:
1019: l_system_type igs_pe_person_types.system_type%TYPE;
1020: l_usr_id fnd_user.user_id%type;
1021: l_usr_d_id fnd_user.user_id%type;
1022: l_person_type_w_other varchar2(30) ; -- to hold the person_type value during insert of a person type for the first time.
1023: l_person_id_w_other number; -- to hold the person_id value during insert of a person type for the first time.
1024:
1025: ---- Check if the person has more than ONE ACTIVE assignment for the same System Person Type,

Line 1071: -- raise the event only if the person is associated with fnd user.

1067:
1068: OPEN person_type_cur(new_references.person_type_code);
1069: FETCH person_type_cur INTO l_system_type;
1070: CLOSE person_type_cur;
1071: -- raise the event only if the person is associated with fnd user.
1072: -- raise the event for update only if this person has NO other person type instances
1073: -- through which he can get the same set of RESP.
1074: IF (p_action = 'INSERT') THEN
1075: