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.2 2008/09/17 12:15:59 rgokavar ship $ */
3:
4: --------------------------------------
5: -- declaration of private data types

Line 1022: l_dsg_code := hz_dss_util_pub.determine_dss_group(

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

Line 1265: x_granted_groups HZ_DSS_UTIL_PUB.dss_group_tbl_type;

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

Line 1286: HZ_DSS_UTIL_PUB.get_granted_groups (

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

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

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

Line 2313: END HZ_DSS_UTIL_PUB;

2309: RETURN l_return;
2310:
2311: END get_display_name;
2312:
2313: END HZ_DSS_UTIL_PUB;