APPS.POA_REPORT_UTIL dependencies on FND_GLOBAL

Line 182: (p_user_id => FND_GLOBAL.user_id,

178: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
179: -- Use region pointing to BIS lov restricted based on responsibilities
180: l_region_code := 'POA_BIS_SAVINGS_RPT';
181: BIS_UTILITIES_PUB.Retrieve_Where_Clause
182: (p_user_id => FND_GLOBAL.user_id,
183: p_region_code => 'BIS_OPERATING_UNIT',
184: x_where_clause => l_where_clause,
185: x_return_status => l_return_status,
186: x_error_Tbl => l_error_tbl);

Line 218: (p_user_id => FND_GLOBAL.user_id,

214: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
215: -- Use region pointing to BIS lov restricted based on responsibilities
216: l_region_code := 'POA_BIS_PPS_RPT';
217: BIS_UTILITIES_PUB.Retrieve_Where_Clause
218: (p_user_id => FND_GLOBAL.user_id,
219: p_region_code => 'BIS_OPERATING_UNIT',
220: x_where_clause => l_where_clause,
221: x_return_status => l_return_status,
222: x_error_Tbl => l_error_tbl);

Line 398: (p_user_id => FND_GLOBAL.user_id,

394: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
395: -- Use restricted LOV
396: l_region_code := 'POA_BIS_SAVINGS_RPT';
397: Retrieve_Org_Where_Clause
398: (p_user_id => FND_GLOBAL.user_id,
399: x_where_clause => l_where_clause,
400: x_return_status => l_return_status,
401: x_error_Tbl => l_error_tbl);
402: ELSE

Line 760: WHERE user_id = FND_GLOBAL.user_id

756: FROM bis_sets_of_books_v
757: WHERE responsibility_id IN
758: (SELECT responsibility_id
759: FROM fnd_user_resp_groups
760: WHERE user_id = FND_GLOBAL.user_id
761: AND sysdate BETWEEN start_date and nvl(end_date, sysdate+1)))));
762:
763: BEGIN
764: IF (p_org_name IS NULL OR p_org_name = '') THEN

Line 855: WHERE user_id = FND_GLOBAL.user_id

851: (SELECT id from bis_operating_units_v
852: WHERE responsibility_id IN
853: (SELECT responsibility_id
854: FROM fnd_user_resp_groups
855: WHERE user_id = FND_GLOBAL.user_id
856: AND sysdate BETWEEN start_date and nvl(end_date, sysdate+1)));
857:
858: BEGIN
859:

Line 920: WHERE user_id = FND_GLOBAL.user_id

916: (SELECT id FROM bis_operating_units_v
917: WHERE responsibility_id IN
918: (SELECT responsibility_id
919: FROM fnd_user_resp_groups
920: WHERE user_id = FND_GLOBAL.user_id
921: AND sysdate between start_date and nvl(end_date, sysdate+1)));
922: BEGIN
923: IF (p_oper_unit_name IS NULL OR p_oper_unit_name = '') THEN
924: p_oper_unit_id := -9999;