APPS.IGS_EN_VAL_API dependencies on IGS_PE_ALT_PERS_ID_V

Line 137: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

133:
134: END enrp_val_api_pan;
135:
136: FUNCTION val_overlap_api(
137: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
138: RETURN BOOLEAN AS
139: ------------------------------------------------------------------------------------------
140: --Created by : pkpatel
141: --Date created: 8-JUN-2002

Line 158: CURSOR c_validate_overlap_dates ( cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

154: --askapoor 31-jan-05 Added NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <> A.START_DT
155: -- in val_overlap_api
156: ----------------------------------------------------------------------------------------------
157:
158: CURSOR c_validate_overlap_dates ( cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
159: IS
160: SELECT COUNT(1)
161: FROM IGS_PE_ALT_PERS_ID A,
162: IGS_PE_ALT_PERS_ID B

Line 180: CURSOR c_end_chk (cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

176:
177:
178: ln_count NUMBER(10);
179:
180: CURSOR c_end_chk (cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
181: IS
182: SELECT count('x')
183: FROM igs_pe_alt_pers_id
184: WHERE pe_person_id = cp_person_id

Line 215: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

211:
212: END val_overlap_api;
213:
214: FUNCTION val_ssn_overlap_api(
215: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
216: RETURN BOOLEAN AS
217: ------------------------------------------------------------------------------------------
218: --Created by : pkpatel
219: --Date created: 8-JUN-2002

Line 233: CURSOR val_overlap_dt_ssn_cur ( cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

229: -- vrathi 18-may-2003 Bug 2928745 : end date check cursor modified to include person_id_type
230: --askapoor 31-jan-05 Added NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <> A.START_DT
231: -- in val_ssn_overlap_api
232: ----------------------------------------------------------------------------------------------
233: CURSOR val_overlap_dt_ssn_cur ( cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
234: IS
235: SELECT COUNT(1)
236: FROM IGS_PE_ALT_PERS_ID A,
237: IGS_PE_ALT_PERS_ID B

Line 254: CURSOR c_end_chk (cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

250: );
251:
252: l_count NUMBER := 0;
253:
254: CURSOR c_end_chk (cp_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
255: IS
256: SELECT count('x')
257: FROM igs_pe_alt_pers_id
258: WHERE pe_person_id = cp_person_id