1 PACKAGE CN_SRP_PAYEE_ASSIGNS_PVT AUTHID CURRENT_USER as
2 /* $Header: cnvpspas.pls 120.0 2005/06/16 15:19:43 mblum noship $ */
3
4 -- Start of Comments
5 -- API name : Create_Srp_Payee_Assigns
6 -- Type : Private.
7 -- Pre-reqs : None.
8 -- Usage : Procedure to CREATE SRP PAYEE ASSIGNS
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Require
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_srp_quota_assign_id, p_payee_id,
18 -- p_start_date, p_end_date
19 -- OUT : x_return_status OUT VARCHAR2(1)
20 -- : x_msg_count OUT NUMBER
21 -- : x_msg_data OUT VARCHAR2(2000)
22 --
23 -- Version : Current version 1.0
24 -- Initial version 1.0
25 --
26 -- Notes : Srp_payee_assigns
27 -- Description :
28 -- Create_srp_payee_assigns is a PRIVATE API used to assign a payee to a
29 -- specific sales rep for a given comp plan, role, quota.
30 -- End of comments
31 --
32 PROCEDURE Create_Srp_Payee_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_quota_assign_id IN NUMBER,
41 p_payee_id IN NUMBER,
42 p_start_date IN DATE,
43 p_end_date IN DATE,
44 x_srp_payee_assign_id OUT NOCOPY NUMBER,
45 x_object_version_number OUT NOCOPY NUMBER,
46 x_loading_status OUT NOCOPY VARCHAR2
47 );
48
49 -- Start of Comments
50 -- API name : UPDATE_SRP_PAYEE_ASSIGNS
51 -- Type : Private.
52 -- Pre-reqs : None.
53 -- Usage : Procedure to UPDATE SRP PAYEE ASSIGNS
54 -- Parameters :
55 -- IN : p_api_version IN NUMBER Require
56 -- p_init_msg_list IN VARCHAR2 Optional
57 -- Default = FND_API.G_FALSE
58 -- p_commit IN VARCHAR2 Optional
59 -- Default = FND_API.G_FALSE
60 -- p_validation_level IN NUMBER Optional
61 -- Default = FND_API.G_VALID_LEVEL_FULL
62 -- IN SRP_PAYEE_ASGNS_REC_TBL_TYPE
63 -- OUT : x_return_status OUT VARCHAR2(1)
64 -- : x_msg_count OUT NUMBER
65 -- : x_msg_data OUT VARCHAR2(2000)
66 --
67 --
68 -- Version : Current version 1.0
69 -- Initial version 1.0
70 --
71 -- Notes : UPDATE_SRP_PAYEE_ASSIGNS
72 -- Description :
73 -- Update_srp_payee_assigns is a PRIVATE API used to update an existing
74 -- record.
75 -- End of comments
76 --
77 PROCEDURE Update_Srp_Payee_Assigns
78 ( p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80 p_commit IN VARCHAR2 := FND_API.G_FALSE,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_srp_payee_assign_id IN NUMBER,
86 p_payee_id IN NUMBER,
87 p_start_date IN DATE,
88 p_end_date IN DATE,
89 p_object_version_number IN OUT NOCOPY NUMBER,
90 x_loading_status OUT NOCOPY VARCHAR2
91 );
92
93 -- Start of Comments
94 -- API name : Valid_Delete_Srp_Payee_asgns
95 -- Type : Public.
96 -- Pre-reqs : None.
97 -- Usage : Procedure to validate a Delete a Srp Payee Assigns
98 -- Parameters :
99 -- IN : p_api_version IN NUMBER Require
100 -- p_init_msg_list IN VARCHAR2 Optional
101 -- Default = FND_API.G_FALSE
102 -- p_commit IN VARCHAR2 Optional
103 -- Default = FND_API.G_FALSE
104 -- p_validation_level IN NUMBER Optional
105 -- Default = FND_API.G_VALID_LEVEL_FULL
106 -- p_srp_payee_assign_id
107 -- OUT : x_return_status OUT VARCHAR2(1)
108 -- : x_msg_count OUT NUMBER
109 -- : x_msg_data OUT VARCHAR2(2000)
110 --
111 --
112 -- Version : Current version 1.0
113 -- Initial version 1.0
114 --
115 -- Notes : This procedure should be called before DELETE_SRP_PAYEE_ASSIGNS.
116 -- End of comments
117 --
118 PROCEDURE Valid_Delete_Srp_Payee_Assigns
119 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_srp_payee_assign_id IN NUMBER,
124 x_loading_status OUT NOCOPY VARCHAR2
125 );
126
127 -- Start of Comments
128 -- API name : Delete_Srp_Payee_asgns
129 -- Type : Public.
130 -- Pre-reqs : None.
131 -- Usage : Procedure to Delete a Srp Payee Assigns
132 -- Parameters :
133 -- IN : p_api_version IN NUMBER Require
134 -- p_init_msg_list IN VARCHAR2 Optional
135 -- Default = FND_API.G_FALSE
136 -- p_commit IN VARCHAR2 Optional
137 -- Default = FND_API.G_FALSE
138 -- p_validation_level IN NUMBER Optional
139 -- Default = FND_API.G_VALID_LEVEL_FULL
140 -- p_srp_payee_assign_id
141 -- OUT : x_return_status OUT VARCHAR2(1)
142 -- : x_msg_count OUT NUMBER
143 -- : x_msg_data OUT VARCHAR2(2000)
144 --
145 --
146 -- Version : Current version 1.0
147 -- Initial version 1.0
148 --
149 -- Notes : This Package procedure is Use to DELETE_SRP_PAYEE_ASSIGNS.
150 -- End of comments
151 --
152 PROCEDURE Delete_Srp_Payee_Assigns
153 ( p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_validation_level IN NUMBER
157 := FND_API.G_VALID_LEVEL_FULL,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_srp_payee_assign_id IN NUMBER,
162 x_loading_status OUT NOCOPY VARCHAR2
163 );
164
165 END CN_SRP_PAYEE_ASSIGNS_PVT ;