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_VAL_API dependencies on IGS_PE_ALT_PERS_ID

Line 37: r_alternate_person_id IGS_PE_ALT_PERS_ID%ROWTYPE;

33: p_message_name OUT NOCOPY VARCHAR2)
34: RETURN BOOLEAN AS
35: v_index BINARY_INTEGER;
36:
37: r_alternate_person_id IGS_PE_ALT_PERS_ID%ROWTYPE;
38: cst_pay_adv_no CONSTANT VARCHAR2(10) := 'PAY_ADV_NO';
39: v_dummy VARCHAR2(1);
40: CURSOR c_pit (cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
41: SELECT 'x'

Line 53: FROM IGS_PE_ALT_PERS_ID

49: LOOP
50: BEGIN
51: SELECT *
52: INTO r_alternate_person_id
53: FROM IGS_PE_ALT_PERS_ID
54: WHERE rowid = gt_rowid_table(v_index);
55: EXCEPTION
56: WHEN OTHERS THEN
57: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 83: p_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE ,

79: END enrp_prc_api_rowids;
80: --
81: -- Validate the payment advice number is unique.
82: FUNCTION enrp_val_api_pan(
83: p_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE ,
84: p_pay_advice_number IGS_PE_ALT_PERS_ID.api_person_id%TYPE ,
85: p_message_name OUT NOCOPY varchar2)
86: RETURN BOOLEAN AS
87:

Line 84: p_pay_advice_number IGS_PE_ALT_PERS_ID.api_person_id%TYPE ,

80: --
81: -- Validate the payment advice number is unique.
82: FUNCTION enrp_val_api_pan(
83: p_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE ,
84: p_pay_advice_number IGS_PE_ALT_PERS_ID.api_person_id%TYPE ,
85: p_message_name OUT NOCOPY varchar2)
86: RETURN BOOLEAN AS
87:
88: BEGIN -- enrp_val_api_pan

Line 89: -- Validate that IGS_PE_ALT_PERS_ID where s_person_id_type = 'PAY_ADV_NO' is

85: p_message_name OUT NOCOPY varchar2)
86: RETURN BOOLEAN AS
87:
88: BEGIN -- enrp_val_api_pan
89: -- Validate that IGS_PE_ALT_PERS_ID where s_person_id_type = 'PAY_ADV_NO' is
90: -- unique to the person and that it does not clash with any payment_advice
91: -- number in IGS_FI_STDNT_FEE_SPN
92: DECLARE
93: cst_pay_adv_no CONSTANT VARCHAR2(10) := 'PAY_ADV_NO';

Line 97: FROM IGS_PE_ALT_PERS_ID api,

93: cst_pay_adv_no CONSTANT VARCHAR2(10) := 'PAY_ADV_NO';
94: v_dummy VARCHAR2(1);
95: CURSOR c_api_pit IS
96: SELECT 'x'
97: FROM IGS_PE_ALT_PERS_ID api,
98: IGS_PE_PERSON_ID_TYP pit
99: WHERE api.api_person_id = p_pay_advice_number AND
100: api.pe_person_id <> p_person_id AND
101: api.person_id_type = pit.person_id_type AND

Line 105: -- validate IGS_PE_ALT_PERS_ID where

101: api.person_id_type = pit.person_id_type AND
102: pit.s_person_id_type = cst_pay_adv_no;
103:
104: BEGIN
105: -- validate IGS_PE_ALT_PERS_ID where
106: -- s_person_id_type = 'PAY_ADV_NO' is unique to this IGS_PE_PERSON
107: OPEN c_api_pit;
108: FETCH c_api_pit INTO v_dummy;
109: IF c_api_pit%FOUND THEN

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 161: FROM IGS_PE_ALT_PERS_ID A,

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
163: WHERE A.pe_person_id = cp_person_id
164: AND A.pe_person_id = B.pe_person_id
165: AND A.person_id_type = B.person_id_type

Line 162: IGS_PE_ALT_PERS_ID B

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
163: WHERE A.pe_person_id = cp_person_id
164: AND A.pe_person_id = B.pe_person_id
165: AND A.person_id_type = B.person_id_type
166: AND A.ROWID <> B.ROWID

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 183: FROM igs_pe_alt_pers_id

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
185: AND end_dt IS NULL
186: GROUP BY pe_person_id,PERSON_ID_TYPE
187: HAVING count('x') >1;

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 236: FROM IGS_PE_ALT_PERS_ID A,

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
238: WHERE A.pe_person_id = cp_person_id
239: AND A.pe_person_id = B.pe_person_id
240: AND A.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')

Line 237: IGS_PE_ALT_PERS_ID B

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
238: WHERE A.pe_person_id = cp_person_id
239: AND A.pe_person_id = B.pe_person_id
240: AND A.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')
241: AND B.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')

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

Line 257: FROM igs_pe_alt_pers_id

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
259: AND PERSON_ID_TYPE IN ( select person_id_type from igs_pe_person_id_typ
260: where S_PERSON_ID_TYPE='SSN' )
261: AND end_dt IS NULL

Line 328: p_api_pers_id IN igs_pe_alt_pers_id.api_person_id%TYPE)

324: END IF;
325: END fm_equal;
326:
327: FUNCTION unformat_api(
328: p_api_pers_id IN igs_pe_alt_pers_id.api_person_id%TYPE)
329: RETURN VARCHAR2 AS
330: ------------------------------------------------------------------------------------------
331: --Created by : pkpatel
332: --Date created: 06-JUN-2002

Line 344: l_api_pers_id_gen igs_pe_alt_pers_id.api_person_id%TYPE := NULL;

340: --Who When What
341: ----------------------------------------------------------------------------------------------
342:
343: l_str_len NUMBER := LENGTH(p_api_pers_id);
344: l_api_pers_id_gen igs_pe_alt_pers_id.api_person_id%TYPE := NULL;
345: l_chr VARCHAR2(1);
346:
347: BEGIN
348: FOR i IN 1..l_str_len LOOP