1 PACKAGE igs_as_trncmt_lgcy_pub AS
2 /* $Header: IGSAS56S.pls 120.1 2006/01/17 03:52:12 ijeddy noship $ */
3 /*#
4 * The Transcript Comments 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_STC_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Transcript Comment
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12 */
13
14 /******************************************************************************
15 || Created By : anilk
16 || Created On : 22-Sep-2002
17 || Purpose : This is an API to move legacy teranscript comments to OSS
18 ||
19 || Known limitations, enhancements or remarks :
20 || Change History :
21 || Who When What
22 || (reverse chronological order - newest change first)
23 ******************************************************************************/
24
25 TYPE lgcy_trncmt_rec_type IS RECORD (
26 comment_type_code igs_as_lgcy_stc_int.comment_type_code%TYPE,
27 comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,
28 person_number igs_as_lgcy_stc_int.person_number%TYPE,
29 program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30 program_type igs_as_lgcy_stc_int.program_type%TYPE,
31 award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32 load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33 unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34 us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35 unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36 version_number igs_as_lgcy_stc_int.version_number%TYPE,
37 teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,
38 location_cd igs_as_lgcy_stc_int.location_cd%TYPE,
39 unit_class igs_as_lgcy_stc_int.unit_class%TYPE
40 );
41
42 /*#
43 * The Transcript Comments import process is a public API designed for use in populating rows with data during a system conversion.
44 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_STC_INT interface table.
45 * @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.
46 * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
47 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
48 * @param p_validation_level Public API will always perform full level of validation.
49 * @param p_lgcy_trncmt_rec Legacy Transcript Comment record type. Refer to IGS_AS_LGCY_STC_INT for detail column descriptions.
50 * @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.
51 * @param x_msg_count Message count.
52 * @param x_msg_data Message data.
53 * @rep:scope public
54 * @rep:lifecycle active
55 * @rep:displayname Import Legacy Transcript Comment
56 */
57 PROCEDURE create_trncmt(
58 p_api_version IN NUMBER ,
59 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
61 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
62 p_lgcy_trncmt_rec IN OUT NOCOPY LGCY_TRNCMT_REC_TYPE,
63 x_return_status OUT NOCOPY VARCHAR2 ,
64 x_msg_count OUT NOCOPY NUMBER ,
65 x_msg_data OUT NOCOPY VARCHAR2
66 );
67 END igs_as_trncmt_lgcy_pub;