DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on FND_GRANTS_PKG

Line 1114: fnd_grants_pkg.grant_function

1110:
1111: --dbms_output.put_line('before calling grant_function');
1112: --dbms_output.put_line('l_grantee_key: '||l_grantee_key);
1113:
1114: fnd_grants_pkg.grant_function
1115: (
1116: p_api_version => l_api_version,
1117: p_menu_name => l_default_menu_name,
1118: p_object_name => 'PA_PROJECTS',

Line 1154: fnd_grants_pkg.grant_function

1150: FOR i IN l_status_code_tbl.FIRST .. l_status_code_tbl.LAST LOOP
1151:
1152: --dbms_output.put_line('status menu name: '||l_menu_name_tbl(i));
1153:
1154: fnd_grants_pkg.grant_function
1155: (
1156: p_api_version => l_api_version,
1157: p_menu_name => l_menu_name_tbl(i),
1158: p_object_name => 'PA_PROJECTS',

Line 1281: fnd_grants_pkg.grant_function

1277: l_instance_pk1_value:=null;
1278: l_object_key_type:='SET';
1279: end if;
1280:
1281: fnd_grants_pkg.grant_function
1282: (
1283: p_api_version =>l_api_version,
1284: p_menu_name =>v_menu_name,
1285: p_object_name =>p_object_name,

Line 1341: fnd_grants_pkg.revoke_grant

1337: x_return_status :=fnd_api.g_ret_sts_success;
1338: x_msg_count:=0;
1339: x_msg_data :=null;
1340: --dbms_output.put_line('inside pa revoke_grants');
1341: fnd_grants_pkg.revoke_grant
1342: (
1343: p_api_version =>l_api_version,
1344: p_grant_guid =>p_grant_guid,
1345: x_success =>l_success,

Line 1429: fnd_grants_pkg.revoke_grant(

1425: instance_pk1_value=TO_CHAR(p_object_key)) OR
1426: (l_object_key_type='SET' AND
1427: instance_set_id=p_object_key));
1428:
1429: fnd_grants_pkg.revoke_grant(
1430: p_api_version => l_api_version,
1431: p_grant_guid => l_grant_guid,
1432: x_success => l_success,
1433: x_errorcode => l_error_code);

Line 1499: fnd_grants_pkg.update_grant

1495:
1496: x_return_status:=fnd_api.g_ret_sts_success;
1497: x_msg_count:=0;
1498: x_msg_data:=null;
1499: fnd_grants_pkg.update_grant
1500: (
1501: p_api_version =>l_api_version,
1502: p_grant_guid =>p_grant_guid,
1503: p_start_date =>p_start_date_new,

Line 1576: fnd_grants_pkg.lock_grant

1572: into l_object_id
1573: from fnd_objects
1574: where obj_name=p_object_name;
1575:
1576: fnd_grants_pkg.lock_grant
1577: (
1578: p_grant_guid =>p_grant_guid,
1579: p_menu_id =>v_menu_id,
1580: -- p_grantee_key =>'PER:'||to_char(p_party_id),

Line 2356: fnd_grants_pkg.grant_function

2352: --dbms_output.put_line('------------------------------');
2353: --dbms_output.put_line('grantee_key: ' || l_grantee_key);
2354:
2355: -- insert new records into FND_GRANTS
2356: fnd_grants_pkg.grant_function
2357: (
2358: p_api_version => l_api_version, -- Modified the parameter from '1.0' to l_api_version: Bug #3983570
2359: p_menu_name => l_default_menu_name,
2360: p_object_name => 'PA_PROJECTS',

Line 2392: fnd_grants_pkg.grant_function

2388: IF l_status_code_tbl IS NOT NULL AND l_status_code_tbl.COUNT > 0 THEN
2389:
2390: FOR i IN l_status_code_tbl.FIRST..l_status_code_tbl.LAST LOOP
2391:
2392: fnd_grants_pkg.grant_function
2393: (
2394: p_api_version => l_api_version, -- Modified the parameter from '1.0' to l_api_version: Bug #3983570
2395: p_menu_name => l_menu_name_tbl(i),
2396: p_object_name => 'PA_PROJECTS',

Line 2572: fnd_grants_pkg.grant_function

2568: l_grantee_key := res.grantee_key;
2569:
2570: FOR i IN p_new_status_code_tbl.FIRST..p_new_status_code_tbl.LAST LOOP
2571:
2572: fnd_grants_pkg.grant_function
2573: (
2574: p_api_version => l_api_version, -- Modified the parameter from '1.0' to l_api_version: Bug #3983570
2575: p_menu_name => p_new_menu_name_tbl(i),
2576: p_object_name => 'PA_PROJECTS',