1 PACKAGE igs_en_susa_lgcy_pub AS
2 /* $Header: IGSENA3S.pls 120.1 2006/01/17 03:37:20 rnirwani noship $ */
3 /*#
4 * The Student Unit Set Attempt Import process is a public API designed for use in populating rows
5 * 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_SUSA_INT interface table.
7 * @rep:scope public
8 * @rep:product IGS
9 * @rep:lifecycle active
10 * @rep:displayname Import Legacy Student Unit Set Attempt
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
13 */
14 -- irep annotations above.
15
16 -- Record Type for columns of Interface table IGS_EN_LGY_SUSA_INT
17 --
18 TYPE susa_rec_type IS RECORD (person_number igs_en_lgy_susa_int.person_number%TYPE,
19 program_cd igs_en_lgy_susa_int.program_cd%TYPE,
20 unit_set_cd igs_en_lgy_susa_int.unit_set_cd%TYPE,
21 us_version_number igs_en_lgy_susa_int.us_version_number%TYPE,
22 selection_dt igs_en_lgy_susa_int.selection_dt%TYPE,
23 student_confirmed_ind igs_en_lgy_susa_int.student_confirmed_ind%TYPE,
24 end_dt igs_en_lgy_susa_int.end_dt%TYPE,
25 parent_unit_set_cd igs_en_lgy_susa_int.parent_unit_set_cd%TYPE,
26 primary_set_ind igs_en_lgy_susa_int.primary_set_ind%TYPE,
27 voluntary_end_ind igs_en_lgy_susa_int.voluntary_end_ind%TYPE,
28 authorised_person_number igs_en_lgy_susa_int.authorised_person_number%TYPE,
29 authorised_on igs_en_lgy_susa_int.authorised_on%TYPE,
30 override_title igs_en_lgy_susa_int.override_title%TYPE,
31 rqrmnts_complete_ind igs_en_lgy_susa_int.rqrmnts_complete_ind%TYPE,
32 rqrmnts_complete_dt igs_en_lgy_susa_int.rqrmnts_complete_dt%TYPE,
33 s_completed_source_type igs_en_lgy_susa_int.s_completed_source_type%TYPE,
34 catalog_cal_alternate_code igs_en_lgy_susa_int.catalog_cal_alternate_code%TYPE,
35 attribute_category igs_en_lgy_susa_int.attribute_category%TYPE,
36 attribute1 igs_en_lgy_susa_int.attribute1%TYPE,
37 attribute2 igs_en_lgy_susa_int.attribute2%TYPE,
38 attribute3 igs_en_lgy_susa_int.attribute3%TYPE,
39 attribute4 igs_en_lgy_susa_int.attribute4%TYPE,
40 attribute5 igs_en_lgy_susa_int.attribute5%TYPE,
41 attribute6 igs_en_lgy_susa_int.attribute6%TYPE,
42 attribute7 igs_en_lgy_susa_int.attribute7%TYPE,
43 attribute8 igs_en_lgy_susa_int.attribute8%TYPE,
44 attribute9 igs_en_lgy_susa_int.attribute9%TYPE,
45 attribute10 igs_en_lgy_susa_int.attribute10%TYPE,
46 attribute11 igs_en_lgy_susa_int.attribute11%TYPE,
47 attribute12 igs_en_lgy_susa_int.attribute12%TYPE,
48 attribute13 igs_en_lgy_susa_int.attribute13%TYPE,
49 attribute14 igs_en_lgy_susa_int.attribute14%TYPE,
50 attribute15 igs_en_lgy_susa_int.attribute15%TYPE,
51 attribute16 igs_en_lgy_susa_int.attribute16%TYPE,
52 attribute17 igs_en_lgy_susa_int.attribute17%TYPE,
53 attribute18 igs_en_lgy_susa_int.attribute18%TYPE,
54 attribute19 igs_en_lgy_susa_int.attribute19%TYPE,
55 attribute20 igs_en_lgy_susa_int.attribute20%TYPE );
56
57
58 /*----------------------------------------------------------------------------
59 || Created By : prraj
60 || Created On : 11-Nov-2002
61 || Purpose : To create a EN Student Unit Set Attempt
62 || Known limitations, enhancements or remarks :
63 || Change History :
64 || Who When What
65 ------------------------------------------------------------------------------*/
66 -- irep annotations below
67 /*#
68 * The Student Unit Set Attempt Import process is a public API designed for use in populating
69 * rows with data during a system conversion. This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_EN_LGY_SUSA_INT interface table.
70 * @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.
71 * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
72 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
73 * @param p_validation_level Public API will always perform full level of validation.
74 * @param p_susa_rec Legacy Student Unit Set Attempt record type. Refer to IGS_EN_LGY_SUSA_INT for detail column descriptions.
75 * @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.
76 * @param x_msg_count Message count.
77 * @param x_msg_data Message data.
78 * @rep:scope public
79 * @rep:lifecycle active
80 * @rep:displayname Import Legacy Student Unit Set Attempt
81 */
82 PROCEDURE create_unit_set_atmpt (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_susa_rec IN susa_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
92
93 END igs_en_susa_lgcy_pub;