APPS.ENG_CHANGE_ROLES_PUB dependencies on FND_TABLE_OF_VARCHAR2_30

Line 90: x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,

86: p_pk4_value IN VARCHAR2,
87: p_pk5_value IN VARCHAR2,
88: p_role_name IN VARCHAR2 DEFAULT NULL,
89: x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
90: x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
91: x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
92: x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
93: x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
94: x_return_status OUT NOCOPY VARCHAR2

Line 91: x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,

87: p_pk5_value IN VARCHAR2,
88: p_role_name IN VARCHAR2 DEFAULT NULL,
89: x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
90: x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
91: x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
92: x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
93: x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
94: x_return_status OUT NOCOPY VARCHAR2
95: )

Line 93: x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,

89: x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
90: x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
91: x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
92: x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
93: x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
94: x_return_status OUT NOCOPY VARCHAR2
95: )
96: AS
97:

Line 285: x_grantee_types := FND_TABLE_OF_VARCHAR2_30();

281: l_index:=l_index+1;
282: END LOOP;
283:
284: x_grantee_names := FND_TABLE_OF_VARCHAR2_120();
285: x_grantee_types := FND_TABLE_OF_VARCHAR2_30();
286: x_role_names := FND_TABLE_OF_VARCHAR2_30();
287: x_role_display_names := FND_TABLE_OF_VARCHAR2_120();
288: x_default_access := FND_TABLE_OF_VARCHAR2_30();
289:

Line 286: x_role_names := FND_TABLE_OF_VARCHAR2_30();

282: END LOOP;
283:
284: x_grantee_names := FND_TABLE_OF_VARCHAR2_120();
285: x_grantee_types := FND_TABLE_OF_VARCHAR2_30();
286: x_role_names := FND_TABLE_OF_VARCHAR2_30();
287: x_role_display_names := FND_TABLE_OF_VARCHAR2_120();
288: x_default_access := FND_TABLE_OF_VARCHAR2_30();
289:
290: IF( l_grantee_list.count>0) THEN

Line 288: x_default_access := FND_TABLE_OF_VARCHAR2_30();

284: x_grantee_names := FND_TABLE_OF_VARCHAR2_120();
285: x_grantee_types := FND_TABLE_OF_VARCHAR2_30();
286: x_role_names := FND_TABLE_OF_VARCHAR2_30();
287: x_role_display_names := FND_TABLE_OF_VARCHAR2_120();
288: x_default_access := FND_TABLE_OF_VARCHAR2_30();
289:
290: IF( l_grantee_list.count>0) THEN
291: x_grantee_names.extend(l_grantee_list.count);
292: x_grantee_types.extend(l_grantee_list.count);