APPS.IGS_EN_GEN_012 dependencies on IGS_PE_PERSON

Line 500: v_person_id IGS_PE_PERSON.person_id%TYPE;

496: || displayed as an error as per bug 3297473
497: */
498:
499: v_other_detail VARCHAR2(255);
500: v_person_id IGS_PE_PERSON.person_id%TYPE;
501: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
502: v_version_number IGS_PS_OFR_OPT.version_number%TYPE;
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;

Line 1934: IGS_PE_PERSON_TYPES PPT

1930: CURSOR c1 IS
1931: --modified for performance bug 3699543
1932: SELECT 'X'
1933: FROM igs_pe_typ_instances_all PTI,
1934: IGS_PE_PERSON_TYPES PPT
1935: WHERE PPT.system_type = 'STUDENT' AND
1936: ppt.person_type_code = pti.person_type_code AND
1937: pti.COURSE_CD = v_sca_exists.COURSE_CD AND
1938: pti.PERSON_ID = v_sca_exists.PERSON_ID;

Line 1944: FROM igs_pe_person_types

1940: c1_rec c1%ROWTYPE;
1941:
1942: CURSOR c_former_stdnt IS
1943: SELECT person_type_code
1944: FROM igs_pe_person_types
1945: WHERE system_type = 'FORMER_STUDENT';
1946:
1947: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
1948:

Line 1947: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;

1943: SELECT person_type_code
1944: FROM igs_pe_person_types
1945: WHERE system_type = 'FORMER_STUDENT';
1946:
1947: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
1948:
1949: l_rowid VARCHAR2(25);
1950: l_pk NUMBER(15);
1951: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

Line 2137: v_person_id IGS_PE_PERSON.person_id%TYPE;

2133: v_course_attempt_status IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
2134: v_new_course_attempt_status
2135: IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
2136: v_other_detail VARCHAR2(255);
2137: v_person_id IGS_PE_PERSON.person_id%TYPE;
2138: /****************************************************************************
2139: History
2140: Who When Why
2141: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

Line 2266: IGS_PE_PERSON_TYPES PPT

2262: CURSOR c1 IS
2263: -- modified for perf bug 3699560
2264: SELECT 'X'
2265: FROM igs_pe_typ_instances_all PTI,
2266: IGS_PE_PERSON_TYPES PPT
2267: WHERE PPT.system_type = 'STUDENT' AND
2268: ppt.person_type_code = pti.person_type_code
2269: AND pti.COURSE_CD = c_ps_att_rec.COURSE_CD
2270: AND pti.PERSON_ID = c_ps_att_rec.PERSON_ID;

Line 2276: FROM igs_pe_person_types

2272: c1_rec c1%ROWTYPE;
2273:
2274: CURSOR c_former_stdnt IS
2275: SELECT person_type_code
2276: FROM igs_pe_person_types
2277: WHERE system_type = 'FORMER_STUDENT';
2278:
2279: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2280:

Line 2279: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;

2275: SELECT person_type_code
2276: FROM igs_pe_person_types
2277: WHERE system_type = 'FORMER_STUDENT';
2278:
2279: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2280:
2281:
2282: l_rowid VARCHAR2(25);
2283: l_pk NUMBER(15);

Line 2700: IGS_PE_PERSON_TYPES PPT

2696: CURSOR c1 IS
2697: -- modified for perf bug 3699628
2698: SELECT 'X'
2699: FROM igs_pe_typ_instances_all PTI,
2700: IGS_PE_PERSON_TYPES PPT
2701: WHERE PPT.system_type = 'STUDENT' AND
2702: ppt.person_type_code = pti.person_type_code
2703: AND pti.COURSE_CD = c_enps_att_rec.COURSE_CD
2704: AND pti.PERSON_ID = c_enps_att_rec.PERSON_ID;

Line 2709: FROM igs_pe_person_types

2705: c1_rec c1%ROWTYPE;
2706:
2707: CURSOR c_former_stdnt IS
2708: SELECT person_type_code
2709: FROM igs_pe_person_types
2710: WHERE system_type = 'FORMER_STUDENT';
2711:
2712: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2713:

Line 2712: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;

2708: SELECT person_type_code
2709: FROM igs_pe_person_types
2710: WHERE system_type = 'FORMER_STUDENT';
2711:
2712: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2713:
2714: l_rowid VARCHAR2(25);
2715: l_pk NUMBER(15);
2716: BEGIN

Line 3806: -- update IGS_PE_PERSON's tax file number

3802: BEGIN
3803:
3804: FOR c_hecs_opt_rec IN c_hecs_opt LOOP
3805:
3806: -- update IGS_PE_PERSON's tax file number
3807:
3808: Igs_En_Stdntpshecsop_Pkg.UPDATE_ROW(
3809: X_ROWID => c_hecs_opt_rec.ROWID,
3810: X_PERSON_ID => c_hecs_opt_rec.PERSON_ID,