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_NSC_PKG dependencies on IGS_PE_PERSON

Line 86: p_student_id IN igs_pe_person.person_id%TYPE ,

82: */
83:
84: FUNCTION Get_Enrollment_Status (
85: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
86: p_student_id IN igs_pe_person.person_id%TYPE ,
87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
90: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

Line 110: p_student_id IN igs_pe_person.person_id%TYPE,

106: from F to H or L, or from H to L
107: */
108:
109: FUNCTION Get_Status_Change_Date (
110: p_student_id IN igs_pe_person.person_id%TYPE,
111: p_old_status IN VARCHAR2,
112: p_new_status IN VARCHAR2,
113: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
114: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

Line 369: CURSOR c_person_already_in_report(cp_person_id igs_pe_person.person_id%TYPE,cp_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE) IS

365:
366:
367: --Check if the person has already been added by checking if an SSN entry has been made .
368: --The SSN Attribute is mandatory (attrib_id=20)
369: CURSOR c_person_already_in_report(cp_person_id igs_pe_person.person_id%TYPE,cp_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE) IS
370: SELECT cst_valid FROM igs_en_attrib_values
371: WHERE obj_type_id = 1
372: AND obj_id = cp_snapshot_id
373: AND attrib_id = 20

Line 377: CURSOR c_validate_person_id (cp_person_id igs_pe_person.person_id%type) IS

373: AND attrib_id = 20
374: AND version = cp_person_id;
375:
376: --Checks the res_status and SSN of the person
377: CURSOR c_validate_person_id (cp_person_id igs_pe_person.person_id%type) IS
378: SELECT cst_valid
379: FROM igs_pe_eit perv
380: WHERE perv.person_id=cp_person_id
381: AND information_type = 'PE_STAT_RES_STATUS'

Line 389: FROM igs_pe_alt_pers_id pit,igs_pe_person_id_typ ppit

385: WHERE opt_type = 'NC_STAT_CD'
386: )
387: AND EXISTS
388: (SELECT 'X'
389: FROM igs_pe_alt_pers_id pit,igs_pe_person_id_typ ppit
390: WHERE cp_person_id=pit.pe_person_id
391: AND pit.person_id_type = ppit.person_id_type
392: AND ppit.s_person_id_type = 'SSN'
393: AND pit.start_dt <= SYSDATE

Line 1412: FROM igs_pe_person_id_typ

1408: FROM igs_pe_alt_pers_id
1409: WHERE pe_person_id = p_student_data.student_id
1410: AND person_id_type
1411: IN (SELECT person_id_type
1412: FROM igs_pe_person_id_typ
1413: WHERE s_person_id_type = 'SSN')
1414: AND start_dt <= sysdate
1415: AND end_dt IS NULL;
1416:

Line 1417: -- Cursor to get the person details..cursor is changed from igs_pe_person to underlying tables

1413: WHERE s_person_id_type = 'SSN')
1414: AND start_dt <= sysdate
1415: AND end_dt IS NULL;
1416:
1417: -- Cursor to get the person details..cursor is changed from igs_pe_person to underlying tables
1418: CURSOR c_name IS
1419: SELECT p.person_last_name surname,
1420: p.person_first_name given_names,
1421: p.person_middle_name middle_name,

Line 1437: FROM igs_pe_person_id_typ

1433: FROM igs_pe_alt_pers_id
1434: WHERE pe_person_id = p_student_data.student_id
1435: AND person_id_type
1436: IN (SELECT person_id_type
1437: FROM igs_pe_person_id_typ
1438: WHERE s_person_id_type = 'SSN')
1439: AND start_dt <= sysdate
1440: AND end_dt IS NOT NULL
1441: AND start_dt <> end_dt

Line 1448: FROM igs_pe_person_alias ppa,

1444:
1445: -- Check for previous last name
1446: CURSOR c_prev_last_name IS
1447: SELECT ppa.surname
1448: FROM igs_pe_person_alias ppa,
1449: igs_en_nsc_options eno
1450: WHERE ppa.person_id = p_student_data.student_id
1451: AND ppa.alias_type = eno.opt_val
1452: AND eno.opt_type = 'LAST_NAME'

Line 1465: FROM igs_pe_person_addr

1461: city ,
1462: decode(country,'US',state,'FO') state,
1463: decode(country,'US',postal_code,' ' ) postal_code,
1464: decode(country,'US','',country)
1465: FROM igs_pe_person_addr
1466: WHERE person_id = p_student_data.student_id
1467: AND addr_type
1468: IN (SELECT opt_val
1469: FROM igs_en_nsc_options

Line 1716: p_student_id IN igs_pe_person.person_id%TYPE ,

1712: /******************************************************************************/
1713:
1714: FUNCTION Get_Enrollment_Status (
1715: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1716: p_student_id IN igs_pe_person.person_id%TYPE ,
1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1720: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

Line 1784: /* For deceased date..cursor is changed from igs_pe_person to underlying tables */

1780: WHERE opt_val = l_status
1781: AND opt_type IN
1782: ('ENR_STAT_F','ENR_STAT_H','ENR_STAT_L');
1783:
1784: /* For deceased date..cursor is changed from igs_pe_person to underlying tables */
1785: CURSOR c_decease_date IS
1786: SELECT NVL(pp.date_of_death,SYSDATE)
1787: FROM igs_pe_hz_parties pd, hz_person_profiles pp
1788: WHERE DECODE(pp.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y')='Y'

Line 2610: p_student_id IN igs_pe_person.person_id%TYPE,

2606:
2607: /******************************************************************************/
2608:
2609: FUNCTION Get_Status_Change_Date (
2610: p_student_id IN igs_pe_person.person_id%TYPE,
2611: p_old_status IN VARCHAR2,
2612: p_new_status IN VARCHAR2,
2613: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2614: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,