2: /* $Header: IGSENA9S.pls 120.1 2006/01/17 03:32:10 rnirwani noship $ */
3: /*#
4: * The Student Program Attempt Term Record Import process is a public API designed for use in populating
5: * rows with data during a system conversion. This API is also used by the Legacy Import Process for
6: * Enrollment and Records when importing rows from the IGS_EN_LGY_SPAT_INT interface table.
7: * @rep:scope public
8: * @rep:product IGS
9: * @rep:lifecycle active
10: * @rep:displayname Import Legacy Student Term Record
13: */
14: -- irep annotations above.
15:
16: TYPE spat_rec_type IS RECORD (
17: person_number igs_en_lgy_spat_int.person_number%TYPE,
18: program_cd igs_en_lgy_spat_int.program_cd%TYPE,
19: program_version igs_en_lgy_spat_int.program_version%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
14: -- irep annotations above.
15:
16: TYPE spat_rec_type IS RECORD (
17: person_number igs_en_lgy_spat_int.person_number%TYPE,
18: program_cd igs_en_lgy_spat_int.program_cd%TYPE,
19: program_version igs_en_lgy_spat_int.program_version%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
15:
16: TYPE spat_rec_type IS RECORD (
17: person_number igs_en_lgy_spat_int.person_number%TYPE,
18: program_cd igs_en_lgy_spat_int.program_cd%TYPE,
19: program_version igs_en_lgy_spat_int.program_version%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
16: TYPE spat_rec_type IS RECORD (
17: person_number igs_en_lgy_spat_int.person_number%TYPE,
18: program_cd igs_en_lgy_spat_int.program_cd%TYPE,
19: program_version igs_en_lgy_spat_int.program_version%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
17: person_number igs_en_lgy_spat_int.person_number%TYPE,
18: program_cd igs_en_lgy_spat_int.program_cd%TYPE,
19: program_version igs_en_lgy_spat_int.program_version%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
18: program_cd igs_en_lgy_spat_int.program_cd%TYPE,
19: program_version igs_en_lgy_spat_int.program_version%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
19: program_version igs_en_lgy_spat_int.program_version%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
20: key_program_flag igs_en_lgy_spat_int.key_program_flag%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
21: acad_cal_type igs_en_lgy_spat_int.acad_cal_type%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
22: location_cd igs_en_lgy_spat_int.location_cd%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
23: attendance_mode igs_en_lgy_spat_int.attendance_mode%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
24: attendance_type igs_en_lgy_spat_int.attendance_type%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
25: class_standing igs_en_lgy_spat_int.class_standing%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
26: fee_cat igs_en_lgy_spat_int.fee_cat%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
27: term_cal_alternate_cd igs_en_lgy_spat_int.term_cal_alternate_cd%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
28: attribute_category igs_en_lgy_spat_int.attribute_category%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
29: attribute1 igs_en_lgy_spat_int.attribute1%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
30: attribute2 igs_en_lgy_spat_int.attribute2%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
31: attribute3 igs_en_lgy_spat_int.attribute3%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
32: attribute4 igs_en_lgy_spat_int.attribute4%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
33: attribute5 igs_en_lgy_spat_int.attribute5%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
34: attribute6 igs_en_lgy_spat_int.attribute6%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
35: attribute7 igs_en_lgy_spat_int.attribute7%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
36: attribute8 igs_en_lgy_spat_int.attribute8%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
37: attribute9 igs_en_lgy_spat_int.attribute9%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
38: attribute10 igs_en_lgy_spat_int.attribute10%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
46: attribute18 igs_en_lgy_spat_int.attribute18%TYPE,
39: attribute11 igs_en_lgy_spat_int.attribute11%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
46: attribute18 igs_en_lgy_spat_int.attribute18%TYPE,
47: attribute19 igs_en_lgy_spat_int.attribute19%TYPE,
40: attribute12 igs_en_lgy_spat_int.attribute12%TYPE,
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
46: attribute18 igs_en_lgy_spat_int.attribute18%TYPE,
47: attribute19 igs_en_lgy_spat_int.attribute19%TYPE,
48: attribute20 igs_en_lgy_spat_int.attribute20%TYPE );
41: attribute13 igs_en_lgy_spat_int.attribute13%TYPE,
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
46: attribute18 igs_en_lgy_spat_int.attribute18%TYPE,
47: attribute19 igs_en_lgy_spat_int.attribute19%TYPE,
48: attribute20 igs_en_lgy_spat_int.attribute20%TYPE );
49:
42: attribute14 igs_en_lgy_spat_int.attribute14%TYPE,
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
46: attribute18 igs_en_lgy_spat_int.attribute18%TYPE,
47: attribute19 igs_en_lgy_spat_int.attribute19%TYPE,
48: attribute20 igs_en_lgy_spat_int.attribute20%TYPE );
49:
50: -- irep annotations below
43: attribute15 igs_en_lgy_spat_int.attribute15%TYPE,
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
46: attribute18 igs_en_lgy_spat_int.attribute18%TYPE,
47: attribute19 igs_en_lgy_spat_int.attribute19%TYPE,
48: attribute20 igs_en_lgy_spat_int.attribute20%TYPE );
49:
50: -- irep annotations below
51: /*#
44: attribute16 igs_en_lgy_spat_int.attribute16%TYPE,
45: attribute17 igs_en_lgy_spat_int.attribute17%TYPE,
46: attribute18 igs_en_lgy_spat_int.attribute18%TYPE,
47: attribute19 igs_en_lgy_spat_int.attribute19%TYPE,
48: attribute20 igs_en_lgy_spat_int.attribute20%TYPE );
49:
50: -- irep annotations below
51: /*#
52: * The Student Program Attempt Term Record Import process is a public API designed for use in populating
50: -- irep annotations below
51: /*#
52: * The Student Program Attempt Term Record Import process is a public API designed for use in populating
53: * rows with data during a system conversion. This API is also used by the Legacy Import Process for
54: * Enrollment and Records when importing rows from the IGS_EN_LGY_SPAT_INT interface table.
55: * @param p_api_version The version number will be used to compare with claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
56: * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
57: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
58: * @param p_validation_level Public API will always perform full level of validation.
55: * @param p_api_version The version number will be used to compare with claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
56: * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
57: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
58: * @param p_validation_level Public API will always perform full level of validation.
59: * @param p_spat_rec Legacy Student Program Attempt Term record type. Refer to IGS_EN_LGY_SPAT_INT for detail column descriptions.
60: * @param x_return_status The return status values are as follows; Success - FND_API.G_RET_STS_SUCCESS ; Error - FND_API.G_RET_STS_ERROR ; Unexpected error - FND_API.G_RET_STS_UNEXP_ERROR.
61: * @param x_msg_count Message count.
62: * @param x_msg_data Message data.
63: * @rep:scope public