44: p_pk4_value IN VARCHAR2,
45: p_pk5_value IN VARCHAR2,
46: p_role_name IN VARCHAR2 DEFAULT NULL,
47: x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
48: x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
49: x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
50: x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
51: x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
52: x_return_status OUT NOCOPY VARCHAR2
45: p_pk5_value IN VARCHAR2,
46: p_role_name IN VARCHAR2 DEFAULT NULL,
47: x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
48: x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
49: x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
50: x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
51: x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
52: x_return_status OUT NOCOPY VARCHAR2
53: )
47: x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
48: x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
49: x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
50: x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
51: x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
52: x_return_status OUT NOCOPY VARCHAR2
53: )
54: IS
55: -- Start OF comments
270: l_index:=l_index+1;
271: END LOOP;
272:
273: x_grantee_names := FND_TABLE_OF_VARCHAR2_120();
274: x_grantee_types := FND_TABLE_OF_VARCHAR2_30();
275: x_role_names := FND_TABLE_OF_VARCHAR2_30();
276: x_role_display_names := FND_TABLE_OF_VARCHAR2_120();
277: x_default_access := FND_TABLE_OF_VARCHAR2_30();
278:
271: END LOOP;
272:
273: x_grantee_names := FND_TABLE_OF_VARCHAR2_120();
274: x_grantee_types := FND_TABLE_OF_VARCHAR2_30();
275: x_role_names := FND_TABLE_OF_VARCHAR2_30();
276: x_role_display_names := FND_TABLE_OF_VARCHAR2_120();
277: x_default_access := FND_TABLE_OF_VARCHAR2_30();
278:
279: IF( l_grantee_list.count>0) THEN
273: x_grantee_names := FND_TABLE_OF_VARCHAR2_120();
274: x_grantee_types := FND_TABLE_OF_VARCHAR2_30();
275: x_role_names := FND_TABLE_OF_VARCHAR2_30();
276: x_role_display_names := FND_TABLE_OF_VARCHAR2_120();
277: x_default_access := FND_TABLE_OF_VARCHAR2_30();
278:
279: IF( l_grantee_list.count>0) THEN
280: x_grantee_names.extend(l_grantee_list.count);
281: x_grantee_types.extend(l_grantee_list.count);