1 PACKAGE igs_ratings_pub AS
2 /* $Header: IGSPRATS.pls 120.1 2006/01/18 01:13:49 rghosh noship $ */
3 /*#
4 * This Package contains Public API's for assigning review groups and Evaluators to Admission Application.
5 * @rep:scope public
6 * @rep:product IGS
7 * @rep:displayname Assign Review Groups and Evaluators
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY IGS_ADM_APPLICATION
11 */
12
13 /*#
14 * The Record Program Approval API is a public API that enables program approval to be recorded against an application instance. The API can be
15 * called as part of workflow logic, through the action of data being entered or updated in the system and a subsequent business event being raised
16 * or as a result of the evaluation of a particular sequence of logic.
17 * @param p_API_VERSION API Version Number
18 * @param p_INIT_MSG_LIST Initialize Message List
19 * @param p_COMMIT Commit Transaction
20 * @param p_VALIDATION_LEVEL Validation Level
21 * @param X_RETURN_STATUS Return Status
22 * @param X_MSG_COUNT Message Count
23 * @param X_MSG_DATA Message Data
24 * @param p_PERSON_ID Person ID
25 * @param p_ADMISSION_APPL_NUMBER Admission Application number
26 * @param p_NOMINATED_PROGRAM_CD Nominated Program Code
27 * @param p_SEQUENCE_NUMBER Sequence Number
28 * @param p_PGM_APPROVER_ID Program Approver ID
29 * @param p_PROGRAM_APPROVAL_DATE Program Approval Date
30 * @param p_PROGRAM_APPROVAL_STATUS Program Approval Status
31 * @param p_APPROVAL_NOTES Approval Notes
32 * @rep:scope public
33 * @rep:lifecycle active
34 * @rep:displayname Record Program Approval
35 */
36 PROCEDURE rec_pgm_approval
37 (
38 --Standard Parameters Start
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
41 p_commit IN VARCHAR2 default FND_API.G_FALSE,
42 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 --Standard parameter ends
47 p_person_id IN NUMBER,
48 p_admission_appl_number IN NUMBER,
49 p_nominated_program_cd IN VARCHAR2,
50 p_sequence_number IN NUMBER,
51 p_pgm_approver_id IN NUMBER,
52 p_program_approval_date IN DATE,
53 p_program_approval_status IN VARCHAR2,
54 p_approval_notes IN VARCHAR2
55 );
56
57
58 /*#
59 * The Assign Review Profile and Evaluators API is a public API that enables Review Groups and Evaluators to be assigned to an application instance.
60 * The API can be called as part of workflow logic, through the action of data being entered or updated in the system and a subsequent business event
61 * being raised or as a result of the evaluation of a particular sequence of logic.
62 * @param p_API_VERSION API Version Number
63 * @param p_INIT_MSG_LIST Initialize Message List
64 * @param p_COMMIT Commit Transaction
65 * @param p_VALIDATION_LEVEL Validation Level
66 * @param X_RETURN_STATUS Return Status
67 * @param X_MSG_COUNT Message Count
68 * @param X_MSG_DATA Message Data
69 * @param p_PERSON_ID Person ID
70 * @param p_ADMISSION_APPL_NUMBER Admission Application number
71 * @param p_NOMINATED_PROGRAM_CD Nominated Program Code
72 * @param p_SEQUENCE_NUMBER Sequence Number
73 * @param p_APPL_REV_PROFILE_ID Review Profile ID
74 * @param p_APPL_REVPROF_REVGR_ID Review Profile-Review Group ID
75 * @rep:scope public
76 * @rep:lifecycle active
77 * @rep:displayname Initiate Application Evaluation
78 */
79 PROCEDURE ASSIGN_EVALUATORS_TO_AI (
80 --Standard Parameters Start
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
83 p_commit IN VARCHAR2 default FND_API.G_FALSE,
84 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
85
86 --Standard parameter ends
87
88 p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,
89 p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,
90 p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE ,
91 p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE ,
92 p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE ,
93 p_appl_revprof_revgr_id IN igs_ad_appl_arp_v.APPL_REVPROF_REVGR_ID%TYPE ,
94
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 END igs_ratings_pub;