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_ASSIGNMENTS_PVT dependencies on PA_NUM_TBL_TYPE

Line 34: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

30: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
31: --pa_fp_rollup_tmp
32: l_project_id pa_projects.project_id%type;
33: l_d_task_id NUMBER;
34: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
35: l_msg_count NUMBER ;
36: l_msg_data VARCHAR2(2000);
37: l_function_allowed VARCHAR2(1);
38: l_resp_id NUMBER := 0;

Line 50: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

46: l_context varchar2(200);
47: l_calling_module varchar2(200);
48: l_struct_elem_version_id number;
49: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
50: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
51: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
52: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
53: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
54: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 53: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

49: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
50: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
51: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
52: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
53: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
54: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
55: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
56: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
57: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 54: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

50: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
51: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
52: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
53: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
54: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
55: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
56: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
57: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58:

Line 56: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

52: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
53: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
54: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
55: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
56: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
57: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58:
59: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
60:

Line 57: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

53: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
54: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
55: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
56: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
57: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58:
59: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
60:
61: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 1624: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);

1620: TYPE l_number_tbl IS TABLE OF NUMBER;
1621: TYPE l_date_tbl IS TABLE OF DATE;
1622: TYPE l_varchar_tbl is TABLE OF VARCHAR2(1);
1623:
1624: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1625: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1626: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1627: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1628: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);

Line 1625: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);

1621: TYPE l_date_tbl IS TABLE OF DATE;
1622: TYPE l_varchar_tbl is TABLE OF VARCHAR2(1);
1623:
1624: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1625: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1626: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1627: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1628: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1629: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);

Line 1626: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);

1622: TYPE l_varchar_tbl is TABLE OF VARCHAR2(1);
1623:
1624: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1625: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1626: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1627: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1628: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1629: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1630: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(NULL);

Line 1627: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);

1623:
1624: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1625: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1626: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1627: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1628: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1629: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1630: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(NULL);
1631:

Line 1864: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1860:
1861: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1862: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1863:
1864: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1865: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1866: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1867: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1868: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 1865: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1861: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1862: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1863:
1864: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1865: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1866: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1867: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1868: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1869: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 1866: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1862: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1863:
1864: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1865: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1866: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1867: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1868: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1869: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1870: l_task_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 1867: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1863:
1864: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1865: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1866: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1867: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1868: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1869: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1870: l_task_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1871: l_task_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 1872: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1868: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1869: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1870: l_task_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1871: l_task_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1872: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1873: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1874: l_ta_display_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1875:
1876: k NUMBER;