1 PACKAGE igs_pr_clsrnk_lgcy_pub AS
2 /* $Header: IGSPPR2S.pls 120.1 2006/01/17 03:54:19 ijeddy noship $ */
3 /*#
4 * The Class Rank 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_PR_LGY_CLSR_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Class Rank
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12 */
13 -- RECORD type variable for the table igs_av_lgcy_lvl_int
14 TYPE lgcy_clsrnk_rec_type IS RECORD
15 (
16 person_number igs_pr_lgy_clsr_int.person_number%TYPE,
17 program_cd igs_pr_lgy_clsr_int.program_cd%TYPE,
18 cohort_name igs_pr_lgy_clsr_int.cohort_name%TYPE,
19 calendar_alternate_code igs_pr_lgy_clsr_int.calendar_alternate_code%TYPE,
20 cohort_rank igs_pr_lgy_clsr_int.cohort_rank%TYPE,
21 cohort_override_rank igs_pr_lgy_clsr_int.cohort_override_rank%TYPE,
22 comments igs_pr_lgy_clsr_int.comments%TYPE,
23 as_of_rank_gpa igs_pr_lgy_clsr_int.as_of_rank_gpa%TYPE
24 );
25
26 /*#
27 * The Class Rank Legacy import process is a public API designed for use in populating rows with data during a system conversion.
28 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_PR_LGY_CLSR_INT interface table.
29 * @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.
30 * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
31 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
32 * @param p_validation_level Public API will always perform full level of validation.
33 * @param p_lgcy_clsrnk_rec Legacy Class Rank record type. Refer to IGS_PR_LGY_CLSR_INT for detail column descriptions.
34 * @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.
35 * @param x_msg_count Message count.
36 * @param x_msg_data Message data.
37 * @rep:scope public
38 * @rep:lifecycle active
39 * @rep:displayname Import Legacy Class Rank
40 */
41 PROCEDURE create_class_rank
42 (p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
46 p_lgcy_clsrnk_rec IN lgcy_clsrnk_rec_type,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51 /*
52 Usage of create_adv_stnd_level
53 Initialise the variable p_lgcy_clsrnk_rec using
54 initialise so that the values are set to NULL
55 Now, set the value of each element
56 */
57
58 PROCEDURE initialise ( p_lgcy_clsrnk_rec IN OUT NOCOPY lgcy_clsrnk_rec_type );
59
60 END igs_pr_clsrnk_lgcy_pub;