[Home] [Help]
PACKAGE: APPS.IGS_AV_UNT_LGCY_PUB
Source
1 PACKAGE igs_av_unt_lgcy_pub AS
2 /* $Header: IGSPAV2S.pls 120.2 2006/01/17 03:53:24 ijeddy ship $ */
3 /*#
4 * The Advanced Standing Unit 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_UNIT_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Unit Advanced Standing
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_ADV_STAND
12 */
13 -- RECORD type variable for the table igs_av_lgcy_lvl_int
14 TYPE lgcy_adstunt_rec_type IS RECORD (
15 person_number igs_av_lgcy_unt_int.person_number%TYPE,
16 program_cd igs_av_lgcy_unt_int.program_cd%TYPE,
17 total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18 total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19 total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20 exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21 unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22 version_number igs_av_lgcy_unt_int.version_number%TYPE,
23 institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24 approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25 authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26 prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27 granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28 expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29 cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30 revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31 comments igs_av_lgcy_unt_int.comments%TYPE,
32 credit_percentage NUMBER(5,2),
33 s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34 s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35 load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36 grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37 grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38 grade igs_av_lgcy_unt_int.grade%TYPE,
39 achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40 prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41 prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42 tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43 tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44 test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45 alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46 alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47 optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48 basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49 basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50 basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51 start_date igs_av_lgcy_unt_int.start_date%TYPE,
52 end_date igs_av_lgcy_unt_int.end_date%TYPE,
53 -- added jhanda bug 4327991
54 reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,
55 reference_cd igs_av_lgcy_unt_int.reference_cd%TYPE,
56 applied_program_cd igs_av_lgcy_unt_int.applied_program_cd%TYPE
57
58 );
59
60 /*===========================================================================+
61 | PROCEDURE |
62 | create_adv_stnd_unit |
63 | |
64 | DESCRIPTION |
65 | Creates advanced standing unit |
66 | |
67 | SCOPE - PUBLIC |
68 | |
69 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
70 | |
71 | ARGUMENTS : IN: |
72 | p_api_version |
73 | p_init_msg_list |
74 | p_commit |
75 | p_lgcy_adstunt_rec |
76 | OUT: |
77 | x_return_status |
78 | x_msg_count |
79 | x_msg_data |
80 | IN/ OUT: |
81 | |
82 | RETURNS : NONE |
83 | |
84 | NOTES |
85 | |
86 | MODIFICATION HISTORY |
87 | jhanda 11-11-2002 Created |
88 +===========================================================================*/
89 /*#
90 * The Advanced Standing Unit Legacy Import process is a public API designed for use in populating rows with data during a system conversion.
91 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AV_LGCY_UNIT_INT interface table.
92 * @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.
93 * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
94 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
95 * @param p_validation_level Public API will always perform full level of validation.
96 * @param p_lgcy_adstunt_rec Legacy Advanced Standing Unit record type. Refer to IGS_AV_LGCY_UNIT_INT for detail column descriptions.
97 * @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.
98 * @param x_msg_count Message count.
99 * @param x_msg_data Message data.
100 * @rep:scope public
101 * @rep:lifecycle active
102 * @rep:displayname Import Legacy Unit Advanced Standing
103 */
104 PROCEDURE create_adv_stnd_unit
105 (p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
107 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
109 p_lgcy_adstunt_rec IN OUT NOCOPY lgcy_adstunt_rec_type,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 /*===========================================================================+
116 | PROCEDURE |
117 | initialise |
118 | |
119 | DESCRIPTION |
120 | Initialise the advanced standing lgcy_adstunt_rec_type record|
121 | |
122 | SCOPE - PUBLIC |
123 | |
124 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
125 | |
126 | ARGUMENTS : |
127 | IN/ OUT: p_lgcy_adstunt_rec |
128 | |
129 | RETURNS : NONE |
130 | |
131 | NOTES |
132 | |
133 | MODIFICATION HISTORY |
134 | jhanda 11-11-2002 Created |
135 +===========================================================================*/
136 PROCEDURE initialise ( p_lgcy_adstunt_rec IN OUT NOCOPY lgcy_adstunt_rec_type );
137
138 END igs_av_unt_lgcy_pub;