1 PACKAGE igs_he_susa_lgcy_pub AS
2 /* $Header: IGSHE23S.pls 120.1 2006/02/13 23:27:10 jchakrab noship $ */
3 /*#
4 * The Student Unit Set 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_LGY_SUSA_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Student Unit Set Attempt HESA Detail
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12 */
13
14 -- Record Type for columns of Interface table IGS_HE_LGY_SUSA_INT
15 --
16 TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,
17 program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18 unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19 new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20 term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21 disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22 additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23 sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24 study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25 study_location igs_he_lgy_susa_int.study_location%TYPE,
26 fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27 franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28 completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29 good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30 complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31 credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32 credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33 credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34 credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35 credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36 credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37 credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38 credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39 credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40 credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41 credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42 credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43 credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44 credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45 credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46 credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47 grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48 mark igs_he_lgy_susa_int.mark%TYPE,
49 teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50 teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51 pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52 fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53 fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54 fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55 non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56 student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57 fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58 calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59 fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60 type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61 year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62 enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,
63 additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,
64 disadv_uplift_factor igs_he_lgy_susa_int.disadv_uplift_factor%TYPE);
65
66
67 /*----------------------------------------------------------------------------
68 || Created By : prraj
69 || Created On : 05-11-2002
70 || Purpose : To create a HESA Student Unit Set Attempt
71 || Known limitations, enhancements or remarks :
72 || Change History :
73 || Who When What
74 || jchakrab 10-Jan-2006 Added Integration Repository Annotations for R12
75 ------------------------------------------------------------------------------*/
76
77 /*#
78 * The Student Unit Set Attempt HESA Detail Import process is a public API designed for use in populating rows with data during a system conversion.
79 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_HE_LGY_SUSA_INT interface table.
80 * @param p_api_version API Version Number.
81 * @param p_init_msg_list Initialize Message List.
82 * @param p_commit Commit Transaction.
83 * @param p_validation_level Validation Level.
84 * @param p_hesa_susa_rec Legacy Student Unit Set Attempt HESA Details record type. Refer to IGS_HE_LGY_SUSA_INT for detail column descriptions.
85 * @param x_return_status Return Status.
86 * @param x_msg_count Message count.
87 * @param x_msg_data Message data.
88 * @rep:scope public
89 * @rep:lifecycle active
90 * @rep:displayname Import Legacy Student Unit Set Attempt HESA Detail
91 */
92
93 PROCEDURE create_hesa_susa (p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
97 p_hesa_susa_rec IN hesa_susa_rec_type,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2);
101
102
103
104 END igs_he_susa_lgcy_pub;