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_AS_SU_STMPTOUT_ALL

Line 57: p_start_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ,

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 ,
61: p_translated_version_number OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,

Line 58: p_end_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%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 ,
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 ,

Line 60: p_translated_grading_schema_cd OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADING_SCHEMA_CD%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 ,
64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,

Line 61: p_translated_version_number OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_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 ,
64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
65: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,

Line 62: p_translated_grade OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADE%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 ,
64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
65: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
66: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE

Line 63: p_translated_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_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 ,
64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
65: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
66: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
67: )

Line 64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%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 ,
64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
65: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
66: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
67: )
68: RETURN BOOLEAN;

Line 65: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%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 ,
64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
65: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
66: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
67: )
68: RETURN BOOLEAN;
69:

Line 66: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%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 ,
64: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
65: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
66: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
67: )
68: RETURN BOOLEAN;
69:
70:

Line 74: Performs all data integrity validations on the table igs_as_su_stmptout_all

70:
71:
72: /*
73: Function validate_suao_db_cons -
74: Performs all data integrity validations on the table igs_as_su_stmptout_all
75: It is called from the procedure create_unit_outcome.
76: */
77: FUNCTION validate_suao_db_cons (
78: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,

Line 82: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,

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: )
86: RETURN BOOLEAN;

Line 84: p_uoo_id IN IGS_AS_SU_STMPTOUT_ALL.UOO_ID%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: )
86: RETURN BOOLEAN;
87:
88:

Line 106: Performs all the post insert operations on the table IGS_AS_SU_STMPTOUT_ALL.

