DBA Data[Home] [Help]

APPS.HZ_DSS_GRANTS_PUB dependencies on STANDARD

Line 441: -- standard start of API savepoint

437:
438: -- initialize API return status to success.
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: -- standard start of API savepoint
442: SAVEPOINT create_grant;
443:
444: OPEN c_dss_groups;
445: FETCH c_dss_groups INTO l_dsg_status;

Line 502: -- standard call to get message count and if count is 1, get message info.

498: p_grant_end_date => l_end_date
499: );
500: END IF;
501:
502: -- standard call to get message count and if count is 1, get message info.
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);

Line 623: -- standard start of API savepoint

619: IF l_dsg_status IS NULL THEN
620: RETURN;
621: END IF;
622:
623: -- standard start of API savepoint
624: SAVEPOINT create_grant;
625:
626: --
627: -- get object name

Line 697: -- standard call to get message count and if count is 1, get message info.

693: END LOOP;
694:
695: END LOOP;
696:
697: -- standard call to get message count and if count is 1, get message info.
698: FND_MSG_PUB.Count_And_Get(
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data);

Line 802: -- standard start of API savepoint

798:
799: -- initialize API return status to success.
800: x_return_status := FND_API.G_RET_STS_SUCCESS;
801:
802: -- standard start of API savepoint
803: SAVEPOINT update_grant;
804:
805: --
806: -- Get the current state of the grants for this grantee/dsg

Line 938: -- standard call to get message count and if count is 1, get message info.

934: p_dss_grantee_key => p_dss_grantee_key
935: );
936: END IF;
937:
938: -- standard call to get message count and if count is 1, get message info.
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data);

Line 1040: -- standard start of API savepoint

1036:
1037: -- initialize API return status to success.
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: -- standard start of API savepoint
1041: SAVEPOINT update_grant;
1042:
1043: OPEN c_grants;
1044: LOOP

Line 1081: -- standard call to get message count and if count is 1, get message info.

1077:
1078: END LOOP;
1079: CLOSE c_grants;
1080:
1081: -- standard call to get message count and if count is 1, get message info.
1082: FND_MSG_PUB.Count_And_Get(
1083: p_encoded => FND_API.G_FALSE,
1084: p_count => x_msg_count,
1085: p_data => x_msg_data);

Line 1184: -- standard start of API savepoint

1180:
1181: -- initialize API return status to success.
1182: x_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: -- standard start of API savepoint
1185: SAVEPOINT update_grant;
1186:
1187: --
1188: -- set the end date to null when the dss group and the secured

Line 1226: -- standard call to get message count and if count is 1, get message info.

1222:
1223: END LOOP;
1224: CLOSE c_grants;
1225:
1226: -- standard call to get message count and if count is 1, get message info.
1227: FND_MSG_PUB.Count_And_Get(
1228: p_encoded => FND_API.G_FALSE,
1229: p_count => x_msg_count,
1230: p_data => x_msg_data);

Line 1364: -- standard call to get message count and if count is 1, get message info.

1360: WHEN NO_DATA_FOUND THEN
1361: NULL;
1362: END;
1363:
1364: -- standard call to get message count and if count is 1, get message info.
1365: FND_MSG_PUB.Count_And_Get(
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,
1368: p_data => x_msg_data);