APPS.POA_REPORT_UTIL dependencies on FND_PROFILE

Line 178: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

174: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
175: l_region_code VARCHAR2(30);
176: BEGIN
177:
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,

Line 214: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
211: l_region_code VARCHAR2(30);
212: BEGIN
213:
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,

Line 318: to_number(fnd_profile.value_wnps(''GL_SET_OF_BKS_ID'')))

314: FROM gl_period_types gpt, gl_periods glp
315: WHERE glp.period_set_name = (SELECT sob.period_set_name
316: FROM gl_sets_of_books sob
317: WHERE sob.set_of_books_id =
318: to_number(fnd_profile.value_wnps(''GL_SET_OF_BKS_ID'')))
319: AND glp.period_type = gpt.period_type
320: AND glp.adjustment_period_flag = ''N''
321: order by gpt.user_period_type', p_param(p_index).Value);
322: END Build_KPIPeriodType;

Line 394: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
391: l_region_code VARCHAR2(30);
392: BEGIN
393:
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,

Line 769: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

765: p_org_id := -9999;
766: return TRUE;
767: ELSE
768:
769: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
770: -- Use restricted check
771: OPEN c1;
772: FETCH c1 INTO p_org_id;
773:

Line 865: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

861: p_oper_unit_id := -9999;
862: return TRUE;
863: ELSE
864:
865: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
866: -- Use restricted check
867: OPEN c1;
868: FETCH c1 INTO p_oper_unit_id;
869:

Line 928: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

924: p_oper_unit_id := -9999;
925: return TRUE;
926: ELSE
927:
928: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
929: OPEN c1;
930: FETCH c1 INTO p_oper_unit_id;
931:
932: IF c1%NOTFOUND THEN