1 PACKAGE igs_pr_prout_lgcy_pub AS
2 /* $Header: IGSPPR1S.pls 120.1 2006/01/17 03:54:01 ijeddy noship $ */
3 /*#
4 * The Progression Outcome 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_LGCY_SPO_INT interface table.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Import Legacy Progression Outcome
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12 */
13 --
14 -- Start of comments
15 -- API name : igs_pr_prout_lgcy_pub
16 -- Type : Public
17 -- Function :
18 -- Pre-reqs : None
19 -- Parameters :
20 -- IN :
21 -- p_api_version IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional Default FND_API.G_FALSE
23 -- p_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional Default FND_API.G_VALID_LEVEL_FULL
25 --
26 -- OUT :
27 -- x_return_status OUT VARCHAR2(1)
28 -- x_msg_count OUT NUMBER
29 -- x_msg_data OUT VARCHAR2(2000)
30 --
31 -- IN OUT :
32 -- p_lgcy_grd_rec OUT lgcy_grd_rec_type%TYPE
33 --
34 -- Version : Initial version 1.0
35 --
36 -- Notes : Import Progression Outcome information from Legacy System into OSS
37 --
38 -- End of comments
39 --
40 TYPE lgcy_prout_rec_type IS RECORD (
41 person_number igs_pr_lgcy_spo_int.person_number%TYPE,
42 program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,
43 prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44 progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45 duration igs_pr_lgcy_spo_int.duration%TYPE,
46 duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47 decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48 decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49 decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50 show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51 show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52 show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53 show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54 appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55 appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56 appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57 appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58 encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59 restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60 restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61 comments igs_pr_lgcy_spo_int.comments%TYPE,
62 show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63 appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64 expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65 award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66 spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67 unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68 s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69 unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,
70 us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,
71 --anilk, Bug# 3021236, adding fund_code
72 fund_code igs_pr_lgcy_spo_int.fund_code%TYPE
73 );
74 --
75 /*#
76 * The Progression Outcome Legacy import process is a public API designed for use in populating rows with data during a system conversion.
77 * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_PR_LGCY_SPO_INT interface table.
78 * @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.
79 * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
80 * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
81 * @param p_validation_level Public API will always perform full level of validation.
82 * @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.
83 * @param x_msg_count Message count.
84 * @param x_msg_data Message data.
85 * @param p_lgcy_prout_rec Legacy Progression Outcome record type. Refer to IGS_PR_LGCY_SPO_INT for detail column descriptions.
86 * @rep:scope public
87 * @rep:lifecycle active
88 * @rep:displayname Import Legacy Progression Outcome
89 */
90 PROCEDURE create_outcome (
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
94 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_lgcy_prout_rec IN OUT NOCOPY lgcy_prout_rec_type
99 );
100 --
101 END igs_pr_prout_lgcy_pub;