1 PACKAGE AMW_EVALUATIONS_PKG AUTHID CURRENT_USER as
2 /*$Header: amwevals.pls 115.8 2004/01/27 01:56:00 kosriniv noship $*/
3
4 procedure insert_row (
5 p_EVALUATION_SET_ID IN NUMBER,
6 p_EVALUATION_OBJECT_NAME IN VARCHAR2,
7 p_EVALUATION_CONTEXT IN VARCHAR2,
8 p_EVALUATION_TYPE IN VARCHAR2,
9 -- 12.31.2003 tsho: for bug 3326347
10 -- p_DATE_EVALUATED IN VARCHAR2,
11 p_DATE_EVALUATED IN DATE,
12 p_PK1_VALUE IN VARCHAR2,
13 p_PK2_VALUE IN VARCHAR2,
14 p_PK3_VALUE IN VARCHAR2,
15 p_PK4_VALUE IN VARCHAR2,
16 p_PK5_VALUE IN VARCHAR2,
17 p_ENTERED_BY_ID IN NUMBER,
18 p_EXECUTED_BY_ID IN NUMBER,
19 p_COMMENTS IN VARCHAR2,
20 p_DES_EFF IN VARCHAR2,
21 p_OP_EFF IN VARCHAR2,
22 p_OV_EFF IN VARCHAR2,
23 p_PGMODE IN VARCHAR2,
24 p_EVALUATION_ID IN NUMBER,
25 p_commit in varchar2 := FND_API.G_FALSE,
26 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28 x_return_status out nocopy varchar2,
29 x_msg_count out nocopy number,
30 x_msg_data out nocopy varchar2,
31 p_EVALUATION_SET_STATUS_CODE IN VARCHAR2 := 'P'
32 );
33
34 function get_op_effectiveness(p_evaluation_id IN NUMBER) return varchar2;
35
36 function get_des_effectiveness(p_evaluation_id IN NUMBER) return varchar2;
37
38 function get_op_effectiveness_code(p_evaluation_id IN NUMBER) return varchar2;
39
40 function get_des_effectiveness_code(p_evaluation_id IN NUMBER) return varchar2;
41
42 function get_line_conclusion(p_evaluation_id IN NUMBER) return varchar2;
43
44 function get_line_conclusion_code(p_evaluation_id IN NUMBER) return varchar2;
45
46 function isEvalOwnerOrExecutor(p_evaluation_id IN NUMBER, p_user_id IN NUMBER) return varchar2;
47
48 function isEvalExecutorOfAssessment(p_assessment_id IN NUMBER, p_user_id IN NUMBER, p_eval_context IN VARCHAR2) return varchar2;
49
50 procedure ADD_LANGUAGE;
51
52 end AMW_EVALUATIONS_PKG;