APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PE_PERSON_TYPES

Line 828: CURSOR cur_per_type IS SELECT person_type_code FROM igs_pe_person_types_v

824: || Known limitations, enhancements or remarks :
825: || Change History :
826: || Who When What
827: ------------------------------------------------------------------------------*/
828: CURSOR cur_per_type IS SELECT person_type_code FROM igs_pe_person_types_v
829: WHERE system_type = 'STAFF'
830: AND closed_ind ='N';
831: l_person_type_code igs_en_stdnt_ps_att.dropped_by%TYPE;
832: BEGIN

Line 1162: cp_system_type igs_pe_person_types.system_type%type ,

1158: l_label VARCHAR2(500);
1159: l_debug_str VARCHAR2(3200);
1160:
1161: CURSOR get_active_inst_cur(cp_person_id hz_parties.party_id%type,
1162: cp_system_type igs_pe_person_types.system_type%type ,
1163: cp_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE) IS
1164: SELECT MAX(NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) FROM igs_pe_typ_instances_all pti
1165: WHERE pti.person_id = cp_person_id
1166: AND pti.type_instance_id <> cp_type_instance_id

Line 1169: (select person_type_code from igs_pe_person_types pt where system_type =cp_system_type) ;

1165: WHERE pti.person_id = cp_person_id
1166: AND pti.type_instance_id <> cp_type_instance_id
1167: AND SYSDATE BETWEEN pti.start_date and NVL(pti.end_date, SYSDATE)
1168: AND pti.person_type_code IN
1169: (select person_type_code from igs_pe_person_types pt where system_type =cp_system_type) ;
1170:
1171: l_max_active_date DATE;
1172: BEGIN
1173:

Line 1225: CURSOR cur_per_inst(p_person_type igs_pe_person_types.system_type%TYPE)

1221: || Who When What
1222: || pkpatel 30-Sep-2005 Bug 4627888 (Raised the Business event after the Insert/update of the person type)
1223: ------------------------------------------------------------------------------*/
1224: --Cursor get the person type instance for a person for a given person type.
1225: CURSOR cur_per_inst(p_person_type igs_pe_person_types.system_type%TYPE)
1226: IS SELECT pti.*
1227: FROM igs_pe_typ_instances_all pti,
1228: igs_pe_person_types pty
1229: WHERE pti.person_id = p_person_id

Line 1228: igs_pe_person_types pty

1224: --Cursor get the person type instance for a person for a given person type.
1225: CURSOR cur_per_inst(p_person_type igs_pe_person_types.system_type%TYPE)
1226: IS SELECT pti.*
1227: FROM igs_pe_typ_instances_all pti,
1228: igs_pe_person_types pty
1229: WHERE pti.person_id = p_person_id
1230: AND pti.course_cd = p_course_cd
1231: AND pti.end_date IS NULL
1232: AND pty.person_type_code = pti.person_type_code

Line 1237: CURSOR cur_per_type(p_system_type igs_pe_person_types.system_type%TYPE)

1233: AND pty.system_type = p_person_type;
1234: rec_per_inst cur_per_inst%ROWTYPE;
1235:
1236: --Cursor get the person type for given system person type.
1237: CURSOR cur_per_type(p_system_type igs_pe_person_types.system_type%TYPE)
1238: IS SELECT person_type_code FROM igs_pe_person_types
1239: WHERE SYSTEM_TYPE = p_system_type
1240: AND CLOSED_IND = 'N';
1241:

Line 1238: IS SELECT person_type_code FROM igs_pe_person_types

1234: rec_per_inst cur_per_inst%ROWTYPE;
1235:
1236: --Cursor get the person type for given system person type.
1237: CURSOR cur_per_type(p_system_type igs_pe_person_types.system_type%TYPE)
1238: IS SELECT person_type_code FROM igs_pe_person_types
1239: WHERE SYSTEM_TYPE = p_system_type
1240: AND CLOSED_IND = 'N';
1241:
1242: CURSOR get_usr_id_cur(cp_person_id fnd_user.person_party_id%type) IS

Line 1251: l_person_type_code igs_pe_person_types.person_type_code%TYPE;

1247: CURSOR cur_pe_seq IS SELECT IGS_PE_TYPE_INSTANCES_S.NEXTVAL FROM DUAL;
1248:
1249: l_method VARCHAR2(50) := 'PERSON_ENROL_UNIT_SECT';
1250: l_error NUMBER := 0;
1251: l_person_type_code igs_pe_person_types.person_type_code%TYPE;
1252: l_type_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
1253: l_user_id fnd_user.user_id%TYPE;
1254: l_sysdate DATE := TRUNC(SYSDATE);
1255: BEGIN