1 PACKAGE CN_CALC_SUBMISSION_PVT AS
2 /*$Header: cnvsbcss.pls 120.2 2005/07/14 17:31:33 ymao ship $*/
3
4 -- Start of comments
5 -- API name : Validate
6 -- Type : Private.
7 -- Function :
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- p_calc_sub_batch_id IN NUMBER Required
18 -- OUT : x_return_status OUT VARCHAR2(1)
19 -- x_msg_count OUT NUMBER
20 -- x_msg_data OUT VARCHAR2(2000)
21 -- Version : Current version 1.0
22 -- Initial version 1.0
23 --
24 -- Notes : 1) Validate a calculation submission batch
25 --
26 -- End of comments
27
28 PROCEDURE Validate
29 (p_api_version IN NUMBER ,
30 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
31 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
32 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE);
37
38 -- Start of comments
39 -- API name : Calculate
40 -- Type : Private.
41 -- Function :
42 -- Pre-reqs : None.
43 -- Parameters :
44 -- IN : p_api_version IN NUMBER Required
45 -- p_init_msg_list IN VARCHAR2 Optional
46 -- Default = FND_API.G_FALSE
47 -- p_validation_level IN NUMBER Optional
48 -- Default = FND_API.G_VALID_LEVEL_FULL
49 -- p_calc_sub_batch_id IN NUMBER Required
50 -- OUT : x_return_status OUT VARCHAR2(1)
51 -- x_msg_count OUT NUMBER
52 -- x_msg_data OUT VARCHAR2(2000)
53 -- Version : Current version 1.0
54 -- Initial version 1.0
55 --
56 -- Notes : 1) Process a calculation submission batch. This process commits automatically.
57 --
58 -- End of comments
59
60 -- Start of comments
61 -- API name : CopyBatch
62 -- Type : Private.
63 -- Function :
64 -- Pre-reqs : None.
65 -- Parameters :
66 -- IN : p_api_version IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional
68 -- Default = FND_API.G_FALSE
69 -- p_commit IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional
72 -- Default = FND_API.G_VALID_LEVEL_FULL
73 -- p_calc_sub_batch_id IN NUMBER Required
74 --
75
76 -- OUT : x_return_status OUT VARCHAR2(1)
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2(2000)
79 -- p_out_calc_sub_batch_id OUT NOCOPY cn_calc_submission_batches.calc_sub_batch_id%TYPE);
80 -- Version : Current version 1.0
81 -- Initial version 1.0
82 --
83 -- Notes : 1) Validate a calculation submission batch
84 --
85 -- End of comments
86
87 PROCEDURE CopyBatch
88 (p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2,
90 p_commit IN VARCHAR2,
91 p_validation_level IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE,
96 p_out_calc_sub_batch_id OUT NOCOPY cn_calc_submission_batches.calc_sub_batch_id%TYPE);
97
98
99 PROCEDURE Calculate
100 (p_api_version IN NUMBER ,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE);
107
108 -- This procedure should be invoked only when retrieving calculation batch records in response to a search request
109 -- from the calculation batch search page.
110 PROCEDURE maintain_batch_status ;
111
112 END CN_CALC_SUBMISSION_PVT;