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

Line 412: l_finish_flg_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

408: l_adj_dates_asgmt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
409: l_adj_task_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
410: l_adj_task_task_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
411: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
412: l_finish_flg_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
413: k number;
414: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
415: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
416: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 1371: lr_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1367: l_P_named_role VARCHAR2(80);
1368:
1369: -- For Resource defaults
1370: --Start of variables for Variable for Resource Attributes
1371: lr_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1372: lr_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1373: lr_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1374: lr_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1375: lr_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1396: lr_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1392: lr_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1393: lr_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1394: lr_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1395: lr_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1396: lr_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1397: lr_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1398: lr_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1399: lr_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1400: lr_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1397: lr_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1393: lr_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1394: lr_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1395: lr_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1396: lr_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1397: lr_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1398: lr_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1399: lr_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1400: lr_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1401: lr_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 1401: lr_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1397: lr_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1398: lr_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1399: lr_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1400: lr_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1401: lr_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1402: lr_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1403: lr_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1404: lr_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1405: lr_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1413: lr_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1409: lr_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1410: lr_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1411: lr_financial_category_code_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1412: lr_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1413: lr_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1414: lr_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1415: lr_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1416: lr_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1417: lr_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2299: x_delete_task_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

2295: p_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
2296: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
2297: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
2298: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
2299: x_delete_task_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2300: x_delete_asgmt_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2301: x_task_assmt_ids_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --Bug 4951422
2302: x_return_status OUT NOCOPY VARCHAR2
2303: )

Line 2300: x_delete_asgmt_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

2296: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
2297: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
2298: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
2299: x_delete_task_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2300: x_delete_asgmt_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2301: x_task_assmt_ids_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --Bug 4951422
2302: x_return_status OUT NOCOPY VARCHAR2
2303: )
2304:

Line 2385: x_delete_task_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2381: pa_debug.g_err_stage:='Beginning of TA:Validate_Delete_Assignment';
2382: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2383: END IF;
2384:
2385: x_delete_task_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2386: x_delete_asgmt_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2387:
2388: --Bug 4951422
2389: x_task_assmt_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 2386: x_delete_asgmt_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2382: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2383: END IF;
2384:
2385: x_delete_task_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2386: x_delete_asgmt_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2387:
2388: --Bug 4951422
2389: x_task_assmt_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
2390:

Line 2718: l_ta_role_in_format_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

2714: l_ta_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2715: l_ta_project_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2716: -- Bug 4097749.
2717: l_ta_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
2718: l_ta_role_in_format_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2719: -- \Bug 4097749.
2720: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2722: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

2722: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2723: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2724: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2727: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2728: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2729: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2778: l_ta_resource_class_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

2774: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
2775: l_ta_task_id pa_resource_assignments.task_id%TYPE;
2776: l_ta_res_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2777: l_ta_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2778: l_ta_resource_class_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2779: l_ta_total_plan_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2780: l_ta_total_plan_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2781: l_ta_total_proj_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2782: l_ta_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 2782: l_ta_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

2778: l_ta_resource_class_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2779: l_ta_total_plan_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2780: l_ta_total_plan_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2781: l_ta_total_proj_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2782: l_ta_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2783: l_ta_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2784: l_previous_elem_version_id NUMBER;
2785: l_add_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2786: l_add_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();