DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on FND_GRANTS_PKG

Line 1125: fnd_grants_pkg.grant_function

1121:
1122: --dbms_output.put_line('before calling grant_function');
1123: --dbms_output.put_line('l_grantee_key: '||l_grantee_key);
1124:
1125: fnd_grants_pkg.grant_function
1126: (
1127: p_api_version => l_api_version,
1128: p_menu_name => l_default_menu_name,
1129: p_object_name => 'PA_PROJECTS',

Line 1165: fnd_grants_pkg.grant_function

1161: FOR i IN l_status_code_tbl.FIRST .. l_status_code_tbl.LAST LOOP
1162:
1163: --dbms_output.put_line('status menu name: '||l_menu_name_tbl(i));
1164:
1165: fnd_grants_pkg.grant_function
1166: (
1167: p_api_version => l_api_version,
1168: p_menu_name => l_menu_name_tbl(i),
1169: p_object_name => 'PA_PROJECTS',

Line 1292: fnd_grants_pkg.grant_function

1288: l_instance_pk1_value:=null;
1289: l_object_key_type:='SET';
1290: end if;
1291:
1292: fnd_grants_pkg.grant_function
1293: (
1294: p_api_version =>l_api_version,
1295: p_menu_name =>v_menu_name,
1296: p_object_name =>p_object_name,

Line 1352: fnd_grants_pkg.revoke_grant

1348: x_return_status :=fnd_api.g_ret_sts_success;
1349: x_msg_count:=0;
1350: x_msg_data :=null;
1351: --dbms_output.put_line('inside pa revoke_grants');
1352: fnd_grants_pkg.revoke_grant
1353: (
1354: p_api_version =>l_api_version,
1355: p_grant_guid =>p_grant_guid,
1356: x_success =>l_success,

Line 1440: fnd_grants_pkg.revoke_grant(

1436: instance_pk1_value=TO_CHAR(p_object_key)) OR
1437: (l_object_key_type='SET' AND
1438: instance_set_id=p_object_key));
1439:
1440: fnd_grants_pkg.revoke_grant(
1441: p_api_version => l_api_version,
1442: p_grant_guid => l_grant_guid,
1443: x_success => l_success,
1444: x_errorcode => l_error_code);

Line 1510: fnd_grants_pkg.update_grant

1506:
1507: x_return_status:=fnd_api.g_ret_sts_success;
1508: x_msg_count:=0;
1509: x_msg_data:=null;
1510: fnd_grants_pkg.update_grant
1511: (
1512: p_api_version =>l_api_version,
1513: p_grant_guid =>p_grant_guid,
1514: p_start_date =>p_start_date_new,

Line 1587: fnd_grants_pkg.lock_grant

1583: into l_object_id
1584: from fnd_objects
1585: where obj_name=p_object_name;
1586:
1587: fnd_grants_pkg.lock_grant
1588: (
1589: p_grant_guid =>p_grant_guid,
1590: p_menu_id =>v_menu_id,
1591: -- p_grantee_key =>'PER:'||to_char(p_party_id),

Line 2367: fnd_grants_pkg.grant_function

2363: --dbms_output.put_line('------------------------------');
2364: --dbms_output.put_line('grantee_key: ' || l_grantee_key);
2365:
2366: -- insert new records into FND_GRANTS
2367: fnd_grants_pkg.grant_function
2368: (
2369: p_api_version => l_api_version, -- Modified the parameter from '1.0' to l_api_version: Bug #3983570
2370: p_menu_name => l_default_menu_name,
2371: p_object_name => 'PA_PROJECTS',

Line 2403: fnd_grants_pkg.grant_function

2399: IF l_status_code_tbl IS NOT NULL AND l_status_code_tbl.COUNT > 0 THEN
2400:
2401: FOR i IN l_status_code_tbl.FIRST..l_status_code_tbl.LAST LOOP
2402:
2403: fnd_grants_pkg.grant_function
2404: (
2405: p_api_version => l_api_version, -- Modified the parameter from '1.0' to l_api_version: Bug #3983570
2406: p_menu_name => l_menu_name_tbl(i),
2407: p_object_name => 'PA_PROJECTS',

Line 2583: fnd_grants_pkg.grant_function

2579: l_grantee_key := res.grantee_key;
2580:
2581: FOR i IN p_new_status_code_tbl.FIRST..p_new_status_code_tbl.LAST LOOP
2582:
2583: fnd_grants_pkg.grant_function
2584: (
2585: p_api_version => l_api_version, -- Modified the parameter from '1.0' to l_api_version: Bug #3983570
2586: p_menu_name => p_new_menu_name_tbl(i),
2587: p_object_name => 'PA_PROJECTS',