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_CA_INST

Line 55: p_cal_type IN OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE ,

51:
52: FUNCTION derive_unit_outcome_data (
53: p_lgcy_suo_rec IN OUT NOCOPY LGCY_SUO_REC_TYPE ,
54: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%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 ,

Line 56: p_sequence_number IN OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,

52: FUNCTION derive_unit_outcome_data (
53: p_lgcy_suo_rec IN OUT NOCOPY LGCY_SUO_REC_TYPE ,
54: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%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 ,

Line 80: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,

76: */
77: FUNCTION validate_suao_db_cons (
78: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
79: p_lgcy_suo_rec IN LGCY_SUO_REC_TYPE ,
80: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,
81: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
82: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,
83: x_return_status OUT NOCOPY VARCHAR2,
84: p_uoo_id IN IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE

Line 81: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,

77: FUNCTION validate_suao_db_cons (
78: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
79: p_lgcy_suo_rec IN LGCY_SUO_REC_TYPE ,
80: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,
81: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
82: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,
83: x_return_status OUT NOCOPY VARCHAR2,
84: p_uoo_id IN IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE
85: )

Line 112: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,

108: */
109:
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: );

Line 113: p_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,

109:
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:

Line 236: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;

232: IS
233: l_api_name CONSTANT VARCHAR2(30) := 'create_unit_outcome' ;
234: l_api_version CONSTANT NUMBER := 1.0 ;
235: l_person_id IGS_PE_PERSON.PERSON_ID%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 ;

Line 237: l_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;

233: l_api_name CONSTANT VARCHAR2(30) := 'create_unit_outcome' ;
234: l_api_version CONSTANT NUMBER := 1.0 ;
235: l_person_id IGS_PE_PERSON.PERSON_ID%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 ;

Line 959: p_cal_type IN OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE ,

955:
956: FUNCTION derive_unit_outcome_data (
957: p_lgcy_suo_rec IN OUT NOCOPY LGCY_SUO_REC_TYPE ,
958: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%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 ,

Line 960: p_sequence_number IN OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,

956: FUNCTION derive_unit_outcome_data (
957: p_lgcy_suo_rec IN OUT NOCOPY LGCY_SUO_REC_TYPE ,
958: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%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 ,

Line 1380: l_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE ;

1376: AND gsgt.to_version_number = cp_gs_ver_num;
1377:
1378: rec_cur_cop CUR_COP%ROWTYPE ;
1379: l_grade IGS_AS_GRD_SCH_TRN.TO_GRADE%TYPE ;
1380: l_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE ;
1381: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
1382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
1383: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE ;
1384: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE ;

Line 1381: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;

1377:
1378: rec_cur_cop CUR_COP%ROWTYPE ;
1379: l_grade IGS_AS_GRD_SCH_TRN.TO_GRADE%TYPE ;
1380: l_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE ;
1381: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
1382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
1383: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE ;
1384: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE ;
1385: l_message_name VARCHAR2(1000) ;

Line 1382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;

1378: rec_cur_cop CUR_COP%ROWTYPE ;
1379: l_grade IGS_AS_GRD_SCH_TRN.TO_GRADE%TYPE ;
1380: l_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE ;
1381: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
1382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
1383: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE ;
1384: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE ;
1385: l_message_name VARCHAR2(1000) ;
1386:

Line 1383: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE ;

1379: l_grade IGS_AS_GRD_SCH_TRN.TO_GRADE%TYPE ;
1380: l_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE ;
1381: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
1382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
1383: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE ;
1384: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE ;
1385: l_message_name VARCHAR2(1000) ;
1386:
1387: BEGIN

Line 1384: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE ;

1380: l_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE ;
1381: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
1382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
1383: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE ;
1384: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE ;
1385: l_message_name VARCHAR2(1000) ;
1386:
1387: BEGIN
1388:

Line 1449: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,

1445:
1446: FUNCTION validate_suao_db_cons (
1447: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1448: p_lgcy_suo_rec IN LGCY_SUO_REC_TYPE ,
1449: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,
1450: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
1451: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: p_uoo_id IN IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE

Line 1450: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,

1446: FUNCTION validate_suao_db_cons (
1447: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1448: p_lgcy_suo_rec IN LGCY_SUO_REC_TYPE ,
1449: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,
1450: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
1451: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: p_uoo_id IN IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE
1454: )

Line 1816: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,

1812: END validate_unit_outcome;
1813:
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: )

Line 1817: p_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,

1813:
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: /************************************************************************************************************************