1 PACKAGE IGS_HE_SPA_LGCY_PUB AS
2 /* $Header: IGSHE22S.pls 120.1 2006/02/13 23:26:52 jchakrab noship $ */
3 /*#
4 * The Student Program Attempt HESA Detail 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_HE_LGCY_SPA_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Student Program Attempt HESA Detail
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12 */
13
14 TYPE hesa_spa_rec_type IS RECORD (
15 person_number igs_he_lgcy_spa_int.person_number%TYPE,
16 program_cd igs_he_lgcy_spa_int.program_cd%TYPE,
17 fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18 domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19 highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20 occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21 commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22 special_student igs_he_lgcy_spa_int.special_student%TYPE,
23 student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24 student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25 teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26 itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27 bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28 teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29 teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30 teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31 teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32 student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33 destination igs_he_lgcy_spa_int.destination%TYPE,
34 itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35 associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36 associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37 associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38 associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39 nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40 ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41 postcode igs_he_lgcy_spa_int.postcode%TYPE,
42 social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43 occcode igs_he_lgcy_spa_int.occcode%TYPE,
44 nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45 return_type igs_he_lgcy_spa_int.return_type%TYPE,
46 subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47 subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48 subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49 qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50 dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51 implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52 gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53 units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54 disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55 franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56 units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57 franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58 employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,
59 disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,
60 enh_fund_elig_cd igs_he_lgcy_spa_int.enh_fund_elig_cd%TYPE);
61
62 /*------------------------------------------------------------------
63 --Created by : knaraset, Oracle IDC
64 --Date created: 14-Nov-2002
65 --
66 --Purpose: This is Public API to import the Legacy HESA program attempt statistics details
67 -- into OSS system.
68 --
69 --Known limitations/enhancements and/or remarks:
70 --
71 -- This API takes the record type variable of program attempt statistics along with
72 -- other standard API parameters.
73 --
74 --Change History:
75 --Who When What
76 --jchakrab 10-Jan-2006 Added Integration Repository Annotations for R12
77 ------------------------------------------------------------------ */
78
79 /*#
80 * The Student Program Attempt HESA Detail Import process is a public API designed for use in populating rows with data during a system conversion.
81 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_HE_LGCY_SPA_INT interface table.
82 * @param p_api_version API Version Number.
83 * @param p_init_msg_list Initialize Message List.
84 * @param p_commit Commit Transaction.
85 * @param p_validation_level Validation Level.
86 * @param p_hesa_spa_stats_rec Legacy Student Program Attempt HESA Details record type. Refer to IGS_HE_LGCY_SPA_INT for detail column descriptions.
87 * @param x_return_status Return Status.
88 * @param x_msg_count Message count.
89 * @param x_msg_data Message data.
90 * @rep:scope public
91 * @rep:lifecycle active
92 * @rep:displayname Import Legacy Student Program Attempt HESA Detail
93 */
94
95 PROCEDURE create_hesa_spa (p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
99 p_hesa_spa_stats_rec IN hesa_spa_rec_type,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2);
103
104
105 END IGS_HE_SPA_LGCY_PUB;