1 PACKAGE igs_en_spa_lgcy_pub AS
2 /* $Header: IGSENA2S.pls 120.2 2006/01/19 00:07:36 rnirwani noship $ */
3 /*#
4 * The Student Program Attempt Legacy Import process is a public API designed for
5 * use in populating rows with data during a system conversion. This API is also used
6 * by the Legacy Import Process for Enrollment and Records when importing rows from the
7 * IGS_EN_LGCY_SPA_INT interface table.
8 * @rep:scope public
9 * @rep:product IGS
10 * @rep:lifecycle active
11 * @rep:displayname Import Legacy Student Program Attempt
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
14 */
15 -- irep annotations above.
16 TYPE SCA_RE_REC_TYPE IS RECORD(
17 person_number igs_en_lgcy_spa_int.person_number%TYPE,
18 program_cd igs_en_lgcy_spa_int.program_cd%TYPE,
19 version_number igs_en_lgcy_spa_int.version_number%TYPE,
20 cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21 location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22 attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23 attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24 student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25 commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26 primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27 primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28 key_program igs_en_lgcy_spa_int.key_program%TYPE,
29 provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30 discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31 discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32 lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33 funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34 exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35 nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36 nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37 rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38 waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39 last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40 publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41 course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42 course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43 s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44 advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45 fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46 correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47 self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48 adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49 adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50 adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51 class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52 catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53 override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54 manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55 attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56 attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57 attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58 attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59 attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60 attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61 attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62 attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63 attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64 attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65 attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66 attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67 attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68 attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69 attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70 attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71 attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72 attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73 attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74 attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75 attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76 re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77 re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78 re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79 re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
80 re_research_topic igs_en_lgcy_spa_int.re_research_topic%TYPE,
81 re_industry_links igs_en_lgcy_spa_int.re_industry_links%TYPE);
82
83 -- irep annotations below.
84 /*#
85 * The Student Program Attempt Legacy Import process is a public API designed for use in
86 * populating rows with data during a system conversion. This API is also used by the Legacy
87 * Import Process for Enrollment and Records when importing rows from the IGS_EN_LGCY_SPA_INT interface table.
88 * @param p_api_version The version number will be used to compare with
89 * claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
90 * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
91 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
92 * @param p_validation_level Public API will always perform full level of validation.
93 * @param p_sca_re_rec Legacy Student Program Attempt record type. Refer to IGS_EN_LGCY_SPA_INT for detail column descriptions.
94 * @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.
95 * @param x_msg_count Message count.
96 * @param x_msg_data Message data.
97 * @rep:scope public
98 * @rep:lifecycle active
99 * @rep:displayname Import Legacy Student Program Attempt
100 */
101 PROCEDURE create_spa(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
106 p_sca_re_rec IN SCA_RE_REC_TYPE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2);
110
111
112 END igs_en_spa_lgcy_pub;