DBA Data[Home] [Help]

APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on STANDARD

Line 198: -- Standard Start of API savepoint

194:
195: l_has_access BOOLEAN;
196:
197: BEGIN
198: -- Standard Start of API savepoint
199: SAVEPOINT Submit_Worksheet;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.compatible_api_call
202: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

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

196:
197: BEGIN
198: -- Standard Start of API savepoint
199: SAVEPOINT Submit_Worksheet;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.compatible_api_call
202: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
203: THEN
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 245: -- Standard check of p_commit.

241: p_resource_id => l_resource_id,
242: p_user_email => l_user_email);
243:
244: -- End of API body.
245: -- Standard check of p_commit.
246: IF FND_API.To_Boolean( p_commit ) THEN
247: COMMIT WORK;
248: END IF;
249: -- Standard call to get message count and if count is 1, get message info.

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

245: -- Standard check of p_commit.
246: IF FND_API.To_Boolean( p_commit ) THEN
247: COMMIT WORK;
248: END IF;
249: -- Standard call to get message count and if count is 1, get message info.
250: FND_MSG_PUB.Count_And_Get
251: (p_count => x_msg_count ,
252: p_data => x_msg_data ,
253: p_encoded => FND_API.G_FALSE);

Line 320: -- Standard Start of API savepoint

316:
317: l_has_access BOOLEAN;
318:
319: BEGIN
320: -- Standard Start of API savepoint
321: SAVEPOINT Approve_Worksheet;
322: -- Standard call to check for call compatibility.
323: IF NOT FND_API.compatible_api_call
324: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

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

318:
319: BEGIN
320: -- Standard Start of API savepoint
321: SAVEPOINT Approve_Worksheet;
322: -- Standard call to check for call compatibility.
323: IF NOT FND_API.compatible_api_call
324: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 372: -- Standard check of p_commit.

368: p_resource_id => l_resource_id,
369: p_user_email => l_user_email);
370:
371: -- End of API body.
372: -- Standard check of p_commit.
373: IF FND_API.To_Boolean( p_commit ) THEN
374: COMMIT WORK;
375: END IF;
376: -- Standard call to get message count and if count is 1, get message info.

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

372: -- Standard check of p_commit.
373: IF FND_API.To_Boolean( p_commit ) THEN
374: COMMIT WORK;
375: END IF;
376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.Count_And_Get
378: (p_count => x_msg_count ,
379: p_data => x_msg_data ,
380: p_encoded => FND_API.G_FALSE);

Line 447: -- Standard Start of API savepoint

443:
444: l_has_access BOOLEAN;
445:
446: BEGIN
447: -- Standard Start of API savepoint
448: SAVEPOINT Reject_Worksheet;
449: -- Standard call to check for call compatibility.
450: IF NOT FND_API.compatible_api_call
451: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

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

445:
446: BEGIN
447: -- Standard Start of API savepoint
448: SAVEPOINT Reject_Worksheet;
449: -- Standard call to check for call compatibility.
450: IF NOT FND_API.compatible_api_call
451: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
452: THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 491: -- Standard check of p_commit.

487: WHERE payment_worksheet_id = p_worksheet_id
488: ;
489:
490: -- End of API body.
491: -- Standard check of p_commit.
492: IF FND_API.To_Boolean( p_commit ) THEN
493: COMMIT WORK;
494: END IF;
495: -- Standard call to get message count and if count is 1, get message info.

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

491: -- Standard check of p_commit.
492: IF FND_API.To_Boolean( p_commit ) THEN
493: COMMIT WORK;
494: END IF;
495: -- Standard call to get message count and if count is 1, get message info.
496: FND_MSG_PUB.Count_And_Get
497: (p_count => x_msg_count ,
498: p_data => x_msg_data ,
499: p_encoded => FND_API.G_FALSE);

Line 561: -- Standard Start of API savepoint

557:
558: l_has_access BOOLEAN;
559:
560: BEGIN
561: -- Standard Start of API savepoint
562: SAVEPOINT Pay_Payrun_Flow;
563: -- Standard call to check for call compatibility.
564: IF NOT FND_API.compatible_api_call
565: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

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

559:
560: BEGIN
561: -- Standard Start of API savepoint
562: SAVEPOINT Pay_Payrun_Flow;
563: -- Standard call to check for call compatibility.
564: IF NOT FND_API.compatible_api_call
565: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
566: THEN
567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 592: -- Standard check of p_commit.

588: DELETE FROM cn_pay_approval_flow
589: WHERE payrun_id = p_payrun_id
590: ;
591: -- End of API body.
592: -- Standard check of p_commit.
593: IF FND_API.To_Boolean( p_commit ) THEN
594: COMMIT WORK;
595: END IF;
596: -- Standard call to get message count and if count is 1, get message info.

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

592: -- Standard check of p_commit.
593: IF FND_API.To_Boolean( p_commit ) THEN
594: COMMIT WORK;
595: END IF;
596: -- Standard call to get message count and if count is 1, get message info.
597: FND_MSG_PUB.Count_And_Get
598: (p_count => x_msg_count ,
599: p_data => x_msg_data ,
600: p_encoded => FND_API.G_FALSE);