APPS.HZ_DSS_UTIL_PUB dependencies on HZ_DSS_UTIL_PUB

Line 1: PACKAGE BODY HZ_DSS_UTIL_PUB AS

1: PACKAGE BODY HZ_DSS_UTIL_PUB AS
2: /* $Header: ARHPDSUB.pls 120.13.12010000.4 2010/03/25 10:57:39 rgokavar ship $ */
3:
4: --------------------------------------
5: -- declaration of private data types

Line 1021: l_dsg_code := hz_dss_util_pub.determine_dss_group(

1017: exit;
1018: close get_grp_assign_level;
1019: else
1020: ---Determine the DSG
1021: l_dsg_code := hz_dss_util_pub.determine_dss_group(
1022: p_db_object_name,
1023: p_object_pk1,
1024: p_object_pk2,
1025: p_object_pk3,

Line 1264: x_granted_groups HZ_DSS_UTIL_PUB.dss_group_tbl_type;

1260: x_return_status OUT NOCOPY VARCHAR2,
1261: x_msg_count OUT NOCOPY NUMBER,
1262: x_msg_data OUT NOCOPY VARCHAR2)IS
1263:
1264: x_granted_groups HZ_DSS_UTIL_PUB.dss_group_tbl_type;
1265:
1266: i number;
1267: l_user_name fnd_user.user_name%type;
1268: l_return_status VARCHAR2(1);

Line 1285: HZ_DSS_UTIL_PUB.get_granted_groups (

1281: --clear the temporary table
1282: ---delete from HZ_DSS_GROUP_CACHE ;
1283:
1284: --determine the DSG's that the user has SELECT access to
1285: HZ_DSS_UTIL_PUB.get_granted_groups (
1286: l_user_name,
1287: 'SELECT',
1288: x_granted_groups,
1289: l_return_status,

Line 1410: l_sql := 'hz_dss_util_pub.determine_dss_group(' ||

1406: FETCH c_find_objects INTO l_object_name, l_string;
1407: CLOSE c_find_objects;
1408:
1409: ---Determine the DSG
1410: l_sql := 'hz_dss_util_pub.determine_dss_group(' ||
1411: ''''||l_object_name||'''' || ',' ||
1412: l_string ||
1413: ') = ' || ''''||p_dss_group_code || '''';
1414:

Line 2453: END HZ_DSS_UTIL_PUB;

2449: RETURN l_return;
2450:
2451: END get_display_name;
2452:
2453: END HZ_DSS_UTIL_PUB;