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 1694: pv_check_match_pub.Currency_Conversion(

1690: 1.0
1691: FROM (
1692: SELECT DISTINCT a.entity_id,
1693: a.attr_value attr_text,
1694: pv_check_match_pub.Currency_Conversion(
1695: a.attr_value, g_common_currency) attr_value
1696: FROM pv_enty_attr_values a,
1697: pv_partner_profiles PV
1698: WHERE a.entity = 'PARTNER' AND

Line 1761: pv_check_match_pub.Currency_Conversion(

1757: 1.0
1758: FROM (
1759: SELECT DISTINCT a.entity_id,
1760: a.attr_value attr_text,
1761: pv_check_match_pub.Currency_Conversion(
1762: a.attr_value, g_common_currency) attr_value
1763: FROM pv_enty_attr_values a,
1764: pv_partner_id_session b
1765: WHERE a.entity = 'PARTNER' AND

Line 2503: -- pv_check_match_pub.currency_conversion(

2499: -- ATTRIBUTE_ID_DUMMY into:
2500: --
2501: -- ,
2502: -- attr_value attr_text,
2503: -- pv_check_match_pub.currency_conversion(
2504: -- attr_value, , 'Y') ATTR_VALUE
2505: --
2506: -- -----------------------------------------------------------------
2507: ELSE

Line 2510: 'pv_check_match_pub.currency_conversion(' ||

2506: -- -----------------------------------------------------------------
2507: ELSE
2508: l_ddl_sql := REPLACE(l_insert_sql, 'ATTRIBUTE_ID_DUMMY',
2509: x.attribute_id || ', attr_value ATTR_TEXT, ' ||
2510: 'pv_check_match_pub.currency_conversion(' ||
2511: 'attr_value, ''' || g_common_currency || ''', ''Y'') ATTR_VALUE');
2512:
2513: END IF;
2514:

Line 2570: g_common_currency, pv_check_match_pub.g_period_set_name,

2566:
2567: IF (x.return_type = 'CURRENCY' AND x.performance_flag = 'Y') THEN
2568: EXECUTE IMMEDIATE l_ddl_sql
2569: USING p_user_id, p_user_id, p_user_id,
2570: g_common_currency, pv_check_match_pub.g_period_set_name,
2571: x.attribute_id, 'PARTNER';
2572:
2573: ELSE
2574: EXECUTE IMMEDIATE l_ddl_sql USING p_user_id, p_user_id, p_user_id,

Line 3219: l_attr_value := pv_check_match_pub.currency_conversion

3215: l_attr_value := NULL;
3216:
3217: ELSE
3218: l_attr_text := l_output_tbl(i);
3219: l_attr_value := pv_check_match_pub.currency_conversion
3220: (l_output_tbl(i), g_common_currency);
3221: END IF;
3222:
3223: ELSIF (g_func_perf_attrs_tbl(p_attribute_id).return_type = 'NUMBER') THEN

Line 3363: l_attr_value := pv_check_match_pub.currency_conversion

3359: l_attr_value := NULL;
3360:
3361: ELSE
3362: l_attr_text := l_output;
3363: l_attr_value := pv_check_match_pub.currency_conversion
3364: (l_output, g_common_currency);
3365: END IF;
3366:
3367: ELSIF (g_func_perf_attrs_tbl(p_attribute_id).return_type = 'NUMBER') THEN