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

Line 107: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

103:
104:
105: PROCEDURE get_alt_pers_id
106: (p_person_id IN igs_pe_person.person_id%TYPE,
107: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
108: p_api_id OUT NOCOPY VARCHAR2,
109: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
110: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE
111: ) IS

Line 125: FROM igs_pe_alt_pers_id

121: ***************************************************************/
122: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
123: CURSOR c_api IS
124: SELECT api_person_id
125: FROM igs_pe_alt_pers_id
126: WHERE pe_person_id = p_person_id
127: AND person_id_type = p_id_type
128: AND Start_Dt <= p_enrl_end_dt
129: AND ( End_Dt IS NULL OR End_Dt >= p_enrl_start_dt )

Line 189: FROM igs_pe_alt_pers_id

185: --Cursor to check number of person id types exisitng .
186: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
187: CURSOR c_api IS
188: SELECT api_person_id
189: FROM igs_pe_alt_pers_id
190: WHERE pe_person_id = p_person_id
191: AND person_id_type IN ('UCASID','NMASID','SWASID','GTTRID')
192: AND Start_Dt <= p_enrl_end_dt
193: AND ( End_Dt IS NULL OR End_Dt >= p_enrl_start_dt )

Line 200: FROM igs_pe_alt_pers_id

196: -- smaddali added these cursors for bug#3371259
197: -- get the latest HUSID record for the person
198: CURSOR c_husid IS
199: SELECT api_person_id, start_dt, end_dt
200: FROM igs_pe_alt_pers_id
201: WHERE pe_person_id = p_person_id
202: AND person_id_type = 'HUSID'
203: AND (end_dt IS NULL OR start_dt <> end_dt)
204: ORDER BY start_dt DESC;

Line 210: FROM igs_pe_alt_pers_id

206:
207: -- get the min start_dt of HUSID records which are starting after the Submission period end date
208: CURSOR c_future_husid IS
209: SELECT start_dt
210: FROM igs_pe_alt_pers_id
211: WHERE pe_person_id = p_person_id
212: AND person_id_type = 'HUSID'
213: AND start_dt > p_enrl_end_dt
214: AND (end_dt IS NULL OR start_Dt <> end_Dt)

Line 220: FROM igs_pe_alt_pers_id

216: c_future_husid_rec c_future_husid%ROWTYPE ;
217:
218: CURSOR current_husid_cur IS
219: SELECT api_person_id, start_dt, end_dt
220: FROM igs_pe_alt_pers_id
221: WHERE pe_person_id = p_person_id
222: AND person_id_type = 'HUSID'
223: AND start_dt <= p_enrl_end_dt
224: AND (end_dt IS NULL OR end_dt >= p_enrl_start_dt)

