35: (cpg.pay_group_id = p_pay_group_id) order by cps.period_id;
36:
37:
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT Get_Pay_Group_Dtls;
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call
43: (l_api_version ,
37:
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT Get_Pay_Group_Dtls;
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call
43: (l_api_version ,
44: p_api_version ,
45: l_api_name ,
97: END IF;
98: END LOOP;
99:
100: -- End of API body.
101: -- Standard check of p_commit.
102: IF FND_API.To_Boolean( p_commit ) THEN
103: COMMIT WORK;
104: END IF;
105: -- Standard call to get message count and if count is 1, get message info.
101: -- Standard check of p_commit.
102: IF FND_API.To_Boolean( p_commit ) THEN
103: COMMIT WORK;
104: END IF;
105: -- Standard call to get message count and if count is 1, get message info.
106: FND_MSG_PUB.Count_And_Get
107: (p_count => x_msg_count ,
108: p_data => x_msg_data ,
109: p_encoded => FND_API.G_FALSE );
177: (cpg.pay_group_id = p_pay_group_id);
178:
179:
180: BEGIN
181: -- Standard Start of API savepoint
182: SAVEPOINT Get_Pay_Group_Sales;
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call
185: (l_api_version ,
179:
180: BEGIN
181: -- Standard Start of API savepoint
182: SAVEPOINT Get_Pay_Group_Sales;
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call
185: (l_api_version ,
186: p_api_version ,
187: l_api_name ,
236: END IF;
237: END LOOP;
238:
239: -- End of API body.
240: -- Standard check of p_commit.
241: IF FND_API.To_Boolean( p_commit ) THEN
242: COMMIT WORK;
243: END IF;
244: -- Standard call to get message count and if count is 1, get message info.
240: -- Standard check of p_commit.
241: IF FND_API.To_Boolean( p_commit ) THEN
242: COMMIT WORK;
243: END IF;
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get
246: (p_count => x_msg_count ,
247: p_data => x_msg_data ,
248: p_encoded => FND_API.G_FALSE );
322:
323:
324:
325: BEGIN
326: -- Standard Start of API savepoint
327: SAVEPOINT Get_Pay_Group_Roles;
328: -- Standard call to check for call compatibility.
329: IF NOT FND_API.Compatible_API_Call
330: (l_api_version ,
324:
325: BEGIN
326: -- Standard Start of API savepoint
327: SAVEPOINT Get_Pay_Group_Roles;
328: -- Standard call to check for call compatibility.
329: IF NOT FND_API.Compatible_API_Call
330: (l_api_version ,
331: p_api_version ,
332: l_api_name ,
386:
387: -- END IF;
388:
389: -- End of API body.
390: -- Standard check of p_commit.
391: IF FND_API.To_Boolean( p_commit ) THEN
392: COMMIT WORK;
393: END IF;
394: -- Standard call to get message count and if count is 1, get message info.
390: -- Standard check of p_commit.
391: IF FND_API.To_Boolean( p_commit ) THEN
392: COMMIT WORK;
393: END IF;
394: -- Standard call to get message count and if count is 1, get message info.
395: FND_MSG_PUB.Count_And_Get
396: (p_count => x_msg_count ,
397: p_data => x_msg_data ,
398: p_encoded => FND_API.G_FALSE );