1 PACKAGE IGS_GR_GRD_LGCY_PUB AS
2 /* $Header: IGSPGR1S.pls 120.1 2006/01/17 03:53:43 ijeddy noship $ */
3 /*#
4 * The Graduand 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_GR_LGCY_GRD_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Graduand
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12 */
13 /****************************************************************************************************************
14 || Created By : msrinivi
15 || Created On : 11-Nov-2002
16 || Purpose : This is an API to move legacy graduand details to OSS
17 ||
18 || Known limitations, enhancements or remarks :
19 || Change History :
20 || Who When What
21 || (reverse chronological order - newest change first)
22 ****************************************************************************************************************/
23
24 TYPE lgcy_grd_rec_type IS RECORD (
25 PERSON_NUMBER igs_gr_lgcy_grd_int.PERSON_NUMBER %TYPE,
26 CREATE_DT igs_gr_lgcy_grd_int.CREATE_DT%TYPE,
27 GRD_CAL_ALT_CODE igs_gr_lgcy_grd_int.GRD_CAL_ALT_CODE%TYPE,
28 PROGRAM_CD igs_gr_lgcy_grd_int.PROGRAM_CD%TYPE,
29 AWARD_PROGRAM_CD igs_gr_lgcy_grd_int.AWARD_PROGRAM_CD%TYPE,
30 AWARD_PROG_VERSION_NUMBER igs_gr_lgcy_grd_int.AWARD_PROG_VERSION_NUMBER%TYPE,
31 AWARD_CD igs_gr_lgcy_grd_int.AWARD_CD%TYPE,
32 GRADUAND_STATUS igs_gr_lgcy_grd_int.GRADUAND_STATUS%TYPE,
33 GRADUAND_APPR_STATUS igs_gr_lgcy_grd_int.GRADUAND_APPR_STATUS%TYPE,
34 S_GRADUAND_TYPE igs_gr_lgcy_grd_int.S_GRADUAND_TYPE%TYPE,
35 GRADUATION_NAME igs_gr_lgcy_grd_int.GRADUATION_NAME%TYPE,
36 PROXY_AWARD_PERSON_NUMBER igs_gr_lgcy_grd_int.PROXY_AWARD_PERSON_NUMBER%TYPE,
37 PREVIOUS_QUALIFICATIONS igs_gr_lgcy_grd_int.PREVIOUS_QUALIFICATIONS%TYPE,
38 CONVOCATION_MEMBERSHIP_IND igs_gr_lgcy_grd_int.CONVOCATION_MEMBERSHIP_IND%TYPE,
39 SUR_FOR_PROGRAM_CD igs_gr_lgcy_grd_int.SUR_FOR_PROGRAM_CD%TYPE,
40 SUR_FOR_PROG_VERSION_NUMBER igs_gr_lgcy_grd_int.SUR_FOR_PROG_VERSION_NUMBER%TYPE,
41 SUR_FOR_AWARD_CD igs_gr_lgcy_grd_int.SUR_FOR_AWARD_CD%TYPE,
42 COMMENTS igs_gr_lgcy_grd_int.COMMENTS%TYPE,
43 ATTRIBUTE_CATEGORY igs_gr_lgcy_grd_int.ATTRIBUTE_CATEGORY%TYPE,
44 ATTRIBUTE1 igs_gr_lgcy_grd_int.ATTRIBUTE1%TYPE,
45 ATTRIBUTE2 igs_gr_lgcy_grd_int.ATTRIBUTE2%TYPE,
46 ATTRIBUTE3 igs_gr_lgcy_grd_int.ATTRIBUTE3%TYPE,
47 ATTRIBUTE4 igs_gr_lgcy_grd_int.ATTRIBUTE4%TYPE,
48 ATTRIBUTE5 igs_gr_lgcy_grd_int.ATTRIBUTE5%TYPE,
49 ATTRIBUTE6 igs_gr_lgcy_grd_int.ATTRIBUTE6%TYPE,
50 ATTRIBUTE7 igs_gr_lgcy_grd_int.ATTRIBUTE7%TYPE,
51 ATTRIBUTE8 igs_gr_lgcy_grd_int.ATTRIBUTE8%TYPE,
52 ATTRIBUTE9 igs_gr_lgcy_grd_int.ATTRIBUTE9%TYPE,
53 ATTRIBUTE10 igs_gr_lgcy_grd_int.ATTRIBUTE10%TYPE,
54 ATTRIBUTE11 igs_gr_lgcy_grd_int.ATTRIBUTE11%TYPE,
55 ATTRIBUTE12 igs_gr_lgcy_grd_int.ATTRIBUTE12%TYPE,
56 ATTRIBUTE13 igs_gr_lgcy_grd_int.ATTRIBUTE13%TYPE,
57 ATTRIBUTE14 igs_gr_lgcy_grd_int.ATTRIBUTE14%TYPE,
58 ATTRIBUTE15 igs_gr_lgcy_grd_int.ATTRIBUTE15%TYPE,
59 ATTRIBUTE16 igs_gr_lgcy_grd_int.ATTRIBUTE16%TYPE,
60 ATTRIBUTE17 igs_gr_lgcy_grd_int.ATTRIBUTE17%TYPE,
61 ATTRIBUTE18 igs_gr_lgcy_grd_int.ATTRIBUTE18%TYPE,
62 ATTRIBUTE19 igs_gr_lgcy_grd_int.ATTRIBUTE19%TYPE,
63 ATTRIBUTE20 igs_gr_lgcy_grd_int.ATTRIBUTE20%TYPE
64 );
65
66 /*#
67 * The Graduand Legacy import process is a public API designed for use in populating rows with data during a system conversion.
68 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_GR_LGCY_GRD_INT interface table.
69 * @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.
70 * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
71 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
72 * @param p_validation_level Public API will always perform full level of validation.
73 * @param p_lgcy_grd_rec Legacy graduation record type. Refer to IGS_GR_LGCY_GRD_INT for detail column descriptions.
74 * @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.
75 * @param x_msg_count Message count.
76 * @param x_msg_data Message data.
77 * @rep:scope public
78 * @rep:lifecycle active
79 * @rep:displayname Import Legacy Graduand
80 */
81 PROCEDURE create_graduand(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
86 p_lgcy_grd_rec IN OUT NOCOPY lgcy_grd_rec_type,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2);
90
91 END IGS_GR_GRD_LGCY_PUB;