APPS.IGS_HE_IMPORT_POPDLHE dependencies on IGS_HE_STDNT_DLHE

Line 35: updates or inserts corresponding records in igs_he_stdnt_dlhe table

31: /******************************************************************
32: Created By : Jonathan Baber
33: Date Created By : 24-Aug-05
34: Purpose : Processes records from IGS_HE_POPDLHE_INTS interface table and
35: updates or inserts corresponding records in igs_he_stdnt_dlhe table
36: Known limitations,enhancements,remarks:
37: Change History
38: Who When What
39: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate

Line 50: CURSOR c_dlhe_rec(cp_person_id igs_he_stdnt_dlhe.person_id%TYPE) IS

46:
47:
48: -- Cursor Defs
49: -- cursor to retrieve student dlhe rec infor
50: CURSOR c_dlhe_rec(cp_person_id igs_he_stdnt_dlhe.person_id%TYPE) IS
51: SELECT dlhe.rowid, dlhe.*
52: FROM igs_he_stdnt_dlhe dlhe
53: WHERE person_id = cp_person_id
54: AND submission_name = p_submission_name

Line 52: FROM igs_he_stdnt_dlhe dlhe

48: -- Cursor Defs
49: -- cursor to retrieve student dlhe rec infor
50: CURSOR c_dlhe_rec(cp_person_id igs_he_stdnt_dlhe.person_id%TYPE) IS
51: SELECT dlhe.rowid, dlhe.*
52: FROM igs_he_stdnt_dlhe dlhe
53: WHERE person_id = cp_person_id
54: AND submission_name = p_submission_name
55: AND return_name = p_return_name;
56:

Line 69: l_qualified_teacher igs_he_stdnt_dlhe.qualified_teacher%TYPE;

65: AND qual.qual_period_code = cp_qual_period;
66:
67:
68: -- Variable Defs
69: l_qualified_teacher igs_he_stdnt_dlhe.qualified_teacher%TYPE;
70: l_pt_study igs_he_stdnt_dlhe.pt_study%TYPE;
71: l_qual_period igs_he_stdnt_dlhe.qual_period_code%TYPE;
72: l_person_id igs_he_stdnt_dlhe.person_id%TYPE;
73: l_qual_dets c_qual_dets%ROWTYPE;

Line 70: l_pt_study igs_he_stdnt_dlhe.pt_study%TYPE;

66:
67:
68: -- Variable Defs
69: l_qualified_teacher igs_he_stdnt_dlhe.qualified_teacher%TYPE;
70: l_pt_study igs_he_stdnt_dlhe.pt_study%TYPE;
71: l_qual_period igs_he_stdnt_dlhe.qual_period_code%TYPE;
72: l_person_id igs_he_stdnt_dlhe.person_id%TYPE;
73: l_qual_dets c_qual_dets%ROWTYPE;
74: l_upd_qual_dets c_qual_dets%ROWTYPE;

Line 71: l_qual_period igs_he_stdnt_dlhe.qual_period_code%TYPE;

67:
68: -- Variable Defs
69: l_qualified_teacher igs_he_stdnt_dlhe.qualified_teacher%TYPE;
70: l_pt_study igs_he_stdnt_dlhe.pt_study%TYPE;
71: l_qual_period igs_he_stdnt_dlhe.qual_period_code%TYPE;
72: l_person_id igs_he_stdnt_dlhe.person_id%TYPE;
73: l_qual_dets c_qual_dets%ROWTYPE;
74: l_upd_qual_dets c_qual_dets%ROWTYPE;
75: l_dlhe_rec c_dlhe_rec%ROWTYPE;

Line 72: l_person_id igs_he_stdnt_dlhe.person_id%TYPE;

68: -- Variable Defs
69: l_qualified_teacher igs_he_stdnt_dlhe.qualified_teacher%TYPE;
70: l_pt_study igs_he_stdnt_dlhe.pt_study%TYPE;
71: l_qual_period igs_he_stdnt_dlhe.qual_period_code%TYPE;
72: l_person_id igs_he_stdnt_dlhe.person_id%TYPE;
73: l_qual_dets c_qual_dets%ROWTYPE;
74: l_upd_qual_dets c_qual_dets%ROWTYPE;
75: l_dlhe_rec c_dlhe_rec%ROWTYPE;
76: l_sql_stmt VARCHAR2(1000);

Line 201: igs_he_stdnt_dlhe_pkg.update_row(

197: l_qual_period := l_dlhe_rec.qual_period_code;
198: END IF;
199:
200: -- Update record
201: igs_he_stdnt_dlhe_pkg.update_row(
202: x_rowid => l_dlhe_rec.rowid,
203: x_person_id => l_dlhe_rec.person_id,
204: x_submission_name => l_dlhe_rec.submission_name,
205: x_user_return_subclass => l_dlhe_rec.user_return_subclass ,

Line 311: igs_he_stdnt_dlhe_pkg.insert_row(

307: ELSE
308: l_pt_study := 'N';
309: END IF;
310:
311: igs_he_stdnt_dlhe_pkg.insert_row(
312: x_rowid => l_rowid,
313: x_person_id => l_person_id,
314: x_submission_name => p_submission_name,
315: x_user_return_subclass => l_qual_dets.user_return_subclass,