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

Line 1012: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1008: l_add_planned_effort PA_NUM_1000_NUM := PA_NUM_1000_NUM();
1009: l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
1010: l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
1011:
1012: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1013:
1014: /* Bug # 3420093 - Adding Progress Management modifications to create_task flow. */
1015:
1016: --Bug 6153503

Line 2450: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2446:
2447: --New tbls (suffixed with _prm), created below will be used as parameters in the call to
2448: --pa_task_pub1.call_add_planning_txns
2449:
2450: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2451: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2452: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2453: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2454: l_add_task_ver_ids_prm PA_NUM_1000_NUM := PA_NUM_1000_NUM();

Line 2451: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2447: --New tbls (suffixed with _prm), created below will be used as parameters in the call to
2448: --pa_task_pub1.call_add_planning_txns
2449:
2450: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2451: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2452: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2453: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2454: l_add_task_ver_ids_prm PA_NUM_1000_NUM := PA_NUM_1000_NUM();
2455: l_add_planned_effort_prm PA_NUM_1000_NUM := PA_NUM_1000_NUM();

Line 2460: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2456: l_add_start_date_prm PA_DATE_1000_DATE := PA_DATE_1000_DATE();
2457: l_add_end_date_prm PA_DATE_1000_DATE := PA_DATE_1000_DATE();
2458: rec_count NUMBER;
2459:
2460: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2461:
2462: cursor l_task_cur(p_project_id NUMBER, p_struct_ver_id NUMBER) is
2463: /* --bug 3880482
2464: select

Line 10182: Old_Versions_Tab SYSTEM.pa_num_tbl_type;

10178: END IF;
10179: END IF;
10180:
10181: DECLARE
10182: Old_Versions_Tab SYSTEM.pa_num_tbl_type;
10183: New_Versions_Tab SYSTEM.pa_num_tbl_type;
10184:
10185: l_wp_inter_proj_depend_flag VARCHAR2(1);
10186: BEGIN

Line 10183: New_Versions_Tab SYSTEM.pa_num_tbl_type;

10179: END IF;
10180:
10181: DECLARE
10182: Old_Versions_Tab SYSTEM.pa_num_tbl_type;
10183: New_Versions_Tab SYSTEM.pa_num_tbl_type;
10184:
10185: l_wp_inter_proj_depend_flag VARCHAR2(1);
10186: BEGIN
10187: SELECT Element_Version_ID, attribute15 BULK COLLECT

Line 10227: src_versions_tab SYSTEM.pa_num_tbl_type;

10223: SELECT structure_sharing_code
10224: FROM pa_projects_all
10225: WHERE project_id = p_dest_project_id;
10226:
10227: src_versions_tab SYSTEM.pa_num_tbl_type;
10228: dest_versions_tab SYSTEM.pa_num_tbl_type;
10229: l_dest_proj_struc_shr_code VARCHAR2(30);
10230:
10231: l_wp_res_assign_flag VARCHAR2(1) := 'N';

Line 10228: dest_versions_tab SYSTEM.pa_num_tbl_type;

10224: FROM pa_projects_all
10225: WHERE project_id = p_dest_project_id;
10226:
10227: src_versions_tab SYSTEM.pa_num_tbl_type;
10228: dest_versions_tab SYSTEM.pa_num_tbl_type;
10229: l_dest_proj_struc_shr_code VARCHAR2(30);
10230:
10231: l_wp_res_assign_flag VARCHAR2(1) := 'N';
10232: l_wp_ra_people_flag VARCHAR2(1) := 'N';

Line 12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

12861: -- Changes added by skannoji
12862: -- Added code for doosan customer
12863: Declare
12864: /* Bug #: 3305199 SMukka */
12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
12866: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12867: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12868: src_versions_tab SYSTEM.pa_num_tbl_type;
12869: dest_versions_tab SYSTEM.pa_num_tbl_type;

Line 12868: src_versions_tab SYSTEM.pa_num_tbl_type;

12864: /* Bug #: 3305199 SMukka */
12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
12866: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12867: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12868: src_versions_tab SYSTEM.pa_num_tbl_type;
12869: dest_versions_tab SYSTEM.pa_num_tbl_type;
12870: Begin
12871: Select Element_Version_ID, attribute15 BULK COLLECT
12872: INTO dest_versions_tab, src_Versions_Tab

Line 12869: dest_versions_tab SYSTEM.pa_num_tbl_type;

12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
12866: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12867: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12868: src_versions_tab SYSTEM.pa_num_tbl_type;
12869: dest_versions_tab SYSTEM.pa_num_tbl_type;
12870: Begin
12871: Select Element_Version_ID, attribute15 BULK COLLECT
12872: INTO dest_versions_tab, src_Versions_Tab
12873: From PA_Proj_Element_Versions

Line 13557: -- to SYSTEM.pa_num_tbl_type from PA_NUM_1000_NUM

13553: /* Bug # 3420093 - Adding Progress Management modifications to create_project and update_project flow. */
13554:
13555: -- Amit Bug 3964548 Begin
13556: -- Changed l_add_task_ver_ids, l_add_planned_effort, l_add_start_date, l_add_end_date
13557: -- to SYSTEM.pa_num_tbl_type from PA_NUM_1000_NUM
13558: --l_add_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
13559: --l_add_planned_effort PA_NUM_1000_NUM := PA_NUM_1000_NUM();
13560: --l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13561: --l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();

Line 13563: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

13559: --l_add_planned_effort PA_NUM_1000_NUM := PA_NUM_1000_NUM();
13560: --l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13561: --l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13562:
13563: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13564: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13565: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13566: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13567: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 13564: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

13560: --l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13561: --l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13562:
13563: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13564: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13565: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13566: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13567: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
13568: l_add_plan_task_id NUMBER;

Line 13583: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

13579: and pstype.structure_type_id = types.structure_type_id
13580: and types.structure_type = p_structure_type);
13581: -- Amit Bug 3964548 End
13582:
13583: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13584:
13585: cursor l_task_cur(p_project_id NUMBER) is
13586: select
13587: element_version_id,planned_effort,actual_start_date,actual_finish_date

Line 19183: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

19179: RAISE Invalid_Arg_Exc_WP;
19180: END IF;
19181:
19182: DECLARE
19183: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19184: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19185: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
19186: BEGIN
19187: src_versions_tab.extend(1);

Line 19184: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

19180: END IF;
19181:
19182: DECLARE
19183: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19184: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19185: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
19186: BEGIN
19187: src_versions_tab.extend(1);
19188: dest_versions_tab.extend(1);

Line 19185: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386

19181:
19182: DECLARE
19183: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19184: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19185: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
19186: BEGIN
19187: src_versions_tab.extend(1);
19188: dest_versions_tab.extend(1);
19189: src_versions_tab(1) := p_structure_version_id;