1 PACKAGE igs_en_spi_lgcy_pub AS
2 /* $Header: IGSENA6S.pls 120.2 2006/04/13 01:56:03 smaddali noship $ */
3 /*#
4 * The Student Intermission 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_SPI_INT interface table.
7 * @rep:scope public
8 * @rep:product IGS
9 * @rep:lifecycle active
10 * @rep:displayname Import Legacy Intermission
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
13 */
14 -- irep annotations above.
15
16 TYPE en_spi_rec_type IS RECORD ( person_number igs_en_lgcy_spi_int.person_number%TYPE,
17 program_cd igs_en_lgcy_spi_int.program_cd%TYPE,
18 start_dt igs_en_lgcy_spi_int.start_dt%TYPE,
19 end_dt igs_en_lgcy_spi_int.end_dt%TYPE,
20 voluntary_ind igs_en_lgcy_spi_int.voluntary_ind%TYPE,
21 comments igs_en_lgcy_spi_int.comments%TYPE,
22 intermission_type igs_en_lgcy_spi_int.intermission_type%TYPE,
23 approved igs_en_lgcy_spi_int.approved%TYPE,
24 institution_name igs_en_lgcy_spi_int.institution_name%TYPE,
25 max_credit_pts igs_en_lgcy_spi_int.max_credit_pts%TYPE,
26 max_terms igs_en_lgcy_spi_int.max_terms%TYPE,
27 anticipated_credit_points igs_en_lgcy_spi_int.anticipated_credit_points%TYPE,
28 approver_person_number igs_en_lgcy_spi_int.approver_person_number%TYPE,
29 attribute_category igs_en_lgcy_spi_int.attribute_category%TYPE,
30 attribute1 igs_en_lgcy_spi_int.attribute1%TYPE,
31 attribute2 igs_en_lgcy_spi_int.attribute2%TYPE,
32 attribute3 igs_en_lgcy_spi_int.attribute3%TYPE,
33 attribute4 igs_en_lgcy_spi_int.attribute4%TYPE,
34 attribute5 igs_en_lgcy_spi_int.attribute5%TYPE,
35 attribute6 igs_en_lgcy_spi_int.attribute6%TYPE,
36 attribute7 igs_en_lgcy_spi_int.attribute7%TYPE,
37 attribute8 igs_en_lgcy_spi_int.attribute8%TYPE,
38 attribute9 igs_en_lgcy_spi_int.attribute9%TYPE,
39 attribute10 igs_en_lgcy_spi_int.attribute10%TYPE,
40 attribute11 igs_en_lgcy_spi_int.attribute11%TYPE,
41 attribute12 igs_en_lgcy_spi_int.attribute12%TYPE,
42 attribute13 igs_en_lgcy_spi_int.attribute13%TYPE,
43 attribute14 igs_en_lgcy_spi_int.attribute14%TYPE,
44 attribute15 igs_en_lgcy_spi_int.attribute15%TYPE,
45 attribute16 igs_en_lgcy_spi_int.attribute16%TYPE,
46 attribute17 igs_en_lgcy_spi_int.attribute17%TYPE,
47 attribute18 igs_en_lgcy_spi_int.attribute18%TYPE,
48 attribute19 igs_en_lgcy_spi_int.attribute19%TYPE,
49 attribute20 igs_en_lgcy_spi_int.attribute20%TYPE,
50 cond_return_flag igs_en_lgcy_spi_int.cond_return_flag%TYPE
51 );
52
53 -- irep annotations below.
54 /*#
55 * The Student Intermission Import process is a public API designed for use in populating rows with
56 * data during a system conversion. This API is also used by the Legacy Import Process for Enrollment
57 * and Records when importing rows from the IGS_EN_LGCY_SPI_INT interface table.
58 * @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.
59 * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
60 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
61 * @param p_validation_level Public API will always perform full level of validation.
62 * @param p_intermiss_rec Legacy Student Intermission record type. Refer to IGS_EN_LGCY_SPI_INT for detail column descriptions.
63 * @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.
64 * @param x_msg_count Message count.
65 * @param x_msg_data Message data.
66 * @rep:scope public
67 * @rep:lifecycle active
68 * @rep:displayname Import Legacy Intermission
69 */
70 PROCEDURE create_student_intm
71 (
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
75 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL ,
76 p_intermiss_rec IN en_spi_rec_type,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 END igs_en_spi_lgcy_pub;