1 PACKAGE igs_av_lvl_lgcy_pub AS
2 /* $Header: IGSPAV1S.pls 120.2 2006/01/17 03:53:06 ijeddy ship $ */
3 /*#
4 * The Advanced Standing Unit Level Legacy 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_AV_LGCY_LVL_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Level Advanced Standing
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_ADV_STAND
12 */
13
14 -- RECORD type variable for the table igs_av_lgcy_lvl_int
15 TYPE lgcy_adstlvl_rec_type IS RECORD
16 (
17 person_number igs_av_lgcy_lvl_int.person_number%TYPE ,
18 program_cd igs_av_lgcy_lvl_int.program_cd%TYPE ,
19 total_exmptn_approved igs_av_lgcy_lvl_int.total_exmptn_approved%TYPE ,
20 total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,
21 total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22 exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23 unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24 prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25 load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26 institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27 s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28 credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29 approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30 authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31 granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32 expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33 cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34 revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35 comments igs_av_lgcy_lvl_int.comments%TYPE ,
36 qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37 qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38 qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39 qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40 qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41 approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42 prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43 prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44 start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45 end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46 tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47 tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48 test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49 basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50 basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,
51 basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,
52 unit_level_mark igs_av_lgcy_lvl_int.unit_level_mark%TYPE -- jhanda added unit_level_mark record member
53
54
55 );
56
57 /*#
58 * The Advanced Standing Unit Level Legacy Import process is a public API designed for use in populating rows with data during a system conversion.
59 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AV_LGCY_LVL_INT interface table.
60 * @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.
61 * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
62 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
63 * @param p_validation_level Public API will always perform full level of validation.
64 * @param p_lgcy_adstlvl_rec Legacy Advanced Standing Unit Level record type. Refer to IGS_AV_LGCY_LVL_INT for detail column descriptions.
65 * @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.
66 * @param x_msg_count Message count.
67 * @param x_msg_data Message data.
68 * @rep:scope public
69 * @rep:lifecycle active
70 * @rep:displayname Import Legacy Level Advanced Standing
71 */
72 PROCEDURE create_adv_stnd_level
73 (p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
77 p_lgcy_adstlvl_rec IN OUT NOCOPY lgcy_adstlvl_rec_type,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82 /*
83 Usage of create_adv_stnd_level
84 Initialise the variable p_lgcy_adstlvl_rec using
85 initialise so that the values are set to NULL
86 Now, set the value of each element
87 */
88
89 PROCEDURE initialise ( p_lgcy_adstlvl_rec IN OUT NOCOPY lgcy_adstlvl_rec_type );
90
91 END igs_av_lvl_lgcy_pub;