DBA Data[Home] [Help]

PACKAGE: APPS.IGS_RATINGS_PUB

Source


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;