APPS.PV_CONTEXT_VALUES dependencies on PV_CHECK_MATCH_PUB

Line 408: pv_check_match_pub.g_display_message := FALSE;

404:
405: -- -----------------------------------------------------------------------
406: -- Set the flag to NOT to display message in currency conversion.
407: -- -----------------------------------------------------------------------
408: pv_check_match_pub.g_display_message := FALSE;
409: pv_check_match_pub.g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR');
410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');
411:
412: g_partner_temp_table := 'PV_PARTNER_ID_SESSION';

Line 409: pv_check_match_pub.g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR');

405: -- -----------------------------------------------------------------------
406: -- Set the flag to NOT to display message in currency conversion.
407: -- -----------------------------------------------------------------------
408: pv_check_match_pub.g_display_message := FALSE;
409: pv_check_match_pub.g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR');
410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');
411:
412: g_partner_temp_table := 'PV_PARTNER_ID_SESSION';
413:

Line 410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');

406: -- Set the flag to NOT to display message in currency conversion.
407: -- -----------------------------------------------------------------------
408: pv_check_match_pub.g_display_message := FALSE;
409: pv_check_match_pub.g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR');
410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');
411:
412: g_partner_temp_table := 'PV_PARTNER_ID_SESSION';
413:
414:

Line 1672: pv_check_match_pub.Currency_Conversion(

1668: 1.0
1669: FROM (
1670: SELECT DISTINCT a.entity_id,
1671: a.attr_value attr_text,
1672: pv_check_match_pub.Currency_Conversion(
1673: a.attr_value, g_common_currency) attr_value
1674: FROM pv_enty_attr_values a,
1675: pv_partner_profiles PV
1676: WHERE a.entity = 'PARTNER' AND

Line 1739: pv_check_match_pub.Currency_Conversion(

1735: 1.0
1736: FROM (
1737: SELECT DISTINCT a.entity_id,
1738: a.attr_value attr_text,
1739: pv_check_match_pub.Currency_Conversion(
1740: a.attr_value, g_common_currency) attr_value
1741: FROM pv_enty_attr_values a,
1742: pv_partner_id_session b
1743: WHERE a.entity = 'PARTNER' AND

Line 2481: -- pv_check_match_pub.currency_conversion(

2477: -- ATTRIBUTE_ID_DUMMY into:
2478: --
2479: -- ,
2480: -- attr_value attr_text,
2481: -- pv_check_match_pub.currency_conversion(
2482: -- attr_value, , 'Y') ATTR_VALUE
2483: --
2484: -- -----------------------------------------------------------------
2485: ELSE

Line 2488: 'pv_check_match_pub.currency_conversion(' ||

2484: -- -----------------------------------------------------------------
2485: ELSE
2486: l_ddl_sql := REPLACE(l_insert_sql, 'ATTRIBUTE_ID_DUMMY',
2487: x.attribute_id || ', attr_value ATTR_TEXT, ' ||
2488: 'pv_check_match_pub.currency_conversion(' ||
2489: 'attr_value, ''' || g_common_currency || ''', ''Y'') ATTR_VALUE');
2490:
2491: END IF;
2492:

Line 2548: g_common_currency, pv_check_match_pub.g_period_set_name,

2544:
2545: IF (x.return_type = 'CURRENCY' AND x.performance_flag = 'Y') THEN
2546: EXECUTE IMMEDIATE l_ddl_sql
2547: USING p_user_id, p_user_id, p_user_id,
2548: g_common_currency, pv_check_match_pub.g_period_set_name,
2549: x.attribute_id, 'PARTNER';
2550:
2551: ELSE
2552: EXECUTE IMMEDIATE l_ddl_sql USING p_user_id, p_user_id, p_user_id,

Line 3197: l_attr_value := pv_check_match_pub.currency_conversion

3193: l_attr_value := NULL;
3194:
3195: ELSE
3196: l_attr_text := l_output_tbl(i);
3197: l_attr_value := pv_check_match_pub.currency_conversion
3198: (l_output_tbl(i), g_common_currency);
3199: END IF;
3200:
3201: ELSIF (g_func_perf_attrs_tbl(p_attribute_id).return_type = 'NUMBER') THEN

Line 3341: l_attr_value := pv_check_match_pub.currency_conversion

3337: l_attr_value := NULL;
3338:
3339: ELSE
3340: l_attr_text := l_output;
3341: l_attr_value := pv_check_match_pub.currency_conversion
3342: (l_output, g_common_currency);
3343: END IF;
3344:
3345: ELSIF (g_func_perf_attrs_tbl(p_attribute_id).return_type = 'NUMBER') THEN