APPS.HZ_DSS_GRANTS_PUB dependencies on FND_GRANTS

Line 242: fnd_grants_pkg.grant_function (

238: --
239:
240: l_base_instance_set_id := obtain_dss_instance_set_id (p_dss_group_code);
241:
242: fnd_grants_pkg.grant_function (
243: p_api_version => 1,
244: p_menu_name => l_menu_name,
245: p_object_name => 'HZ_DSS_GROUPS',
246: p_instance_type => 'SET',

Line 276: fnd_grants_pkg.grant_function (

272: ELSE
273: l_end_date := SYSDATE;
274: END IF;
275:
276: fnd_grants_pkg.grant_function (
277: p_api_version => 1,
278: p_menu_name => l_menu_name,
279: p_object_name => l_secured_entity.obj_name,
280: p_instance_type => 'SET',

Line 335: FROM fnd_grants grants,

331: g_procedure_name VARCHAR2(30) := 'DO_REVOKE_FND_GRANT';
332:
333: CURSOR c_fnd_grant IS
334: SELECT grant_guid
335: FROM fnd_grants grants,
336: fnd_menus menu
337: WHERE grants.menu_id = menu.menu_id
338: AND menu.menu_name = 'HZ_DSS_'||p_data_operation_code
339: AND program_tag = p_dss_group_code

Line 363: fnd_grants_pkg.revoke_grant(

359: IF c_fnd_grant%NOTFOUND THEN
360: EXIT;
361: END IF;
362:
363: fnd_grants_pkg.revoke_grant(
364: p_api_version => 1,
365: p_grant_guid => l_fnd_grant_guid,
366: x_success => l_fnd_success,
367: x_errorcode => l_fnd_errorcode

Line 670: fnd_grants_pkg.grant_function (

666:
667: IF l_menu_name IS NOT NULL THEN
668: l_menu_name := 'HZ_DSS_' || l_menu_name;
669:
670: fnd_grants_pkg.grant_function (
671: p_api_version => 1,
672: p_menu_name => l_menu_name,
673: p_object_name => l_obj_name,
674: p_instance_type => 'SET',

Line 1013: FROM fnd_grants grants,

1009: CURSOR c_grants IS
1010: SELECT grants.grant_guid,
1011: grants.start_date,
1012: dse.status
1013: FROM fnd_grants grants,
1014: fnd_object_instance_sets ins,
1015: hz_dss_secured_entities dse
1016: WHERE grants.program_name = G_API_NAME
1017: AND grants.program_tag = p_dss_group_code

Line 1065: fnd_grants_pkg.update_grant (

1061: ELSE
1062: l_end_date := NULL;
1063: END IF;
1064:
1065: fnd_grants_pkg.update_grant (
1066: p_api_version => 1,
1067: p_grant_guid => l_fnd_grant_guid,
1068: p_start_date => l_start_date,
1069: p_end_date => l_end_date,

Line 1161: FROM fnd_grants grants

1157:
1158: CURSOR c_grants IS
1159: SELECT grants.grant_guid,
1160: grants.start_date
1161: FROM fnd_grants grants
1162: WHERE grants.program_name = G_API_NAME
1163: AND grants.program_tag = p_dss_group_code
1164: AND grants.instance_set_id = p_dss_instance_set_id;
1165:

Line 1210: fnd_grants_pkg.update_grant (

1206: IF c_grants%NOTFOUND THEN
1207: EXIT;
1208: END IF;
1209:
1210: fnd_grants_pkg.update_grant (
1211: p_api_version => 1,
1212: p_grant_guid => l_fnd_grant_guid,
1213: p_start_date => l_start_date,
1214: p_end_date => l_end_date,