1 PACKAGE CN_CALC_SUBMISSION_CUHK AS
2 /* $Header: cnccsbs.pls 120.1 2005/06/10 13:57:28 appldev $ */
3
4 -- Start of Comments
5 -- API name : Create_Calc_Submission_Pre
6 -- Type : Public.
7 -- Pre-reqs : None.
8 -- Usage : User hook before create a new compensation plan
9 -- or add the passed in plan element into an existing
10 -- compensation plan
11 -- Desc : Procedure to create a new compensation plan or add a plan
12 -- element to an existing compensation plan
13 -- Parameters :
14 -- IN : p_api_version IN NUMBER Require
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2(2000)
24 -- IN OUT : p_calc_submission_rec IN OUT calc_submission_rec_type
25 -- Version : Current version 1.0
26 -- Initial version 1.0
27 --
28 -- End of comments
29
30 PROCEDURE Create_Calc_Submission_Pre
31 (
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34 p_commit IN VARCHAR2 := FND_API.G_FALSE,
35 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_calc_submission_rec IN OUT NOCOPY cn_calc_submission_pub.calc_submission_rec_type,
40 x_loading_status OUT NOCOPY VARCHAR2
41 );
42
43 -- Start of Comments
44 -- API name : Create_Calc_Submission_Post
45 -- Type : Public.
46 -- Pre-reqs : None.
47 -- Usage : User hook before create a new compensation plan
48 -- or add the passed in plan element into an existing
49 -- compensation plan
50 -- Desc : Procedure to create a new compensation plan or add a plan
51 -- element to an existing compensation plan
52 -- Parameters :
53 -- IN : p_api_version IN NUMBER Require
54 -- p_init_msg_list IN VARCHAR2 Optional
55 -- Default = FND_API.G_FALSE
56 -- p_commit IN VARCHAR2 Optional
57 -- Default = FND_API.G_FALSE
58 -- p_validation_level IN NUMBER Optional
59 -- Default = FND_API.G_VALID_LEVEL_FULL
60 -- OUT : x_return_status OUT VARCHAR2(1)
61 -- x_msg_count OUT NUMBER
62 -- x_msg_data OUT VARCHAR2(2000)
63 -- IN : p_calc_submission_rec IN calc_submission_rec_type
64 -- Version : Current version 1.0
65 -- Initial version 1.0
66 --
67 -- End of comments
68
69 PROCEDURE Create_Calc_Submission_Post
70 (
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_calc_submission_rec IN cn_calc_submission_pub.calc_submission_rec_type,
79 x_loading_status OUT NOCOPY VARCHAR2
80 );
81
82
83 -- Start of Comments
84 -- API name : Ok_To_Generate_Msg
85 -- Type : Public.
86 -- Pre-reqs : None.
87 -- Usage : Judge whether it is ok to generate message or not
88 -- Parameters :
89
90 --
91 -- Version : Current version 1.0
92 -- Initial version 1.0
93 -- IN p_calc_submission_rec IN cn_calc_submission_pub.calc_submission_rec_type,
94 --
95 -- End of comments
96 --
97 FUNCTION Ok_To_Generate_Msg
98 (
99 p_calc_submission_rec IN cn_calc_submission_pub.calc_submission_rec_type
100 ) RETURN BOOLEAN;
101
102 END CN_CALC_SUBMISSION_CUHK ;