Line 230: CURSOR c_deleted_husid(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,

226: ORDER BY start_dt DESC;
227: current_husid_rec current_husid_cur%ROWTYPE;
228:
229: --sjlaport added for HE358 to check for logically deleted HUSID records
230: CURSOR c_deleted_husid(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
231: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
232: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
233: SELECT 'X'
234: FROM igs_pe_alt_pers_id

Line 231: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,

227: current_husid_rec current_husid_cur%ROWTYPE;
228:
229: --sjlaport added for HE358 to check for logically deleted HUSID records
230: CURSOR c_deleted_husid(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
231: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
232: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
233: SELECT 'X'
234: FROM igs_pe_alt_pers_id
235: WHERE pe_person_id = cp_person_id

Line 232: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS

228:
229: --sjlaport added for HE358 to check for logically deleted HUSID records
230: CURSOR c_deleted_husid(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
231: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
232: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
233: SELECT 'X'
234: FROM igs_pe_alt_pers_id
235: WHERE pe_person_id = cp_person_id
236: AND api_person_id = cp_api_person_id

Line 234: FROM igs_pe_alt_pers_id

230: CURSOR c_deleted_husid(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
231: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
232: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
233: SELECT 'X'
234: FROM igs_pe_alt_pers_id
235: WHERE pe_person_id = cp_person_id
236: AND api_person_id = cp_api_person_id
237: AND start_dt = TRUNC(cp_start_dt)
238: AND person_id_type = 'HUSID'

Line 247: l_start_dt igs_pe_alt_pers_id.start_dt%TYPE ;

243:
244: l_derive BOOLEAN ;
245: l_cre_husid BOOLEAN ;
246: l_cre_lat_husid BOOLEAN ;
247: l_start_dt igs_pe_alt_pers_id.start_dt%TYPE ;
248: l_end_dt igs_pe_alt_pers_id.end_dt%TYPE ;
249:
250: l_stdnt_id igs_pe_alt_pers_id.api_person_id%TYPE;
251: l_year VARCHAR2(2);

Line 248: l_end_dt igs_pe_alt_pers_id.end_dt%TYPE ;

244: l_derive BOOLEAN ;
245: l_cre_husid BOOLEAN ;
246: l_cre_lat_husid BOOLEAN ;
247: l_start_dt igs_pe_alt_pers_id.start_dt%TYPE ;
248: l_end_dt igs_pe_alt_pers_id.end_dt%TYPE ;
249:
250: l_stdnt_id igs_pe_alt_pers_id.api_person_id%TYPE;
251: l_year VARCHAR2(2);
252: l_sid VARCHAR2(30);

Line 250: l_stdnt_id igs_pe_alt_pers_id.api_person_id%TYPE;

246: l_cre_lat_husid BOOLEAN ;
247: l_start_dt igs_pe_alt_pers_id.start_dt%TYPE ;
248: l_end_dt igs_pe_alt_pers_id.end_dt%TYPE ;
249:
250: l_stdnt_id igs_pe_alt_pers_id.api_person_id%TYPE;
251: l_year VARCHAR2(2);
252: l_sid VARCHAR2(30);
253: l_index NUMBER := 0;
254: l_chk_sum NUMBER := 0;

Line 501: UPDATE igs_pe_alt_pers_id

497:
498: CLOSE c_deleted_husid;
499:
500: -- update existing record
501: UPDATE igs_pe_alt_pers_id
502: SET end_dt = l_end_dt,
503: last_updated_by = Fnd_Global.user_id,
504: last_update_date = Sysdate,
505: last_update_login = Fnd_Global.login_id

Line 522: INSERT INTO igs_pe_alt_pers_id

518: ELSE
519:
520: CLOSE c_deleted_husid;
521:
522: INSERT INTO igs_pe_alt_pers_id
523: (pe_person_id,
524: api_person_id,
525: person_id_type,
526: start_dt,

Line 558: UPDATE igs_pe_alt_pers_id

554:
555: CLOSE c_deleted_husid;
556:
557: -- update existing record
558: UPDATE igs_pe_alt_pers_id
559: SET end_dt = NULL,
560: last_updated_by = Fnd_Global.user_id,
561: last_update_date = Sysdate,
562: last_update_login = Fnd_Global.login_id

Line 579: INSERT INTO igs_pe_alt_pers_id

575: ELSE
576:
577: CLOSE c_deleted_husid;
578:
579: INSERT INTO igs_pe_alt_pers_id
580: (pe_person_id,
581: api_person_id,
582: person_id_type,
583: start_dt,

Line 1381: p_ucasnum IN igs_pe_alt_pers_id.api_person_id%TYPE,

1377: PROCEDURE get_yr_left_last_inst
1378: (p_person_id IN igs_pe_person.person_id%TYPE,
1379: p_com_dt IN DATE,
1380: p_hesa_gen_qaim IN VARCHAR2,
1381: p_ucasnum IN igs_pe_alt_pers_id.api_person_id%TYPE,
1382: p_year OUT NOCOPY VARCHAR2)
1383:
1384: IS
1385: /***************************************************************

Line 3704: FROM igs_pe_alt_pers_id_v api,

3700: -- Get the SLC LEA Code
3701: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
3702: CURSOR cur_slc_lea_cd IS
3703: SELECT SUBSTR (api.api_person_id,1,4)
3704: FROM igs_pe_alt_pers_id_v api,
3705: igs_pe_person_id_typ pit
3706: WHERE api.person_id_type = pit.Person_id_type
3707: AND pit.s_person_id_type = 'SLC'
3708: AND api.pe_person_id = p_person_id

Line 3750: l_slc_lea_cd igs_pe_alt_pers_id.api_person_id%TYPE;

3746: AND inv.fee_ci_sequence_number = cp_fee_ci_sequence_number
3747: AND ft.s_fee_type = 'TUTNFEE';
3748:
3749: l_value igs_he_ex_rn_dat_fd.value%TYPE;
3750: l_slc_lea_cd igs_pe_alt_pers_id.api_person_id%TYPE;
3751: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
3752: l_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3753: l_tot_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3754: l_message_name fnd_new_messages.message_name%TYPE;

Line 6821: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,

6817:
6818: END get_commencement_dt;
6819:
6820: PROCEDURE get_ucasnum(p_person_id IN igs_pe_person.person_id%TYPE,
6821: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
6822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6823: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
6824:
6825: IS

Line 6841: l_stdnt_id igs_pe_alt_pers_id.api_person_id%TYPE;

6837: NMASID or GTTRID, or SWASID, bug 2986518
6838: smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
6839: ***************************************************************/
6840:
6841: l_stdnt_id igs_pe_alt_pers_id.api_person_id%TYPE;
6842: l_sid VARCHAR2(30);
6843: l_index NUMBER := 0;
6844: l_chk_sum NUMBER := 0;
6845: l_chk_digit NUMBER(2);