1 PACKAGE IGS_EN_SUA_LGCY_PUB AS
2 /* $Header: IGSENA4S.pls 120.2 2006/01/17 03:28:25 rnirwani ship $ */
3 /*#
4 * The Student Unit Attempt Import process is a public API designed for use in populating rows with
5 * data during a system conversion. This API is also used by the Legacy Import Process for Enrollment
6 * and Records when importing rows from the IGS_EN_LGCY_SUA_INT interface table.
7 * @rep:scope public
8 * @rep:product IGS
9 * @rep:lifecycle active
10 * @rep:displayname Import Legacy Student Unit Attempt
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY IGS_STUDENT_UNIT
13 */
14 -- irep annotations above.
15
16 TYPE sua_dtls_rec_type IS RECORD (
17 person_number IGS_EN_LGCY_SUA_INT.person_number%TYPE ,
18 program_cd IGS_EN_LGCY_SUA_INT.program_cd%TYPE ,
19 unit_cd IGS_EN_LGCY_SUA_INT.unit_cd%TYPE ,
20 version_number IGS_EN_LGCY_SUA_INT.version_number%TYPE ,
21 teach_calendar_alternate_code IGS_EN_LGCY_SUA_INT.teach_calendar_alternate_code%TYPE ,
22 location_cd IGS_EN_LGCY_SUA_INT.location_cd%TYPE ,
23 unit_class IGS_EN_LGCY_SUA_INT.unit_class%TYPE ,
24 enrolled_dt IGS_EN_LGCY_SUA_INT.enrolled_dt%TYPE ,
25 waitlisted_dt IGS_EN_LGCY_SUA_INT.waitlisted_dt%TYPE ,
26 dropped_ind IGS_EN_LGCY_SUA_INT.dropped_ind%TYPE ,
27 discontinued_dt IGS_EN_LGCY_SUA_INT.discontinued_dt%TYPE ,
28 administrative_unit_status IGS_EN_LGCY_SUA_INT.administrative_unit_status%TYPE ,
29 dcnt_reason_cd IGS_EN_LGCY_SUA_INT.dcnt_reason_cd%TYPE ,
30 no_assessment_ind IGS_EN_LGCY_SUA_INT.no_assessment_ind%TYPE ,
31 override_enrolled_cp IGS_EN_LGCY_SUA_INT.override_enrolled_cp%TYPE ,
32 override_achievable_cp IGS_EN_LGCY_SUA_INT.override_achievable_cp%TYPE ,
33 grading_schema_code IGS_EN_LGCY_SUA_INT.grading_schema_code%TYPE ,
34 gs_version_number IGS_EN_LGCY_SUA_INT.gs_version_number%TYPE ,
35 subtitle IGS_EN_LGCY_SUA_INT.subtitle%TYPE ,
36 student_career_transcript IGS_EN_LGCY_SUA_INT.student_career_transcript%TYPE ,
37 student_career_statistics IGS_EN_LGCY_SUA_INT.student_career_statistics%TYPE ,
38 transfer_dt IGS_EN_LGCY_SUA_INT.transfer_dt%TYPE ,
39 transfer_program_cd IGS_EN_LGCY_SUA_INT.transfer_program_cd%TYPE ,
40 outcome_dt IGS_EN_LGCY_SUA_INT.outcome_dt%TYPE ,
41 mark IGS_EN_LGCY_SUA_INT.mark%TYPE ,
42 outcome_grading_schema_code IGS_EN_LGCY_SUA_INT.outcome_grading_schema_code%TYPE ,
43 outcome_gs_version_number IGS_EN_LGCY_SUA_INT.outcome_gs_version_number%TYPE ,
44 grade IGS_EN_LGCY_SUA_INT.grade%TYPE ,
45 incomp_deadline_date IGS_EN_LGCY_SUA_INT.incomp_deadline_date%TYPE ,
46 incomp_default_grade IGS_EN_LGCY_SUA_INT.incomp_default_grade%TYPE ,
47 incomp_default_mark IGS_EN_LGCY_SUA_INT.incomp_default_mark%TYPE ,
48 --added by rvangala 01-OCT-2003. Enh Bug# 3052432
49 core_indicator IGS_EN_LGCY_SUA_INT.core_indicator_code%TYPE,
50 attribute_category IGS_EN_LGCY_SUA_INT.attribute_category%TYPE ,
51 attribute1 IGS_EN_LGCY_SUA_INT.attribute1%TYPE ,
52 attribute2 IGS_EN_LGCY_SUA_INT.attribute2%TYPE ,
53 attribute3 IGS_EN_LGCY_SUA_INT.attribute3%TYPE ,
54 attribute4 IGS_EN_LGCY_SUA_INT.attribute4%TYPE ,
55 attribute5 IGS_EN_LGCY_SUA_INT.attribute5%TYPE ,
56 attribute6 IGS_EN_LGCY_SUA_INT.attribute6%TYPE ,
57 attribute7 IGS_EN_LGCY_SUA_INT.attribute7%TYPE ,
58 attribute8 IGS_EN_LGCY_SUA_INT.attribute8%TYPE ,
59 attribute9 IGS_EN_LGCY_SUA_INT.attribute9%TYPE ,
60 attribute10 IGS_EN_LGCY_SUA_INT.attribute10%TYPE ,
61 attribute11 IGS_EN_LGCY_SUA_INT.attribute11%TYPE ,
62 attribute12 IGS_EN_LGCY_SUA_INT.attribute12%TYPE ,
63 attribute13 IGS_EN_LGCY_SUA_INT.attribute13%TYPE ,
64 attribute14 IGS_EN_LGCY_SUA_INT.attribute14%TYPE ,
65 attribute15 IGS_EN_LGCY_SUA_INT.attribute15%TYPE ,
66 attribute16 IGS_EN_LGCY_SUA_INT.attribute16%TYPE ,
67 attribute17 IGS_EN_LGCY_SUA_INT.attribute17%TYPE ,
68 attribute18 IGS_EN_LGCY_SUA_INT.attribute18%TYPE ,
69 attribute19 IGS_EN_LGCY_SUA_INT.attribute19%TYPE ,
70 attribute20 IGS_EN_LGCY_SUA_INT.attribute20%TYPE
71 );
72
73 -- irep annotations below.
74 /*#
75 * The Student Unit Attempt Import process is a public API designed for use in populating rows with
76 * data during a system conversion. This API is also used by the Legacy Import Process for Enrollment
77 * and Records when importing rows from the IGS_EN_LGCY_SUA_INT interface table.
78 * @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.
79 * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
80 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
81 * @param p_validation_level Public API will always perform full level of validation.
82 * @param p_sua_dtls_rec Legacy Student Unit Attempt record type. Refer to IGS_EN_LGCY_SUA_INT for detail column descriptions.
83 * @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.
84 * @param x_msg_count Message count.
85 * @param x_msg_data Message data.
86 * @rep:scope public
87 * @rep:lifecycle active
88 * @rep:displayname Import Legacy Student Unit Attempt
89 */
90 PROCEDURE create_sua ( p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
94 p_sua_dtls_rec IN sua_dtls_rec_type ,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2);
98
99
100 END igs_en_sua_lgcy_pub;