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_PR_UPLOAD_EXT_RESULTS dependencies on IGS_EN_STDNT_PS_ATT

Line 35: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

31: FROM hz_parties hz
32: WHERE hz.party_number = cp_person_number;
33:
34: CURSOR cur_spa_exists (
35: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
36: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
37: ) IS
38: SELECT 'X'
39: FROM igs_en_stdnt_ps_att spa

Line 36: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE

32: WHERE hz.party_number = cp_person_number;
33:
34: CURSOR cur_spa_exists (
35: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
36: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
37: ) IS
38: SELECT 'X'
39: FROM igs_en_stdnt_ps_att spa
40: WHERE spa.person_id = cp_person_id

Line 39: FROM igs_en_stdnt_ps_att spa

35: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
36: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
37: ) IS
38: SELECT 'X'
39: FROM igs_en_stdnt_ps_att spa
40: WHERE spa.person_id = cp_person_id
41: AND spa.course_cd = cp_course_cd;
42:
43: CURSOR cur_ci_exists (

Line 55: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

51: AND ci.cal_type = ct.cal_type
52: AND ct.s_cal_cat = 'LOAD';
53:
54: CURSOR cur_org_stat_type (
55: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
56: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
57: cp_stat_type igs_pr_stat_type.stat_type%TYPE
58: ) IS
59: SELECT ost.timeframe,

Line 56: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

52: AND ct.s_cal_cat = 'LOAD';
53:
54: CURSOR cur_org_stat_type (
55: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
56: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
57: cp_stat_type igs_pr_stat_type.stat_type%TYPE
58: ) IS
59: SELECT ost.timeframe,
60: stty.closed_ind,

Line 62: FROM igs_en_stdnt_ps_att spa,

58: ) IS
59: SELECT ost.timeframe,
60: stty.closed_ind,
61: stty.derivation
62: FROM igs_en_stdnt_ps_att spa,
63: igs_ps_ver pv,
64: igs_pr_org_stat ost,
65: igs_pr_stat_type stty
66: WHERE spa.person_id = cp_person_id

Line 444: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

440: FROM hz_parties hz
441: WHERE hz.party_number = cp_person_number;
442:
443: CURSOR c_spa (
444: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
445: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
446: ) IS
447: SELECT spa.ROWID,
448: spa.course_attempt_status

Line 445: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE

441: WHERE hz.party_number = cp_person_number;
442:
443: CURSOR c_spa (
444: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
445: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
446: ) IS
447: SELECT spa.ROWID,
448: spa.course_attempt_status
449: FROM igs_en_stdnt_ps_att spa

Line 449: FROM igs_en_stdnt_ps_att spa

445: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
446: ) IS
447: SELECT spa.ROWID,
448: spa.course_attempt_status
449: FROM igs_en_stdnt_ps_att spa
450: WHERE spa.person_id = cp_person_id
451: AND spa.course_cd = cp_course_cd;
452:
453: l_person_id hz_parties.party_id%TYPE;

Line 455: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

451: AND spa.course_cd = cp_course_cd;
452:
453: l_person_id hz_parties.party_id%TYPE;
454: l_rowid ROWID;
455: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
456: BEGIN
457: p_error_code := NULL;
458: -- Check the Person Number relates to a valid Person/Party ID
459: OPEN c_parties (p_person_number);

Line 685: p_course_rqrmnts_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE

681: PROCEDURE update_spa (
682: errbuf OUT NOCOPY VARCHAR2,
683: retcode OUT NOCOPY NUMBER,
684: p_rowid IN ROWID,
685: p_course_rqrmnts_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE
686: ) IS
687:
688: /****************************************************************************************************************
689: || Created By : dlarsen

Line 697: || sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

693: || This process can be called from upload_external_completion.
694: || Known limitations, enhancements or remarks :
695: || Change History :
696: || Who When What
697: || sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
698: || (reverse chronological order - newest change first)
699: ****************************************************************************************************************/
700:
701: CURSOR c_spa (

Line 705: FROM igs_en_stdnt_ps_att spa

701: CURSOR c_spa (
702: cp_rowid ROWID
703: ) IS
704: SELECT spa.*
705: FROM igs_en_stdnt_ps_att spa
706: WHERE spa.ROWID = cp_rowid
707: FOR UPDATE NOWAIT;
708: BEGIN
709: retcode := 0;

Line 712: igs_en_stdnt_ps_att_pkg.update_row (

708: BEGIN
709: retcode := 0;
710:
711: FOR v_spa_rec IN c_spa (p_rowid) LOOP
712: igs_en_stdnt_ps_att_pkg.update_row (
713: x_mode => 'R',
714: x_rowid => p_rowid,
715: x_person_id => v_spa_rec.person_id,
716: x_course_cd => v_spa_rec.course_cd,