1 PACKAGE CS_SR_COST_CP AS
2 /* $Header: csvcstpgs.pls 120.0 2007/12/19 11:38:26 gasankar noship $ */
3
4 PROCEDURE Create_Cost
5 (
6 errbuf OUT NOCOPY VARCHAR2
7 , errcode OUT NOCOPY NUMBER
8 , p_api_version_number IN NUMBER
9 , p_init_msg_list IN VARCHAR2
10 , p_commit IN VARCHAR2
11 , p_validation_level IN NUMBER
12 , p_creation_from_date IN varchar2
13 , p_creation_to_date IN varchar2
14 , p_sr_status IN VARCHAR2
15 , p_number_of_workers IN NUMBER
16 , p_cost_batch_size IN NUMBER
17 );
18
19 PROCEDURE Cost_Worker
20 (
21 errbuf OUT NOCOPY VARCHAR2
22 , errcode OUT NOCOPY NUMBER
23 , p_api_version_number IN NUMBER
24 , p_init_msg_list IN VARCHAR2
25 , p_commit IN VARCHAR2
26 , p_validation_level IN NUMBER
27 , p_worker_id IN NUMBER
28 , p_cost_batch_size IN NUMBER
29 , p_cost_set_id IN NUMBER
30 );
31
32 PROCEDURE Validate_params
33 (
34 p_creation_from_date IN VARCHAR2
35 , p_creation_to_date IN VARCHAR2
36 , p_sr_status IN VARCHAR2
37 , x_creation_from_date OUT NOCOPY DATE
38 , x_creation_to_date OUT NOCOPY DATE
39 , x_msg_count OUT NOCOPY NUMBER
40 , x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE Form_And_Exec_Statement
44 (
45 p_creation_from_date IN DATE
46 , p_creation_to_date IN DATE
47 , p_sr_status IN VARCHAR2
48 , p_number_of_workers IN OUT NOCOPY NUMBER
49 , p_cost_batch_size IN NUMBER
50 , p_request_id IN NUMBER
51 , p_row_count OUT NOCOPY NUMBER
52 );
53
54
55 END CS_SR_COST_CP;