102:
103:
104: /*
105: Procedure create_post_unit_outcome -
106: Performs all the post insert operations on the table IGS_AS_SU_STMPTOUT_ALL.
107: Called from the procedure create_unit_outcome
108: */
109:
110: PROCEDURE create_post_unit_outcome (

Line 225: || 5. Insert data into table IGS_AS_SU_STMPTOUT_ALL -- direct DML operation in this procedure

221: || 1. Validate the parameters passed to the api -- call function validate_parameters
222: || 2. Derive all the necessary values from the values passed -- call function derive_unit_outcome_data
223: || 3. Validate all the database constraints -- call function validate_suao_db_cons
224: || 4. Validate all the business validations -- call function validate_unit_outcome
225: || 5. Insert data into table IGS_AS_SU_STMPTOUT_ALL -- direct DML operation in this procedure
226: || 6. Perform post insert operations on table IGS_AS_SU_STMPTOUT_ALL -- call procedure create_post_unit_outcome
227: ||Know limitations, enhancements or remarks
228: ||Change History
229: ||Who When What

Line 226: || 6. Perform post insert operations on table IGS_AS_SU_STMPTOUT_ALL -- call procedure create_post_unit_outcome

222: || 2. Derive all the necessary values from the values passed -- call function derive_unit_outcome_data
223: || 3. Validate all the database constraints -- call function validate_suao_db_cons
224: || 4. Validate all the business validations -- call function validate_unit_outcome
225: || 5. Insert data into table IGS_AS_SU_STMPTOUT_ALL -- direct DML operation in this procedure
226: || 6. Perform post insert operations on table IGS_AS_SU_STMPTOUT_ALL -- call procedure create_post_unit_outcome
227: ||Know limitations, enhancements or remarks
228: ||Change History
229: ||Who When What
230: ||(reverse chronological order - newest change first)

Line 238: l_start_dt IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ;

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 ;
242: l_translated_version_number IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ;

Line 239: l_end_dt IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%TYPE ;

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 ;
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 ;

Line 241: l_translated_grading_schema_cd IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADING_SCHEMA_CD%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 ;
245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE ;

Line 242: l_translated_version_number IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_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 ;
245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE ;
246: l_lgcy_suo_rec LGCY_SUO_REC_TYPE ;

Line 243: l_translated_grade IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADE%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 ;
245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE ;
246: l_lgcy_suo_rec LGCY_SUO_REC_TYPE ;
247: l_uoo_id IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE;

Line 244: l_translated_dt IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_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 ;
245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE ;
246: l_lgcy_suo_rec LGCY_SUO_REC_TYPE ;
247: l_uoo_id IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE;
248: l_release_date IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE;

Line 245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%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 ;
245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE ;
246: l_lgcy_suo_rec LGCY_SUO_REC_TYPE ;
247: l_uoo_id IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE;
248: l_release_date IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE;
249: duplicate_record_exists EXCEPTION;

Line 247: l_uoo_id IGS_AS_SU_STMPTOUT_ALL.UOO_ID%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 ;
245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE ;
246: l_lgcy_suo_rec LGCY_SUO_REC_TYPE ;
247: l_uoo_id IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE;
248: l_release_date IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE;
249: duplicate_record_exists EXCEPTION;
250: BEGIN
251: --Standard start of API savepoint

Line 248: l_release_date IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE;

244: l_translated_dt IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_DT%TYPE ;
245: l_number_of_times IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE ;
246: l_lgcy_suo_rec LGCY_SUO_REC_TYPE ;
247: l_uoo_id IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE;
248: l_release_date IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE;
249: duplicate_record_exists EXCEPTION;
250: BEGIN
251: --Standard start of API savepoint
252: SAVEPOINT create_unit_outcome;

Line 337: Derive all the necessary columns eruiqred while importing a ercord in the table igs_as_su_stmptout_all

333:
334: /*************************************** Validation 2 ******************************************/
335:
336: /*
337: Derive all the necessary columns eruiqred while importing a ercord in the table igs_as_su_stmptout_all
338: */
339: gen_log_info('Start of create_unit_outcome.validation 2');
340:
341: IF NOT derive_unit_outcome_data (

Line 407: Insert a record in the table igs_as_su_stmptout_all

403:
404: /*************************************** Validation 5 ******************************************/
405: /*
406:
407: Insert a record in the table igs_as_su_stmptout_all
408:
409: */
410:
411: gen_log_info('Start of create_unit_outcome.validation 5');

Line 413: INSERT INTO IGS_AS_SU_STMPTOUT_ALL

409: */
410:
411: gen_log_info('Start of create_unit_outcome.validation 5');
412:
413: INSERT INTO IGS_AS_SU_STMPTOUT_ALL
414: (
415: PERSON_ID ,
416: COURSE_CD ,
417: UNIT_CD ,

Line 543: Perform Post insert activities on the table igs_as_su_stmptout_all

539:
540: /*************************************** Validation 6 ******************************************/
541:
542: /*
543: Perform Post insert activities on the table igs_as_su_stmptout_all
544: */
545: gen_log_info('Start of create_unit_outcome.validation 6');
546:
547: create_post_unit_outcome (

Line 961: p_start_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ,

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 ,
965: p_translated_version_number OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,

Line 962: p_end_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%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 ,
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 ,

Line 964: p_translated_grading_schema_cd OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADING_SCHEMA_CD%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 ,
968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,

Line 965: p_translated_version_number OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_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 ,
968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
969: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,

Line 966: p_translated_grade OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_GRADE%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 ,
968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
969: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
970: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE

Line 967: p_translated_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_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 ,
968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
969: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
970: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
971: )

Line 968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%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 ,
968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
969: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
970: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
971: )
972: RETURN BOOLEAN

Line 969: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%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 ,
968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
969: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
970: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
971: )
972: RETURN BOOLEAN
973: /*************************************************************************************************************************

Line 970: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%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 ,
968: p_number_of_times OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.NUMBER_TIMES_KEYED%TYPE,
969: p_uoo_id OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.UOO_ID%TYPE,
970: p_release_date OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.RELEASE_DATE%TYPE
971: )
972: RETURN BOOLEAN
973: /*************************************************************************************************************************
974: ||Created By : Aiyer

Line 1451: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,

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: )
1455: RETURN BOOLEAN

Line 1453: p_uoo_id IN IGS_AS_SU_STMPTOUT_ALL.UOO_ID%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: )
1455: RETURN BOOLEAN
1456:
1457: /******************************************************************************************************

Line 1460: ||Purpose : This function performs all data integrity validations on the table igs_as_su_stmptout_all

1456:
1457: /******************************************************************************************************
1458: ||Created By : Aiyer
1459: ||Date Created on : 2002/11/20
1460: ||Purpose : This function performs all data integrity validations on the table igs_as_su_stmptout_all
1461: || It is called from the procedure create_unit_outcome.
1462: ||Know limitations, enhancements or remarks
1463: ||Change History
1464: ||Who When What

Line 1824: ||Purpose : The procedure create_post_unit_outcome performs post insert operations on the table IGS_AS_SU_STMPTOUT_ALL

1820: )
1821: /************************************************************************************************************************
1822: ||Created By : Aiyer
1823: ||Date Created on : 2002/11/26
1824: ||Purpose : The procedure create_post_unit_outcome performs post insert operations on the table IGS_AS_SU_STMPTOUT_ALL
1825: || Called from the procedure create_unit_outcome
1826: ||
1827: ||Know limitations, enhancements or remarks
1828: ||Change History