eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PE_TYP_INSTANCES

Line 1139: p_person_id igs_pe_typ_instances_all.person_id%TYPE,

1135: APP_EXCEPTION.RAISE_EXCEPTION;
1136: END val_sca_comp_flag;
1137:
1138: PROCEDURE raise_person_type_event(
1139: p_person_id igs_pe_typ_instances_all.person_id%TYPE,
1140: p_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE,
1141: p_person_type_start_date igs_pe_typ_instances_all.start_date%TYPE,
1142: p_person_type_end_date igs_pe_typ_instances_all.end_date%TYPE,
1143: p_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE,

Line 1140: p_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE,

1136: END val_sca_comp_flag;
1137:
1138: PROCEDURE raise_person_type_event(
1139: p_person_id igs_pe_typ_instances_all.person_id%TYPE,
1140: p_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE,
1141: p_person_type_start_date igs_pe_typ_instances_all.start_date%TYPE,
1142: p_person_type_end_date igs_pe_typ_instances_all.end_date%TYPE,
1143: p_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE,
1144: p_system_person_type VARCHAR2,

Line 1141: p_person_type_start_date igs_pe_typ_instances_all.start_date%TYPE,

1137:
1138: PROCEDURE raise_person_type_event(
1139: p_person_id igs_pe_typ_instances_all.person_id%TYPE,
1140: p_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE,
1141: p_person_type_start_date igs_pe_typ_instances_all.start_date%TYPE,
1142: p_person_type_end_date igs_pe_typ_instances_all.end_date%TYPE,
1143: p_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE,
1144: p_system_person_type VARCHAR2,
1145: p_action VARCHAR2

Line 1142: p_person_type_end_date igs_pe_typ_instances_all.end_date%TYPE,

1138: PROCEDURE raise_person_type_event(
1139: p_person_id igs_pe_typ_instances_all.person_id%TYPE,
1140: p_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE,
1141: p_person_type_start_date igs_pe_typ_instances_all.start_date%TYPE,
1142: p_person_type_end_date igs_pe_typ_instances_all.end_date%TYPE,
1143: p_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE,
1144: p_system_person_type VARCHAR2,
1145: p_action VARCHAR2
1146: )

Line 1143: p_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE,

1139: p_person_id igs_pe_typ_instances_all.person_id%TYPE,
1140: p_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE,
1141: p_person_type_start_date igs_pe_typ_instances_all.start_date%TYPE,
1142: p_person_type_end_date igs_pe_typ_instances_all.end_date%TYPE,
1143: p_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE,
1144: p_system_person_type VARCHAR2,
1145: p_action VARCHAR2
1146: )
1147: AS

Line 1163: cp_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE) IS

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
1167: AND SYSDATE BETWEEN pti.start_date and NVL(pti.end_date, SYSDATE)

Line 1164: SELECT MAX(NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) FROM igs_pe_typ_instances_all pti

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
1167: AND SYSDATE BETWEEN pti.start_date and NVL(pti.end_date, SYSDATE)
1168: AND pti.person_type_code IN

Line 1227: FROM igs_pe_typ_instances_all pti,

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
1230: AND pti.course_cd = p_course_cd
1231: AND pti.end_date IS NULL

Line 1252: l_type_instance_id igs_pe_typ_instances.type_instance_id%TYPE;

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
1256: -- Person Type business event should be raised only if the person is associated with a User

Line 1269: UPDATE igs_pe_typ_instances_all

1265: -- if exist then update the end date with sysdate.
1266: OPEN cur_per_inst('APPLICANT');
1267: FETCH cur_per_inst INTO rec_per_inst;
1268: IF cur_per_inst%FOUND THEN
1269: UPDATE igs_pe_typ_instances_all
1270: SET end_date = l_sysdate ,
1271: end_method = l_method ,
1272: last_update_date = SYSDATE,
1273: last_updated_by = NVL(fnd_global.user_id,-1) ,

Line 1311: INSERT INTO igs_pe_typ_instances_all(type_instance_id,

1307: OPEN cur_pe_seq;
1308: FETCH cur_pe_seq INTO l_type_instance_id;
1309: CLOSE cur_pe_seq;
1310:
1311: INSERT INTO igs_pe_typ_instances_all(type_instance_id,
1312: person_type_code,
1313: person_id,
1314: course_cd,
1315: cc_version_number,

Line 1374: UPDATE igs_pe_typ_instances_all

1370: --if exist then update the end date with sysdate.
1371: OPEN cur_per_inst('FORMER_STUDENT');
1372: FETCH cur_per_inst INTO rec_per_inst;
1373: IF cur_per_inst%FOUND THEN
1374: UPDATE igs_pe_typ_instances_all
1375: SET end_date = l_sysdate,
1376: end_method = l_method,
1377: last_update_date = SYSDATE ,
1378: last_updated_by = NVL(fnd_global.user_id,-1) ,

Line 1401: UPDATE igs_pe_typ_instances_all

1397: --if exist then update the end date with sysdate.
1398: OPEN cur_per_inst('STUDENT');
1399: FETCH cur_per_inst INTO rec_per_inst;
1400: IF cur_per_inst%FOUND THEN
1401: UPDATE igs_pe_typ_instances_all
1402: SET end_date = l_sysdate,
1403: end_method = l_method ,
1404: last_update_date = SYSDATE ,
1405: last_updated_by = NVL(fnd_global.user_id,-1) ,

Line 1442: INSERT INTO igs_pe_typ_instances_all(type_instance_id,

1438: OPEN cur_pe_seq;
1439: FETCH cur_pe_seq INTO l_type_instance_id;
1440: CLOSE cur_pe_seq;
1441:
1442: INSERT INTO igs_pe_typ_instances_all(type_instance_id,
1443: person_type_code,
1444: person_id,
1445: course_cd,
1446: cc_version_number,