DBA Data[Home] [Help]

APPS.HZ_TAX_ASSIGNMENT_PUB dependencies on STANDARD

Line 70: into arp_standard.sysparm

66:
67: BEGIN
68:
69: select * /* Bug Fix 2020712 */
70: into arp_standard.sysparm
71: from ar_system_parameters;
72:
73: -- check org context
74: -- if org context is not available then no record will be created in

Line 218: IF l_country = arp_standard.sysparm.default_country AND

214:
215: -- run validation for default country.
216: -- Added additional condition to check whether
217: -- this is for Remit-To Address or not.
218: IF l_country = arp_standard.sysparm.default_country AND
219: l_is_remit_to_location <> 'Y' THEN
220:
221: arp_adds.Set_Location_CCID(l_country,
222: l_city,

Line 454: --Standard start of API savepoint

450: l_location_id NUMBER := p_location_id;
451: APP_EXCEPTION EXCEPTION;
452: PRAGMA EXCEPTION_INIT(APP_EXCEPTION, -20000);
453: BEGIN
454: --Standard start of API savepoint
455: SAVEPOINT create_loc_assignment_pub;
456: --Standard call to check for call compatibility.
457: IF NOT FND_API.Compatible_API_Call(
458: l_api_version,

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

452: PRAGMA EXCEPTION_INIT(APP_EXCEPTION, -20000);
453: BEGIN
454: --Standard start of API savepoint
455: SAVEPOINT create_loc_assignment_pub;
456: --Standard call to check for call compatibility.
457: IF NOT FND_API.Compatible_API_Call(
458: l_api_version,
459: p_api_version,
460: l_api_name,

Line 503: --Standard check of p_commit.

499: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502:
503: --Standard check of p_commit.
504: IF FND_API.to_Boolean(p_commit) THEN
505: Commit;
506: END IF;
507:

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

504: IF FND_API.to_Boolean(p_commit) THEN
505: Commit;
506: END IF;
507:
508: --Standard call to get message count and if count is 1, get message info.
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data);

Line 574: --Standard start of API savepoint

570: APP_EXCEPTION EXCEPTION;
571: PRAGMA EXCEPTION_INIT(APP_EXCEPTION, -20000);
572:
573: BEGIN
574: --Standard start of API savepoint
575: SAVEPOINT update_loc_assignment_pub;
576: --Standard call to check for call compatibility.
577: IF NOT FND_API.Compatible_API_Call(
578: l_api_version,

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

572:
573: BEGIN
574: --Standard start of API savepoint
575: SAVEPOINT update_loc_assignment_pub;
576: --Standard call to check for call compatibility.
577: IF NOT FND_API.Compatible_API_Call(
578: l_api_version,
579: p_api_version,
580: l_api_name,

Line 622: --Standard check of p_commit.

618: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:
622: --Standard check of p_commit.
623: IF FND_API.to_Boolean(p_commit) THEN
624: Commit;
625: END IF;
626:

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

623: IF FND_API.to_Boolean(p_commit) THEN
624: Commit;
625: END IF;
626:
627: --Standard call to get message count and if count is 1, get message info.
628: FND_MSG_PUB.Count_And_Get(
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_msg_count,
631: p_data => x_msg_data);