APPS.IGS_PE_ALT_PERS_ID_PKG dependencies on IGS_PE_PERSON_ID_TYP

Line 156: FROM igs_pe_person_id_typ

152: WHERE person_id = cp_person_id;
153:
154: CURSOR format_mask_cur (cp_person_id_type VARCHAR2) IS
155: SELECT format_mask
156: FROM igs_pe_person_id_typ
157: WHERE person_id_type = cp_person_id_type;
158:
159: birth_date_rec birth_date_cur%ROWTYPE;
160: format_mask_rec format_mask_cur%ROWTYPE;

Line 250: --ssaleem 17-Sep-2004 Bug 3787210 -- added Closed Ind igs_pe_person_id_typ table

246: -- Added the call igs_en_val_api.val_overlap_api so that there would be only one ACTIVE
247: -- alternate person id exist for a person ID type for a person
248: -- Added the call igs_en_val_api.val_ssn_overlap_api so that there would be only one ACTIVE
249: -- alternate person id exist for Social Security Number for a person
250: --ssaleem 17-Sep-2004 Bug 3787210 -- added Closed Ind igs_pe_person_id_typ table
251: --gmaheswa 29-Sep-2004 BUG 3787210 removed Closed indicator check for the Alternate Person Id type while end date overlap check.
252:
253: ----------------------------------------------------------------------------------------------
254: v_message_name varchar2(30);

Line 258: CURSOR c_pit (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS

254: v_message_name varchar2(30);
255: v_rowid_saved BOOLEAN := FALSE;
256: cst_pay_adv_no CONSTANT VARCHAR2(10) := 'PAY_ADV_NO';
257: v_dummy VARCHAR2(1);
258: CURSOR c_pit (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
259: SELECT 'x'
260: FROM IGS_PE_PERSON_ID_TYP pit
261: WHERE pit.person_id_type = cp_person_id_type AND
262: pit.s_person_id_type = cst_pay_adv_no AND

Line 260: FROM IGS_PE_PERSON_ID_TYP pit

256: cst_pay_adv_no CONSTANT VARCHAR2(10) := 'PAY_ADV_NO';
257: v_dummy VARCHAR2(1);
258: CURSOR c_pit (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
259: SELECT 'x'
260: FROM IGS_PE_PERSON_ID_TYP pit
261: WHERE pit.person_id_type = cp_person_id_type AND
262: pit.s_person_id_type = cst_pay_adv_no AND
263: pit.closed_ind = 'N';
264:

Line 265: CURSOR sys_pit_cur (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS

261: WHERE pit.person_id_type = cp_person_id_type AND
262: pit.s_person_id_type = cst_pay_adv_no AND
263: pit.closed_ind = 'N';
264:
265: CURSOR sys_pit_cur (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
266: SELECT pit.s_person_id_type
267: FROM igs_pe_person_id_typ pit
268: WHERE pit.person_id_type = cp_person_id_type;
269:

Line 267: FROM igs_pe_person_id_typ pit

263: pit.closed_ind = 'N';
264:
265: CURSOR sys_pit_cur (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
266: SELECT pit.s_person_id_type
267: FROM igs_pe_person_id_typ pit
268: WHERE pit.person_id_type = cp_person_id_type;
269:
270: l_s_person_id_type IGS_PE_PERSON_ID_TYP.s_person_id_type%TYPE;
271:

Line 270: l_s_person_id_type IGS_PE_PERSON_ID_TYP.s_person_id_type%TYPE;

266: SELECT pit.s_person_id_type
267: FROM igs_pe_person_id_typ pit
268: WHERE pit.person_id_type = cp_person_id_type;
269:
270: l_s_person_id_type IGS_PE_PERSON_ID_TYP.s_person_id_type%TYPE;
271:
272: BEGIN
273: -- Validate the alternate IGS_PE_PERSON id when a 'PAY_ADV_NO' is unique.
274: IF p_inserting OR p_updating THEN

Line 343: FROM igs_pe_person_id_typ

339: -- Removed condition start_dt < end_dt and end_dt > start_dt
340: ----------------------------------------------------------------------------------------------
341: CURSOR pt IS
342: SELECT unique_ind
343: FROM igs_pe_person_id_typ
344: WHERE person_id_type = new_references.person_id_type AND
345: closed_ind = 'N';
346:
347: CURSOR cptu IS

Line 432: IF NOT IGS_PE_PERSON_ID_TYP_PKG.Get_PID_Type_Validation (

428: IF (((old_references.person_id_type = new_references.person_id_type)) OR
429: ((new_references.person_id_type IS NULL))) THEN
430: NULL;
431: ELSE
432: IF NOT IGS_PE_PERSON_ID_TYP_PKG.Get_PID_Type_Validation (
433: new_references.person_id_type) THEN
434: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;