DBA Data[Home] [Help]

APPS.BIS_UTILITIES_PUB dependencies on BIS_RESPONSIBILITY_PVT

Line 272: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;

268: , x_where_clause OUT NOCOPY VARCHAR2
269: )
270: IS
271:
272: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;
273: l_where_clause VARCHAR2(32000);
274: l_comma VARCHAR2(2) := ',';
275: l_return_status VARCHAR2(100);
276: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 287: BIS_RESPONSIBILITY_PVT.Retrieve_User_Responsibilities

283: IF(p_dimension_level_short_name <> 'TOTAL_ORGANIZATION')
284: AND (SUBSTR(p_dimension_level_short_name, 1, 3) <> 'OPM')
285: THEN
286:
287: BIS_RESPONSIBILITY_PVT.Retrieve_User_Responsibilities
288: ( p_api_version => 1.0
289: , p_user_id => p_user_id
290: , p_Responsibility_version => NULL
291: , x_Responsibility_Tbl => l_Responsibility_tbl

Line 329: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;

325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
326: )
327: IS
328:
329: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;
330: l_where_clause VARCHAR2(32000);
331: l_comma VARCHAR2(2) := ',';
332: l_database_object VARCHAR2(30);
333: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 343: BIS_RESPONSIBILITY_PVT.Retrieve_User_Responsibilities

339: IF(p_dim_level_short_name <> 'TOTAL_ORGANIZATION')
340: AND (SUBSTR(p_dim_level_short_name, 1, 3) <> 'OPM')
341: THEN
342:
343: BIS_RESPONSIBILITY_PVT.Retrieve_User_Responsibilities
344: ( p_api_version => 1.0
345: , p_user_id => p_user_id
346: , p_Responsibility_version => NULL
347: , x_Responsibility_Tbl => l_Responsibility_tbl

Line 465: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;

461: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
462: )
463: IS
464:
465: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;
466: l_where_clause VARCHAR2(32000);
467: l_database_object VARCHAR2(30);
468: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
469:

Line 538: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;

534: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
535: )
536: IS
537:
538: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;
539: l_where_clause VARCHAR2(32000);
540: l_database_object VARCHAR2(30);
541: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
542:

Line 1229: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;

1225: , x_msg_data OUT NOCOPY VARCHAR2
1226: )
1227: IS
1228:
1229: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;
1230: l_where_clause VARCHAR2(32000);
1231: l_comma VARCHAR2(2) := ',';
1232: l_return_status VARCHAR2(100);
1233: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1243: BIS_RESPONSIBILITY_PVT.Retrieve_User_Responsibilities

1239: IF(p_dimension_level_short_name <> 'TOTAL_ORGANIZATION')
1240: AND (SUBSTR(p_dimension_level_short_name, 1, 3) <> 'OPM')
1241: THEN
1242:
1243: BIS_RESPONSIBILITY_PVT.Retrieve_User_Responsibilities
1244: ( p_api_version => 1.0
1245: , p_user_id => p_user_id
1246: , p_Responsibility_version => NULL
1247: , x_Responsibility_Tbl => l_Responsibility_tbl