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_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --16598322

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_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --16598322
55: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
56: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
57: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 54: l_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --16598322

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_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --16598322
55: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
56: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
57: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 55: l_quantity_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_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --16598322
55: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
56: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
57: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
59:

Line 57: l_raw_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_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --16598322
55: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
56: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
57: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
59:
60: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
61:

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

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

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

1846: TYPE l_number_tbl IS TABLE OF NUMBER;
1847: TYPE l_date_tbl IS TABLE OF DATE;
1848: TYPE l_varchar_tbl is TABLE OF VARCHAR2(1);
1849:
1850: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1851: --CBS Change in Derive_Task_Assignments
1852: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1853: --End CBS Change in Derive_Task_Assignments
1854: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);

Line 1852: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);

1848: TYPE l_varchar_tbl is TABLE OF VARCHAR2(1);
1849:
1850: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1851: --CBS Change in Derive_Task_Assignments
1852: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1853: --End CBS Change in Derive_Task_Assignments
1854: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1855: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1856: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);

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

1850: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1851: --CBS Change in Derive_Task_Assignments
1852: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1853: --End CBS Change in Derive_Task_Assignments
1854: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1855: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1856: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1857: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1858: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);

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

1851: --CBS Change in Derive_Task_Assignments
1852: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1853: --End CBS Change in Derive_Task_Assignments
1854: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1855: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1856: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1857: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1858: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1859: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(NULL);

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

1852: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1853: --End CBS Change in Derive_Task_Assignments
1854: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1855: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1856: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(1);
1857: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1858: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(NULL);
1859: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(NULL);
1860:

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

2095:
2096: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2097: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2098:
2099: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2100: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2101: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2102: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2103: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

2096: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2097: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2098:
2099: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2100: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2101: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2102: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2103: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2104: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

2097: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2098:
2099: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2100: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2101: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2102: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2103: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2104: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2105: l_task_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

2098:
2099: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2100: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2101: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2102: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2103: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2104: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2105: l_task_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2106: l_task_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

2103: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2104: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2105: l_task_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2106: l_task_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2107: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2108: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2109: l_ta_display_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2110: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- Added for 16200605
2111:

Line 2110: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- Added for 16200605

2106: l_task_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2107: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2108: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2109: l_ta_display_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2110: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- Added for 16200605
2111:
2112: k NUMBER;
2113:
2114: CURSOR c_get_budget_version_id(structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE) IS