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_SUAO_LGCY_PUB dependencies on IGS_EN_SU_ATTEMPT

Line 59: p_unit_attempt_status OUT NOCOPY IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,

55: p_cal_type IN OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE ,
56: p_sequence_number IN OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
57: p_start_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ,
58: p_end_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%TYPE ,
59: p_unit_attempt_status OUT NOCOPY IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,
60: p_translated_grading_schema_cd OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADING_SCHEMA_CD%TYPE ,
61: p_translated_version_number OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,
62: p_translated_grade OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADE%TYPE ,
63: p_translated_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_DT%TYPE ,

Line 97: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE

93: */
94:
95: FUNCTION validate_unit_outcome (
96: p_lgcy_suo_rec LGCY_SUO_REC_TYPE ,
97: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE
98: )
99:
100: RETURN BOOLEAN ;
101:

Line 114: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,

110: PROCEDURE create_post_unit_outcome (
111: p_person_id IGS_PE_PERSON.PERSON_ID%TYPE ,
112: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
113: p_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
114: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,
115: p_lgcy_suo_rec LGCY_SUO_REC_TYPE
116: );
117:
118:

Line 240: l_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ;

236: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
237: l_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
238: l_start_dt IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ;
239: l_end_dt IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%TYPE ;
240: l_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ;
241: l_translated_grading_schema_cd IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADING_SCHEMA_CD%TYPE ;
242: l_translated_version_number IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ;
243: l_translated_grade IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADE%TYPE ;
244: l_translated_dt IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_DT%TYPE ;

Line 963: p_unit_attempt_status OUT NOCOPY IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,

959: p_cal_type IN OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE ,
960: p_sequence_number IN OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
961: p_start_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ,
962: p_end_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%TYPE ,
963: p_unit_attempt_status OUT NOCOPY IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,
964: p_translated_grading_schema_cd OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADING_SCHEMA_CD%TYPE ,
965: p_translated_version_number OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,
966: p_translated_grade OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADE%TYPE ,
967: p_translated_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_DT%TYPE ,

Line 1058: igs_en_su_attempt_all su

1054: SELECT
1055: unit_attempt_status,
1056: uoo_id
1057: FROM
1058: igs_en_su_attempt_all su
1059: WHERE
1060: su.person_id = p_person_id
1061: AND su.course_cd = p_lgcy_suo_rec.program_cd
1062: AND su.unit_cd = p_lgcy_suo_rec.unit_cd

Line 1110: igs_en_su_attempt_all en

1106: SELECT
1107: ugs.grading_schema_code ,
1108: ugs.grd_schm_version_number
1109: FROM igs_ps_usec_grd_schm ugs ,
1110: igs_en_su_attempt_all en
1111: WHERE
1112: ugs.default_flag = 'Y' AND
1113: ugs.uoo_id = en.uoo_id AND
1114: en.person_id = p_person_id AND

Line 1131: igs_en_su_attempt_all en

1127: ugs.grading_schema_code ,
1128: ugs.grd_schm_version_number
1129: FROM
1130: igs_ps_unit_grd_schm ugs ,
1131: igs_en_su_attempt_all en
1132: WHERE
1133: ugs.default_flag = 'Y' AND
1134: ugs.unit_code = en.unit_cd AND
1135: ugs.unit_version_number = en.version_number AND

Line 1338: igs_en_su_attempt sua,

1334: SELECT
1335: cop.grading_schema_cd,
1336: cop.gs_version_number
1337: FROM
1338: igs_en_su_attempt sua,
1339: igs_en_stdnt_ps_att sca,
1340: igs_ps_unit_ofr_opt uoo,
1341: igs_ps_ofr_pat cop
1342: WHERE

Line 1508: Check whether foreign key with table igs_en_su_attempt_all exists.

1504:
1505: /*************************************** Validation 2 ******************************************/
1506: gen_log_info('Start of Validation 2');
1507: /*
1508: Check whether foreign key with table igs_en_su_attempt_all exists.
1509: */
1510:
1511: IF NOT igs_en_su_attempt_pkg.get_pk_for_validation (
1512: X_PERSON_ID => p_person_id ,

Line 1511: IF NOT igs_en_su_attempt_pkg.get_pk_for_validation (

1507: /*
1508: Check whether foreign key with table igs_en_su_attempt_all exists.
1509: */
1510:
1511: IF NOT igs_en_su_attempt_pkg.get_pk_for_validation (
1512: X_PERSON_ID => p_person_id ,
1513: X_COURSE_CD => p_lgcy_suo_rec.program_cd ,
1514: X_UOO_ID => p_uoo_id
1515: )

Line 1518: Foreign key with the table igs_en_su_attempt_all does not exists.

1514: X_UOO_ID => p_uoo_id
1515: )
1516: THEN
1517: /*
1518: Foreign key with the table igs_en_su_attempt_all does not exists.
1519: Set an error message to stack and set x_return_status to 'E' and proceed
1520: to the next step
1521: */
1522:

Line 1761: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE

1757: END validate_suao_db_cons;
1758:
1759: FUNCTION validate_unit_outcome (
1760: p_lgcy_suo_rec LGCY_SUO_REC_TYPE ,
1761: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE
1762: )
1763:
1764: /************************************************************************************************************************
1765: ||Created By : Aiyer

Line 1818: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,

1814: PROCEDURE create_post_unit_outcome (
1815: p_person_id IGS_PE_PERSON.PERSON_ID%TYPE ,
1816: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
1817: p_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
1818: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,
1819: p_lgcy_suo_rec LGCY_SUO_REC_TYPE
1820: )
1821: /************************************************************************************************************************
1822: ||Created By : Aiyer

Line 1845: -- update the table igs_en_su_attempt_all to the unit_attempt_status of 'COMPLETED'

1841: gen_log_info('Start of Create_post_unit_outcome.Validation 1');
1842:
1843: IF p_lgcy_suo_rec.finalised_outcome_ind = 'Y' AND p_unit_attempt_status = 'ENROLLED' THEN
1844:
1845: -- update the table igs_en_su_attempt_all to the unit_attempt_status of 'COMPLETED'
1846: UPDATE
1847: IGS_EN_SU_ATTEMPT_ALL su
1848: SET
1849: unit_attempt_status = 'COMPLETED'

Line 1847: IGS_EN_SU_ATTEMPT_ALL su

1843: IF p_lgcy_suo_rec.finalised_outcome_ind = 'Y' AND p_unit_attempt_status = 'ENROLLED' THEN
1844:
1845: -- update the table igs_en_su_attempt_all to the unit_attempt_status of 'COMPLETED'
1846: UPDATE
1847: IGS_EN_SU_ATTEMPT_ALL su
1848: SET
1849: unit_attempt_status = 'COMPLETED'
1850: WHERE
1851: su.person_id = p_person_id