1 PACKAGE CST_JobCloseVar_GRP AUTHID CURRENT_USER AS
2 /* $Header: CSTGWJVS.pls 120.0 2005/06/24 12:41:09 appldev noship $ */
3
4 /*----------------------------------------------------------------------------+
5 | Start of comments |
6 | API name : Calculate_Job_Variance |
7 | Type : Group |
8 | Function : Discrete job close variance calculation. |
9 | Pre-reqs : None. |
10 | Parameters : |
11 | IN : |
12 | p_api_version IN NUMBER Required |
13 | p_init_msg_list IN VARCHAR2 Required |
14 | p_commit IN VARCHAR2 Required |
15 | p_validation_level IN NUMBER Required |
16 | p_user_id IN NUMBER Required |
17 | p_login_id IN NUMBER Required |
18 | p_prg_appl_id IN NUMBER Required |
19 | p_prg_id IN NUMBER Required |
20 | p_req_id IN NUMBER Required |
21 | p_wcti_group_id IN NUMBER Required |
22 | p_org_id IN NUMBER Required |
23 | |
24 | OUT : |
25 | x_return_status OUT VARCHAR2(1) |
26 | x_msg_count OUT NUMBER |
27 | x_msg_data OUT VARCHAR2(2000) |
28 | |
29 | Version : Current version 1.0 |
30 | |
31 | End of comments |
32 +----------------------------------------------------------------------------*/
33 PROCEDURE Calculate_Job_Variance
34 (
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2,
37 p_commit IN VARCHAR2,
38 p_validation_level IN NUMBER,
39
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43
44 p_user_id IN NUMBER,
45 p_login_id IN NUMBER,
46 p_prg_appl_id IN NUMBER,
47 p_prg_id IN NUMBER,
48 p_req_id IN NUMBER,
49 p_wcti_group_id IN NUMBER,
50 p_org_id IN NUMBER
51 );
52
53 END CST_JobCloseVar_GRP;