1 PACKAGE CN_SRP_PLAN_ASSIGNS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnvspas.pls 115.7 2002/11/21 21:18:38 hlchen ship $ */
3
4 -- Global variable for the translatable name for all Plan Assign objects.
5
6 -- Start of comments
7 -- API name : Create_Srp_Plan_Assigns
8 -- Type : Public.
9 -- Pre-reqs : None.
10 -- Usage : Used to create a new comp plan assignment to an salesrep
11 -- Desc : Procedure to create a new comp plan assignment to an salesrep
12 -- Parameters :
13 -- IN : p_api_version IN NUMBER Require
14 -- p_init_msg_list IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- p_commit IN VARCHAR2 Optional
17 -- Default = FND_API.G_FALSE
18 -- p_validation_level IN NUMBER Optional
19 -- Default = FND_API.G_VALID_LEVEL_FULL
20 -- OUT : x_return_status OUT VARCHAR2(1)
21 -- x_msg_count OUT NUMBER
22 -- x_msg_data OUT VARCHAR2(2000)
23 -- IN : p_srp_role_id IN NUMBER,
24 -- p_role_plan_id IN NUMBER,
25 -- p_attribute_rec IN cn.attribute_rec_type
26 -- OUT : x_srp_plan_assign_id OUT NUMBER
27 -- Version : Current version 1.0
28 -- Initial version 1.0
29 --
30 -- End of comments
31
32 PROCEDURE Create_Srp_Plan_Assigns
33 (p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_srp_role_id IN NUMBER,
41 p_role_plan_id IN NUMBER,
42 p_attribute_rec IN cn_global_var.attribute_rec_type := CN_GLOBAL_VAR.G_MISS_ATTRIBUTE_REC,
43 x_srp_plan_assign_id OUT NOCOPY NUMBER,
44 x_loading_status OUT NOCOPY VARCHAR2
45 );
46
47 -- Start of comments
48 -- API name : Update_Srp_Plan_Assigns
49 -- Type : Public.
50 -- Pre-reqs : None.
51 -- Usage : Used to update comp plan assignment of an salesrep
52 -- Desc : Procedure to update comp plan assignment of an salesrep
53 -- Parameters :
54 -- IN : p_api_version IN NUMBER Require
55 -- p_init_msg_list IN VARCHAR2 Optional
56 -- Default = FND_API.G_FALSE
57 -- p_commit IN VARCHAR2 Optional
58 -- Default = FND_API.G_FALSE
59 -- p_validation_level IN NUMBER Optional
60 -- Default = FND_API.G_VALID_LEVEL_FULL
61 -- OUT : x_return_status OUT VARCHAR2(1)
62 -- x_msg_count OUT NUMBER
63 -- x_msg_data OUT VARCHAR2(2000)
64 -- IN : p_srp_role_id IN NUMBER,
65 -- p_role_plan_id IN NUMBER,
66 -- p_attribute_rec IN cn.attribute_rec_type
67 -- : p_srp_plan_assign_id IN NUMBER
68 -- Version : Current version 1.0
69 -- Initial version 1.0
70 --
71 -- End of comments
72
73 PROCEDURE Update_Srp_Plan_Assigns
74 (p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_srp_role_id IN NUMBER,
82 p_role_plan_id IN NUMBER,
83 p_attribute_rec IN cn_global_var.attribute_rec_type := cn_global_var.g_miss_attribute_rec,
84 x_loading_status OUT NOCOPY VARCHAR2
85 );
86
87 -- Start of comments
88 -- API name : Delete_Srp_Plan_Assigns
89 -- Type : Public.
90 -- Pre-reqs : None.
91 -- Usage : Used to delete comp plan assignment of an salesrep
92 -- Desc : Procedure to delete comp plan assignment of an salesrep
93 -- Parameters :
94 -- IN : p_api_version IN NUMBER Require
95 -- p_init_msg_list IN VARCHAR2 Optional
96 -- Default = FND_API.G_FALSE
97 -- p_commit IN VARCHAR2 Optional
98 -- Default = FND_API.G_FALSE
99 -- p_validation_level IN NUMBER Optional
100 -- Default = FND_API.G_VALID_LEVEL_FULL
101 -- OUT : x_return_status OUT VARCHAR2(1)
102 -- x_msg_count OUT NUMBER
103 -- x_msg_data OUT VARCHAR2(2000)
104 -- IN : p_srp_role_id IN NUMBER,
105 -- p_role_plan_id IN NUMBER,
106 -- Version : Current version 1.0
107 -- Initial version 1.0
108 --
109 -- End of comments
110
111 PROCEDURE Delete_Srp_Plan_Assigns
112 (p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_srp_role_id IN NUMBER,
120 p_role_plan_id IN NUMBER,
121 x_loading_status OUT NOCOPY VARCHAR2
122 );
123
124 END CN_SRP_PLAN_ASSIGNS_PVT ;
125