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_GEN_006 dependencies on IGS_AS_SU_STMPTOUT

Line 321: FROM igs_as_su_stmptout_all suao

317: AND sua.location_cd LIKE cp_location_cd
318: AND sua.unit_class LIKE cp_unit_class
319: AND NOT EXISTS (
320: SELECT 1
321: FROM igs_as_su_stmptout_all suao
322: WHERE suao.person_id = sua.person_id
323: AND suao.course_cd = sua.course_cd
324: AND suao.uoo_id = sua.uoo_id)
325: AND uv.unit_cd = sua.unit_cd

Line 380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,

376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,
384: p_grade igs_as_su_stmptout.grade%TYPE,

Line 381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,

377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,
384: p_grade igs_as_su_stmptout.grade%TYPE,
385: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,

Line 382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,

378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,
384: p_grade igs_as_su_stmptout.grade%TYPE,
385: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
386: p_uoo_id igs_en_su_attempt.uoo_id%TYPE

Line 383: p_version_number igs_as_su_stmptout.version_number%TYPE,

379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,
384: p_grade igs_as_su_stmptout.grade%TYPE,
385: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
386: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
387: ) IS

Line 384: p_grade igs_as_su_stmptout.grade%TYPE,

380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,
384: p_grade igs_as_su_stmptout.grade%TYPE,
385: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
386: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
387: ) IS
388: --

Line 385: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,

381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,
384: p_grade igs_as_su_stmptout.grade%TYPE,
385: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
386: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
387: ) IS
388: --
389: CURSOR cur_person_detail (cp_person_id NUMBER) IS

Line 428: igs_as_su_stmptout_pkg.insert_row (

424: --
425: fnd_file.put_line (fnd_file.log, rec_person_detail.party_number || '; ' || p_course_cd || '; ' || p_uoo_id || '; ' || p_unit_cd || '; ' || p_cal_type || '; ' || p_ci_sequence_number);
426: --
427: SAVEPOINT s_before_suao_creation;
428: igs_as_su_stmptout_pkg.insert_row (
429: x_rowid => x_rowid,
430: x_org_id => p_org_id,
431: x_person_id => p_person_id,
432: x_course_cd => p_course_cd,

Line 527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,

523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
530: p_version_number igs_as_su_stmptout.version_number%TYPE,
531: p_grade igs_as_su_stmptout.grade%TYPE,

Line 528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,

524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
530: p_version_number igs_as_su_stmptout.version_number%TYPE,
531: p_grade igs_as_su_stmptout.grade%TYPE,
532: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,

Line 529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,

525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
530: p_version_number igs_as_su_stmptout.version_number%TYPE,
531: p_grade igs_as_su_stmptout.grade%TYPE,
532: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
533: j BINARY_INTEGER,

Line 530: p_version_number igs_as_su_stmptout.version_number%TYPE,

526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
530: p_version_number igs_as_su_stmptout.version_number%TYPE,
531: p_grade igs_as_su_stmptout.grade%TYPE,
532: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
533: j BINARY_INTEGER,
534: p_uoo_id igs_en_su_attempt.uoo_id%TYPE

Line 531: p_grade igs_as_su_stmptout.grade%TYPE,

527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
530: p_version_number igs_as_su_stmptout.version_number%TYPE,
531: p_grade igs_as_su_stmptout.grade%TYPE,
532: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
533: j BINARY_INTEGER,
534: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
535: ) IS

Line 532: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,

528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
530: p_version_number igs_as_su_stmptout.version_number%TYPE,
531: p_grade igs_as_su_stmptout.grade%TYPE,
532: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
533: j BINARY_INTEGER,
534: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
535: ) IS
536: --