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_AS_ADI_UPLD_PR_PKG dependencies on IGS_HE_EN_SUSA

Line 322: cp_person_id igs_he_en_susa.person_id%TYPE,

318: v_he_rowid VARCHAR2 (25);
319: v_hesa_en_susa_id NUMBER (6, 0);
320: --
321: CURSOR c_susa (
322: cp_person_id igs_he_en_susa.person_id%TYPE,
323: cp_course_cd igs_he_en_susa.course_cd%TYPE,
324: cp_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
325: cp_sequence_number igs_he_en_susa.sequence_number%TYPE,
326: cp_us_version_number igs_he_en_susa.us_version_number%TYPE

Line 323: cp_course_cd igs_he_en_susa.course_cd%TYPE,

319: v_hesa_en_susa_id NUMBER (6, 0);
320: --
321: CURSOR c_susa (
322: cp_person_id igs_he_en_susa.person_id%TYPE,
323: cp_course_cd igs_he_en_susa.course_cd%TYPE,
324: cp_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
325: cp_sequence_number igs_he_en_susa.sequence_number%TYPE,
326: cp_us_version_number igs_he_en_susa.us_version_number%TYPE
327: ) IS

Line 324: cp_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,

320: --
321: CURSOR c_susa (
322: cp_person_id igs_he_en_susa.person_id%TYPE,
323: cp_course_cd igs_he_en_susa.course_cd%TYPE,
324: cp_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
325: cp_sequence_number igs_he_en_susa.sequence_number%TYPE,
326: cp_us_version_number igs_he_en_susa.us_version_number%TYPE
327: ) IS
328: SELECT ROWID,

Line 325: cp_sequence_number igs_he_en_susa.sequence_number%TYPE,

321: CURSOR c_susa (
322: cp_person_id igs_he_en_susa.person_id%TYPE,
323: cp_course_cd igs_he_en_susa.course_cd%TYPE,
324: cp_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
325: cp_sequence_number igs_he_en_susa.sequence_number%TYPE,
326: cp_us_version_number igs_he_en_susa.us_version_number%TYPE
327: ) IS
328: SELECT ROWID,
329: hesa_en_susa_id,

Line 326: cp_us_version_number igs_he_en_susa.us_version_number%TYPE

322: cp_person_id igs_he_en_susa.person_id%TYPE,
323: cp_course_cd igs_he_en_susa.course_cd%TYPE,
324: cp_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
325: cp_sequence_number igs_he_en_susa.sequence_number%TYPE,
326: cp_us_version_number igs_he_en_susa.us_version_number%TYPE
327: ) IS
328: SELECT ROWID,
329: hesa_en_susa_id,
330: person_id,

Line 381: FROM igs_he_en_susa

377: additional_sup_cost,
378: enh_fund_elig_cd,
379: disadv_uplift_factor,
380: year_stu
381: FROM igs_he_en_susa
382: WHERE person_id = cp_person_id
383: AND course_cd = cp_course_cd
384: AND unit_set_cd = cp_unit_set_cd
385: AND sequence_number = cp_sequence_number

Line 390: v_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE;

386: AND us_version_number = cp_us_version_number;
387: --
388: v_susa c_susa%ROWTYPE;
389: p_batch_date DATE := TO_DATE (p_batch_datetime, 'YYYY/MM/DD HH24:MI:SS');
390: v_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE;
391: v_us_version_number igs_he_en_susa.us_version_number%TYPE;
392: v_sequence_number igs_he_en_susa.sequence_number%TYPE;
393: --
394: CURSOR c_upload_outcome_spoi IS

Line 391: v_us_version_number igs_he_en_susa.us_version_number%TYPE;

387: --
388: v_susa c_susa%ROWTYPE;
389: p_batch_date DATE := TO_DATE (p_batch_datetime, 'YYYY/MM/DD HH24:MI:SS');
390: v_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE;
391: v_us_version_number igs_he_en_susa.us_version_number%TYPE;
392: v_sequence_number igs_he_en_susa.sequence_number%TYPE;
393: --
394: CURSOR c_upload_outcome_spoi IS
395: SELECT spoi.user_id,

Line 392: v_sequence_number igs_he_en_susa.sequence_number%TYPE;

388: v_susa c_susa%ROWTYPE;
389: p_batch_date DATE := TO_DATE (p_batch_datetime, 'YYYY/MM/DD HH24:MI:SS');
390: v_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE;
391: v_us_version_number igs_he_en_susa.us_version_number%TYPE;
392: v_sequence_number igs_he_en_susa.sequence_number%TYPE;
393: --
394: CURSOR c_upload_outcome_spoi IS
395: SELECT spoi.user_id,
396: spoi.batch_date,

Line 593: igs_he_en_susa_pkg.insert_row (

589: AND v_load_record_flag = 'Y'
590: AND (v_spoi_rec.yop_grade IS NOT NULL OR v_spoi_rec.yop_mark IS NOT NULL)
591: ) THEN
592: BEGIN
593: igs_he_en_susa_pkg.insert_row (
594: x_mode => 'S',
595: x_rowid => v_he_rowid,
596: x_hesa_en_susa_id => v_hesa_en_susa_id,
597: x_person_id => v_person_id,

Line 677: igs_he_en_susa_pkg.update_row (

673: IF v_load_record_flag = 'W' THEN
674: OPEN c_susa (v_person_id, v_spoi_rec.course_cd, v_unit_set_cd, v_sequence_number, v_us_version_number);
675: FETCH c_susa INTO v_susa;
676: BEGIN
677: igs_he_en_susa_pkg.update_row (
678: x_mode => 'S',
679: x_rowid => v_susa.ROWID,
680: x_hesa_en_susa_id => v_susa.hesa_en_susa_id,
681: x_person_id => v_susa.person_id,

Line 792: p_sequence_number OUT NOCOPY igs_he_en_susa.sequence_number%TYPE,

788: p_load_file_flag OUT NOCOPY VARCHAR2,
789: p_load_record_flag OUT NOCOPY VARCHAR2,
790: p_unit_set_cd OUT NOCOPY igs_as_su_setatmpt.unit_set_cd%TYPE,
791: p_us_version_number OUT NOCOPY igs_as_su_setatmpt.us_version_number%TYPE,
792: p_sequence_number OUT NOCOPY igs_he_en_susa.sequence_number%TYPE,
793: p_mark IN NUMBER,
794: p_grade IN OUT NOCOPY VARCHAR2
795: ) IS
796: --

Line 1233: IF igs_he_en_susa_pkg.get_uk_for_validation (

1229: --
1230: -- Determine action if record already exists
1231: --
1232: BEGIN
1233: IF igs_he_en_susa_pkg.get_uk_for_validation (
1234: x_person_id => p_person_id,
1235: x_course_cd => p_course_cd,
1236: x_unit_set_cd => p_unit_set_cd,
1237: x_sequence_number => p_sequence_number