DBA Data[Home] [Help]

APPS.FII_PMV_UTIL dependencies on FII_PMV_UTIL

Line 1: PACKAGE BODY FII_PMV_UTIL AS

1: PACKAGE BODY FII_PMV_UTIL AS
2: /* $Header: FIIPMVUB.pls 120.10 2006/09/15 05:24:17 sajgeo ship $ */
3:
4: g_prim_global_currency_code VARCHAR2(15) := get_prim_global_currency_code;
5: g_sec_global_currency_code VARCHAR2(15) := get_sec_global_currency_code;

Line 113: g_business_group_id := fii_pmv_util.get_business_group;

109: g_det_ou_lov := determine_OU_LOV;
110: END IF;
111:
112: IF g_business_group_id IS NULL THEN
113: g_business_group_id := fii_pmv_util.get_business_group;
114: END IF;
115:
116: IF(p_selected_operating_unit <> 'ALL') then
117: IF (g_operating_unit is null or g_operating_unit <> p_selected_operating_unit) THEN

Line 156: WHERE business_group_id = fii_pmv_util.g_business_group_id

152: g_det_ou_lov=2
153: AND fsp.org_id in (
154: SELECT organization_id
155: FROM hr_operating_units
156: WHERE business_group_id = fii_pmv_util.g_business_group_id
157: )
158: )
159: OR (
160: g_det_ou_lov=3

Line 296: g_security_profile_id := fii_pmv_util.get_sec_profile;

292:
293: /* Added for R12 MOAC */
294:
295: IF g_security_profile_id IS NULL THEN
296: g_security_profile_id := fii_pmv_util.get_sec_profile;
297: END IF;
298:
299: IF g_security_org_id IS NULL THEN
300: g_security_org_id := fnd_profile.value('ORG_ID');

Line 304: g_business_group_id := fii_pmv_util.get_business_group;

300: g_security_org_id := fnd_profile.value('ORG_ID');
301: END IF;
302:
303: IF g_business_group_id IS NULL THEN
304: g_business_group_id := fii_pmv_util.get_business_group;
305: END IF;
306:
307: IF p_operating_unit = 'All' THEN
308:

Line 615: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;

611: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
612: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
613: p_bind_output_table.EXTEND;
614: l_bind_rec.attribute_name := ':SEC_ID';
615: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;
616: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
617: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
618: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
619: p_bind_output_table.EXTEND;

Line 938: g_security_profile_id := fii_pmv_util.get_sec_profile;

934: l_business_group_id NUMBER;
935:
936: BEGIN
937: IF g_security_profile_id IS NULL THEN
938: g_security_profile_id := fii_pmv_util.get_sec_profile;
939: END IF;
940:
941: IF g_security_org_id IS NULL THEN
942: g_security_org_id := fnd_profile.value('ORG_ID');

Line 973: g_security_profile_id := fii_pmv_util.get_sec_profile;

969: FUNCTION get_business_group RETURN NUMBER IS
970: -- l_security_profile_id NUMBER;
971: l_business_group_id NUMBER;
972: BEGIN
973: g_security_profile_id := fii_pmv_util.get_sec_profile;
974:
975: SELECT business_group_id
976: INTO l_business_group_id
977: FROM per_security_profiles

Line 989: END fii_pmv_util;

985: return -1;
986:
987: END;
988:
989: END fii_pmv_util;