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