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
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
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,
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,
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,
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,
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
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
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,
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,
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,
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,
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
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
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,
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,
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,
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,