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_FIN_PLAN_UTILS2 dependencies on PA_VARCHAR2_1_TBL_TYPE

Line 88: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

84: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
85: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
86: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
87: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
88: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
89: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
90: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
91: ,x_new_rate_based_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
92: ,x_rate_based_flag_changed_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE

Line 90: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE

86: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
87: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
88: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
89: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
90: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
91: ,x_new_rate_based_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
92: ,x_rate_based_flag_changed_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ) IS

Line 91: ,x_new_rate_based_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE

87: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
88: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
89: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
90: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
91: ,x_new_rate_based_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
92: ,x_rate_based_flag_changed_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ) IS
95:

Line 92: ,x_rate_based_flag_changed_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE

88: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
89: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
90: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
91: ,x_new_rate_based_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
92: ,x_rate_based_flag_changed_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ) IS
95:
96: l_debug_flag Varchar2(100);

Line 141: x_uom_changed_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

137: l_stage := 'Begin of Get_UOM_RateBasedFlag Table Count['||p_resource_class_code_tab.count||']';
138: print_msg(l_debug_flag,l_proc_name,l_stage);
139:
140: x_New_UOM_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
141: x_uom_changed_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
142: x_new_rate_based_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
143: x_rate_based_flag_changed_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
144:
145: x_New_UOM_tab.extend(p_resource_class_code_tab.count);

Line 142: x_new_rate_based_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

138: print_msg(l_debug_flag,l_proc_name,l_stage);
139:
140: x_New_UOM_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
141: x_uom_changed_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
142: x_new_rate_based_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
143: x_rate_based_flag_changed_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
144:
145: x_New_UOM_tab.extend(p_resource_class_code_tab.count);
146: x_uom_changed_flag_tab.extend(p_resource_class_code_tab.count);

Line 143: x_rate_based_flag_changed_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

139:
140: x_New_UOM_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
141: x_uom_changed_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
142: x_new_rate_based_flag_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
143: x_rate_based_flag_changed_tab := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
144:
145: x_New_UOM_tab.extend(p_resource_class_code_tab.count);
146: x_uom_changed_flag_tab.extend(p_resource_class_code_tab.count);
147: x_new_rate_based_flag_tab.extend(p_resource_class_code_tab.count);

Line 2277: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2273: ,x_return_status OUT NOCOPY VARCHAR2
2274: ) IS
2275:
2276: --Start of variables for Variable for Resource Attributes
2277: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2278: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2279: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2280: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2281: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2302: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2298: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2299: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2300: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2301: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2302: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2304: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2305: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2306: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2299: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2300: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2301: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2302: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2304: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2305: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2306: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2307: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 2307: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2303: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2304: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2305: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2306: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2307: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2308: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2309: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2310: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2311: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 2318: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2314: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
2315: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
2316: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
2317: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2318: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2319: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2320: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2321: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2322: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();