DBA Data[Home] [Help]

APPS.PSB_PAY_ELEMENT_RATES_PVT dependencies on STANDARD

Line 71: -- Standard Start of API savepoint

67: where pay_element_rate_id = p_pay_element_rate_id ;
68:
69: BEGIN
70:
71: -- Standard Start of API savepoint
72:
73: SAVEPOINT INSERT_ROW_PVT;
74:
75: -- Standard call to check for call compatibility.

Line 75: -- Standard call to check for call compatibility.

71: -- Standard Start of API savepoint
72:
73: SAVEPOINT INSERT_ROW_PVT;
74:
75: -- Standard call to check for call compatibility.
76:
77: if not FND_API.Compatible_API_Call (l_api_version,
78: p_api_version,
79: l_api_name,

Line 150: -- Standard check of p_commit.

146: raise no_data_found;
147: end if;
148: -- End of API body.
149:
150: -- Standard check of p_commit.
151:
152: if FND_API.to_Boolean (p_commit) then
153: commit work;
154: end if;

Line 156: -- Standard call to get message count and if count is 1, get message info.

152: if FND_API.to_Boolean (p_commit) then
153: commit work;
154: end if;
155:
156: -- Standard call to get message count and if count is 1, get message info.
157:
158: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
159: p_data => p_msg_data);
160:

Line 231: -- Standard Start of API savepoint

227: l_api_version CONSTANT NUMBER := 1.0;
228:
229: BEGIN
230:
231: -- Standard Start of API savepoint
232:
233: SAVEPOINT UPDATE_ROW_PVT;
234:
235: -- Standard call to check for call compatibility.

Line 235: -- Standard call to check for call compatibility.

231: -- Standard Start of API savepoint
232:
233: SAVEPOINT UPDATE_ROW_PVT;
234:
235: -- Standard call to check for call compatibility.
236:
237: if not FND_API.Compatible_API_Call (l_api_version,
238: p_api_version,
239: l_api_name,

Line 277: -- Standard check of p_commit.

273: end if;
274:
275: -- End of API body.
276:
277: -- Standard check of p_commit.
278:
279: if FND_API.to_Boolean (p_commit) then
280: commit work;
281: end if;

Line 283: -- Standard call to get message count and if count is 1, get message info.

279: if FND_API.to_Boolean (p_commit) then
280: commit work;
281: end if;
282:
283: -- Standard call to get message count and if count is 1, get message info.
284:
285: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
286: p_data => p_msg_data);
287:

Line 346: -- Standard Start of API savepoint

342: l_api_version CONSTANT NUMBER := 1.0;
343:
344: BEGIN
345:
346: -- Standard Start of API savepoint
347:
348: SAVEPOINT DELETE_ROW_PVT;
349:
350: -- Standard call to check for call compatibility.

Line 350: -- Standard call to check for call compatibility.

346: -- Standard Start of API savepoint
347:
348: SAVEPOINT DELETE_ROW_PVT;
349:
350: -- Standard call to check for call compatibility.
351:
352: if not FND_API.Compatible_API_Call (l_api_version,
353: p_api_version,
354: l_api_name,

Line 376: -- Standard call to get message count and if count is 1, get message info.

372: if (SQL%NOTFOUND) then
373: RAISE NO_DATA_FOUND;
374: end if;
375:
376: -- Standard call to get message count and if count is 1, get message info.
377:
378: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
379: p_data => p_msg_data);
380:

Line 381: -- Standard check of p_commit.

377:
378: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
379: p_data => p_msg_data);
380:
381: -- Standard check of p_commit.
382:
383: if FND_API.to_Boolean (p_commit) then
384: commit work;
385: end if;

Line 619: -- Standard Start of API savepoint

615: l_api_version CONSTANT NUMBER := 1.0;
616:
617: BEGIN
618:
619: -- Standard Start of API savepoint
620:
621: SAVEPOINT Delete_Element_Rates_Pvt;
622:
623:

Line 624: -- Standard call to check for call compatibility

620:
621: SAVEPOINT Delete_Element_Rates_Pvt;
622:
623:
624: -- Standard call to check for call compatibility
625:
626: if not FND_API.Compatible_API_Call (l_api_version,
627: p_api_version,
628: l_api_name,

Line 645: -- Standard check of p_commit

641: delete from PSB_PAY_ELEMENT_RATES
642: where worksheet_id = p_worksheet_id;
643:
644:
645: -- Standard check of p_commit
646:
647: if FND_API.to_Boolean (p_commit) then
648: commit work;
649: end if;

Line 657: -- Standard call to get message count and if count is 1, get message info

653:
654: p_return_status := FND_API.G_RET_STS_SUCCESS;
655:
656:
657: -- Standard call to get message count and if count is 1, get message info
658:
659: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
660: p_data => p_msg_data);
661:

Line 772: -- Standard Start of API savepoint

768: l_return_status VARCHAR2(1);
769:
770: BEGIN
771:
772: -- Standard Start of API savepoint
773:
774: SAVEPOINT Modify_Element_Rates_Pvt;
775:
776:

Line 777: -- Standard call to check for call compatibility

773:
774: SAVEPOINT Modify_Element_Rates_Pvt;
775:
776:
777: -- Standard call to check for call compatibility
778:
779: if not FND_API.Compatible_API_Call (l_api_version,
780: p_api_version,
781: l_api_name,

Line 1139: -- Standard check of p_commit

1135: end;
1136: end if;
1137:
1138:
1139: -- Standard check of p_commit
1140:
1141: if FND_API.to_Boolean (p_commit) then
1142: commit work;
1143: end if;

Line 1151: -- Standard call to get message count and if count is 1, get message info

1147:
1148: p_return_status := FND_API.G_RET_STS_SUCCESS;
1149:
1150:
1151: -- Standard call to get message count and if count is 1, get message info
1152:
1153: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1154: p_data => p_msg_data);
1155: