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