[Home] [Help]
PACKAGE: APPS.IGS_AS_SUAO_LGCY_PUB
Source
1 PACKAGE igs_as_suao_lgcy_pub AS
2 /* $Header: IGSPAS1S.pls 120.1 2006/01/17 03:52:30 ijeddy noship $ */
3 /*#
4 * The Unit Outcome Legacy import process is a public API designed for use in populating rows with data during a system conversion.
5 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_SUO_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Unit Outcome
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_STUDENT_UNIT
12 */
13 /***********************************************************************************************
14 ||
15 ||Created By: Arun Iyer
16 ||
17 ||Date Created By: 20-11-2002
18 ||
19 ||Purpose: This package creates a student Assessment unit outcome record.
20 ||
21 ||
22 ||Known limitations,enhancements,remarks:
23 ||
24 ||Change History
25 ||
26 ||Who When What
27 ||knaraset 14-May-2003 Modified the record type lgcy_suo_rec_type to add location_cd and Unit_class,
28 as part of MUS build bug 2829262
29 ************************************************************************************************/
30
31
32
33 TYPE lgcy_suo_rec_type IS RECORD
34 /*===========================================================================+
35 | Object Type |
36 | Record type of the table igs_as_lgcy_suo_int |
37 | |
38 | DESCRIPTION |
39 | Record type of the table igs_as_lgcy_suo_int |
40 | |
41 | SCOPE - PUBLIC |
42 | |
43 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
44 | |
45 | NOTES |
46 | |
47 | CREATION HISTORY : |
48 | Aiyer 20-Nov-2002 |
49 | MODIFICATION HISTORY |
50 +===========================================================================*/
51 (
52 PERSON_NUMBER IGS_AS_LGCY_SUO_INT.PERSON_NUMBER%TYPE ,
53 PROGRAM_CD IGS_AS_LGCY_SUO_INT.PROGRAM_CD%TYPE ,
54 UNIT_CD IGS_AS_LGCY_SUO_INT.UNIT_CD%TYPE ,
55 TEACH_CAL_ALT_CODE IGS_AS_LGCY_SUO_INT.TEACH_CAL_ALT_CODE%TYPE ,
56 OUTCOME_DT IGS_AS_LGCY_SUO_INT.OUTCOME_DT%TYPE ,
57 GRADING_SCHEMA_CD IGS_AS_LGCY_SUO_INT.GRADING_SCHEMA_CD%TYPE ,
58 VERSION_NUMBER IGS_AS_LGCY_SUO_INT.VERSION_NUMBER%TYPE ,
59 GRADE IGS_AS_LGCY_SUO_INT.GRADE%TYPE ,
60 S_GRADE_CREATION_METHOD_TYPE IGS_AS_LGCY_SUO_INT.S_GRADE_CREATION_METHOD_TYPE%TYPE ,
61 FINALISED_OUTCOME_IND IGS_AS_LGCY_SUO_INT.FINALISED_OUTCOME_IND%TYPE ,
62 MARK IGS_AS_LGCY_SUO_INT.MARK%TYPE ,
63 INCOMP_DEADLINE_DATE IGS_AS_LGCY_SUO_INT.INCOMP_DEADLINE_DATE%TYPE ,
64 INCOMP_GRADING_SCHEMA_CD IGS_AS_LGCY_SUO_INT.INCOMP_GRADING_SCHEMA_CD%TYPE ,
65 INCOMP_VERSION_NUMBER IGS_AS_LGCY_SUO_INT.INCOMP_VERSION_NUMBER%TYPE ,
66 INCOMP_DEFAULT_GRADE IGS_AS_LGCY_SUO_INT.INCOMP_DEFAULT_GRADE%TYPE ,
67 INCOMP_DEFAULT_MARK IGS_AS_LGCY_SUO_INT.INCOMP_DEFAULT_MARK%TYPE ,
68 COMMENTS IGS_AS_LGCY_SUO_INT.COMMENTS%TYPE ,
69 GRADING_PERIOD_CD IGS_AS_LGCY_SUO_INT.GRADING_PERIOD_CD%TYPE ,
70 ATTRIBUTE_CATEGORY IGS_AS_LGCY_SUO_INT.ATTRIBUTE_CATEGORY%TYPE ,
71 ATTRIBUTE1 IGS_AS_LGCY_SUO_INT.ATTRIBUTE1%TYPE ,
72 ATTRIBUTE2 IGS_AS_LGCY_SUO_INT.ATTRIBUTE2%TYPE ,
73 ATTRIBUTE3 IGS_AS_LGCY_SUO_INT.ATTRIBUTE3%TYPE ,
74 ATTRIBUTE4 IGS_AS_LGCY_SUO_INT.ATTRIBUTE4%TYPE ,
75 ATTRIBUTE5 IGS_AS_LGCY_SUO_INT.ATTRIBUTE5%TYPE ,
76 ATTRIBUTE6 IGS_AS_LGCY_SUO_INT.ATTRIBUTE6%TYPE ,
77 ATTRIBUTE7 IGS_AS_LGCY_SUO_INT.ATTRIBUTE7%TYPE ,
78 ATTRIBUTE8 IGS_AS_LGCY_SUO_INT.ATTRIBUTE8%TYPE ,
79 ATTRIBUTE9 IGS_AS_LGCY_SUO_INT.ATTRIBUTE9%TYPE ,
80 ATTRIBUTE10 IGS_AS_LGCY_SUO_INT.ATTRIBUTE10%TYPE ,
81 ATTRIBUTE11 IGS_AS_LGCY_SUO_INT.ATTRIBUTE11%TYPE ,
82 ATTRIBUTE12 IGS_AS_LGCY_SUO_INT.ATTRIBUTE12%TYPE ,
83 ATTRIBUTE13 IGS_AS_LGCY_SUO_INT.ATTRIBUTE13%TYPE ,
84 ATTRIBUTE14 IGS_AS_LGCY_SUO_INT.ATTRIBUTE14%TYPE ,
85 ATTRIBUTE15 IGS_AS_LGCY_SUO_INT.ATTRIBUTE15%TYPE ,
86 ATTRIBUTE16 IGS_AS_LGCY_SUO_INT.ATTRIBUTE16%TYPE ,
87 ATTRIBUTE17 IGS_AS_LGCY_SUO_INT.ATTRIBUTE17%TYPE ,
88 ATTRIBUTE18 IGS_AS_LGCY_SUO_INT.ATTRIBUTE18%TYPE ,
89 ATTRIBUTE19 IGS_AS_LGCY_SUO_INT.ATTRIBUTE19%TYPE ,
90 ATTRIBUTE20 IGS_AS_LGCY_SUO_INT.ATTRIBUTE20%TYPE,
91 LOCATION_CD IGS_AS_LGCY_SUO_INT.LOCATION_CD%TYPE,
92 UNIT_CLASS IGS_AS_LGCY_SUO_INT.UNIT_CLASS%TYPE
93 );
94
95 /*#
96 * The Unit Outcome Legacy import process is a public API designed for use in populating rows with data during a system conversion.
97 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_SUO_INT interface table.
98 * @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.
99 * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
100 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
101 * @param p_validation_level Public API will always perform full level of validation.
102 * @param p_lgcy_suo_rec Legacy Unit Outcome record type. Refer to IGS_AS_LGCY_SUO_INT for detail column descriptions.
103 * @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.
104 * @param x_msg_count Message count.
105 * @param x_msg_data Message data.
106 * @rep:scope public
107 * @rep:lifecycle active
108 * @rep:displayname Import Legacy Unit Outcome
109 */
110 PROCEDURE create_unit_outcome
111
112 /*===========================================================================+
113 | PROCEDURE |
114 | create_unit_outcome |
115 | |
116 | DESCRIPTION |
117 | This is a public procedure and is responsible for the |
118 | creation of a student Assessment unit outcome record. |
119 | SCOPE - PUBLIC |
120 | |
121 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
122 | |
123 | ARGUMENTS : IN: |
124 | p_api_version |
125 | p_init_msg_list |
126 | p_commit |
127 | p_lgcy_suo_rec |
128 | OUT: |
129 | x_return_status |
130 | x_msg_count |
131 | x_msg_data |
132 | IN/ OUT: |
133 | |
134 | RETURNS : NONE |
135 | |
136 | NOTES |
137 | |
138 | CREATION HISTORY : |
139 | Aiyer 20-Nov-2002 |
140 | MODIFICATION HISTORY |
141 +===========================================================================*/
142 (
143 p_api_version IN NUMBER ,
144 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
145 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
146 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL ,
147 p_lgcy_suo_rec IN LGCY_SUO_REC_TYPE ,
148 x_return_status OUT NOCOPY VARCHAR2 ,
149 x_msg_count OUT NOCOPY NUMBER ,
150 x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153 PROCEDURE initialise ( p_lgcy_suo_rec IN OUT NOCOPY LGCY_SUO_REC_TYPE );
154 /*============================================================================+
155 | PROCEDURE |
156 | initialise |
157 | |
158 | DESCRIPTION |
159 | This procedure initialises the record type variable |
160 | |
161 | SCOPE - PUBLIC |
162 | |
163 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
164 | |
165 | ARGUMENTS : IN/ OUT: |
166 | p_lgcy_suo_rec |
167 | |
168 | |
169 | RETURNS : NONE |
170 | |
171 | NOTES |
172 | |
173 | CREATION HISTORY : |
174 | Aiyer 20-Nov-2002 |
175 | MODIFICATION HISTORY |
176 +===========================================================================*/
177
178 END igs_as_suao_lgcy_pub;