APPS.IGS_PE_TYP_INSTANCES_PKG dependencies on IGS_PE_GEN_003

Line 1081: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(l_person_id_w_other, l_person_type_w_other, p_action, l_person_end_date_other);

1077: after_insertupdate2;
1078:
1079: -- The Business event should be raised only if end date is greater than current date
1080: IF l_usr_id IS NOT NULL AND (NVL(l_person_end_date_other,SYSDATE+1) > SYSDATE)THEN
1081: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(l_person_id_w_other, l_person_type_w_other, p_action, l_person_end_date_other);
1082: END IF;
1083:
1084: ELSIF (p_action = 'UPDATE') THEN
1085:

Line 1101: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(new_references.person_id , new_references.person_type_code, p_action, l_person_end_date_other);

1097: --if setting end date of person type to NULL, then dont bother, just raise the event.
1098: --else raise the event only if no other end date person type instance for same person type exists and
1099: --the end date is greated than the Max end date of other records
1100: IF l_person_end_date_other IS NULL THEN
1101: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(new_references.person_id , new_references.person_type_code, p_action, l_person_end_date_other);
1102: ELSE
1103: IF l_max_active_date IS NULL OR l_max_active_date < l_person_end_date_other THEN
1104: -- This case is specifically for Import process where start/end date can be less
1105: -- current date. So if end date is passed as less than the current date then pass it as current date

Line 1110: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(new_references.person_id , new_references.person_type_code, p_action, l_person_end_date_other);

1106:
1107: IF l_person_end_date_other < SYSDATE THEN
1108: l_person_end_date_other := TRUNC(SYSDATE);
1109: END IF;
1110: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(new_references.person_id , new_references.person_type_code, p_action, l_person_end_date_other);
1111: END IF;
1112: END IF;
1113:
1114:

Line 1124: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(old_references.person_id, old_references.person_type_code, p_action);

1120: FETCH get_usr_id_cur INTO l_usr_d_id;
1121: CLOSE get_usr_id_cur;
1122:
1123: IF l_usr_d_id IS NOT NULL THEN
1124: igs_pe_gen_003.RAISE_PERSON_TYPE_EVENT(old_references.person_id, old_references.person_type_code, p_action);
1125: END IF;
1126: END IF;
1127: END After_DML;
1128: