eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_WEBADI_UTILS dependencies on PA_CONVERSION_TYPES_V

Line 2053: (p_pc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE

2049: This api is used in webadi.
2050: ==================================================================*/
2051:
2052: PROCEDURE CONV_MC_ATTR_MEANING_TO_CODE /* webadi */
2053: (p_pc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2054: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
2055: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2056: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
2057: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE

Line 2055: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE

2051:
2052: PROCEDURE CONV_MC_ATTR_MEANING_TO_CODE /* webadi */
2053: (p_pc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2054: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
2055: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2056: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
2057: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2058: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2059: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE

Line 2057: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE

2053: (p_pc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2054: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
2055: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2056: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
2057: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2058: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2059: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2060: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2061: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

Line 2059: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE

2055: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2056: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
2057: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2058: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2059: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2060: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2061: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2062: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2063: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

Line 2061: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

2057: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2058: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2059: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2060: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2061: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2062: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2063: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2064: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2065: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

Line 2063: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

2059: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
2060: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
2061: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2062: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2063: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2064: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2065: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2066: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2067: ,x_pfc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

Line 2065: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

2061: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2062: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2063: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2064: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2065: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2066: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2067: ,x_pfc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2068: ,x_pfc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2069: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2067: ,x_pfc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895

2063: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2064: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2065: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2066: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2067: ,x_pfc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
2068: ,x_pfc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2069: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2070: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2071: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2080: l_conversion_type pa_conversion_types_v.conversion_type%TYPE;

2076: l_msg_data VARCHAR2(2000);
2077: l_msg_index_out NUMBER;
2078: l_debug_mode VARCHAR2(1);
2079:
2080: l_conversion_type pa_conversion_types_v.conversion_type%TYPE;
2081: l_user_conversion_type pa_conversion_types_v.user_conversion_type%TYPE;
2082: l_lookup_code pa_lookups.lookup_code%TYPE;
2083: l_lookup_meaning pa_lookups.meaning%TYPE;
2084: l_lookup_type pa_lookups.lookup_type%TYPE;

Line 2081: l_user_conversion_type pa_conversion_types_v.user_conversion_type%TYPE;

2077: l_msg_index_out NUMBER;
2078: l_debug_mode VARCHAR2(1);
2079:
2080: l_conversion_type pa_conversion_types_v.conversion_type%TYPE;
2081: l_user_conversion_type pa_conversion_types_v.user_conversion_type%TYPE;
2082: l_lookup_code pa_lookups.lookup_code%TYPE;
2083: l_lookup_meaning pa_lookups.meaning%TYPE;
2084: l_lookup_type pa_lookups.lookup_type%TYPE;
2085:

Line 2088: from pa_conversion_types_v

2084: l_lookup_type pa_lookups.lookup_type%TYPE;
2085:
2086: cursor rate_type_cur is
2087: select conversion_type, user_conversion_type
2088: from pa_conversion_types_v
2089: where user_conversion_type IN (p_pc_cost_rate_type_name
2090: ,p_pfc_cost_rate_type_name
2091: ,p_pc_rev_rate_type_name
2092: ,p_pfc_rev_rate_type_name);