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_LOOKUPS

Line 52: l_plan_class_name pa_lookups.meaning%TYPE;

48: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%TYPE;
49: l_no_of_periods NUMBER;
50: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
51: l_layout_meaning bne_layouts_vl.user_name%TYPE;
52: l_plan_class_name pa_lookups.meaning%TYPE;
53: l_layout_code VARCHAR2(300);
54:
55: /* Added variables for debug messages/error. */
56: l_msg_count NUMBER := 0;

Line 227: FROM pa_lookups

223: WHERE APPLICATION_SHORT_NAME = 'PA');
224:
225: SELECT meaning
226: INTO l_plan_class_name
227: FROM pa_lookups
228: WHERE lookup_type = 'FIN_PLAN_CLASS'
229: AND Lookup_code = l_plan_class_code;
230:
231: IF l_plan_class_code = 'BUDGET' THEN

Line 956: l_lookup_code PA_LOOKUPS.LOOKUP_CODE%TYPE;

952: l_data VARCHAR2(2000);
953: l_msg_data VARCHAR2(2000);
954: l_msg_index_out NUMBER;
955: l_exists VARCHAR2(1) ;
956: l_lookup_code PA_LOOKUPS.LOOKUP_CODE%TYPE;
957:
958: CURSOR c_code_exists_cur IS
959: SELECT LOOKUP_CODE
960: FROM PA_LOOKUPS

Line 960: FROM PA_LOOKUPS

956: l_lookup_code PA_LOOKUPS.LOOKUP_CODE%TYPE;
957:
958: CURSOR c_code_exists_cur IS
959: SELECT LOOKUP_CODE
960: FROM PA_LOOKUPS
961: WHERE LOOKUP_TYPE = 'BUDGET CHANGE REASON'
962: AND LOOKUP_CODE = p_change_reason_code ;
963:
964: BEGIN

Line 1845: (p_mc_error_code IN pa_lookups.lookup_code%TYPE

1841: user using the lookup code.
1842: ==================================================================*/
1843:
1844: PROCEDURE GET_MC_ERROR_LOOKUP_CODE
1845: (p_mc_error_code IN pa_lookups.lookup_code%TYPE
1846: ,p_attr_set_cost_rev IN VARCHAR2
1847: ,p_attr_set_pc_pfc IN VARCHAR2
1848: ,x_error_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
1849: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1848: ,x_error_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

1844: PROCEDURE GET_MC_ERROR_LOOKUP_CODE
1845: (p_mc_error_code IN pa_lookups.lookup_code%TYPE
1846: ,p_attr_set_cost_rev IN VARCHAR2
1847: ,p_attr_set_pc_pfc IN VARCHAR2
1848: ,x_error_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
1849: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1850: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1851: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1852: AS

Line 2054: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE

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
2058: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE

Line 2056: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE

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
2060: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE

Line 2058: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%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
2062: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

Line 2060: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%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
2064: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

Line 2062: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

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
2066: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

Line 2064: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

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
2068: ,x_pfc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

Line 2066: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%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
2070: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2068: ,x_pfc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%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
2072: )

Line 2082: l_lookup_code pa_lookups.lookup_code%TYPE;

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:
2086: cursor rate_type_cur is

Line 2083: l_lookup_meaning pa_lookups.meaning%TYPE;

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:
2086: cursor rate_type_cur is
2087: select conversion_type, user_conversion_type

Line 2084: l_lookup_type pa_lookups.lookup_type%TYPE;

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:
2086: cursor rate_type_cur is
2087: select conversion_type, user_conversion_type
2088: from pa_conversion_types_v

Line 2096: from pa_lookups

2092: ,p_pfc_rev_rate_type_name);
2093:
2094: cursor rate_date_type_cur is
2095: select lookup_code, lookup_type, meaning
2096: from pa_lookups
2097: where lookup_type = 'PA_FP_RATE_DATE_TYPE'
2098: and meaning IN (p_pc_cost_rate_date_type_name
2099: ,p_pfc_cost_rate_date_type_name
2100: ,p_pc_rev_rate_date_type_name

Line 2281: ,x_layout_type_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

2277: PROCEDURE get_layout_details
2278: (p_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
2279: ,p_integrator_code IN bne_integrators_b.integrator_code%TYPE
2280: ,x_layout_name OUT NOCOPY bne_layouts_tl.user_name%TYPE --File.Sql.39 bug 4440895
2281: ,x_layout_type_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2283: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2284: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2285: ) IS