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 1228: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1224: l_add_planned_effort PA_NUM_1000_NUM := PA_NUM_1000_NUM();
1225: l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
1226: l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
1227:
1228: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1229:
1230: /* Bug # 3420093 - Adding Progress Management modifications to create_task flow. */
1231:
1232: --Bug 6153503

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

2663:
2664: --New tbls (suffixed with _prm), created below will be used as parameters in the call to
2665: --pa_task_pub1.call_add_planning_txns
2666:
2667: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2668: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2669: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2670: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2671: l_add_task_ver_ids_prm PA_NUM_1000_NUM := PA_NUM_1000_NUM();

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

2664: --New tbls (suffixed with _prm), created below will be used as parameters in the call to
2665: --pa_task_pub1.call_add_planning_txns
2666:
2667: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2668: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2669: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2670: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2671: l_add_task_ver_ids_prm PA_NUM_1000_NUM := PA_NUM_1000_NUM();
2672: l_add_planned_effort_prm PA_NUM_1000_NUM := PA_NUM_1000_NUM();

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

2673: l_add_start_date_prm PA_DATE_1000_DATE := PA_DATE_1000_DATE();
2674: l_add_end_date_prm PA_DATE_1000_DATE := PA_DATE_1000_DATE();
2675: rec_count NUMBER;
2676:
2677: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2678:
2679: cursor l_task_cur(p_project_id NUMBER, p_struct_ver_id NUMBER) is
2680: /* --bug 3880482
2681: select

Line 10476: Old_Versions_Tab SYSTEM.pa_num_tbl_type;

10472: END IF;
10473: END IF;
10474:
10475: DECLARE
10476: Old_Versions_Tab SYSTEM.pa_num_tbl_type;
10477: New_Versions_Tab SYSTEM.pa_num_tbl_type;
10478:
10479: l_wp_inter_proj_depend_flag VARCHAR2(1);
10480: BEGIN

Line 10477: New_Versions_Tab SYSTEM.pa_num_tbl_type;

10473: END IF;
10474:
10475: DECLARE
10476: Old_Versions_Tab SYSTEM.pa_num_tbl_type;
10477: New_Versions_Tab SYSTEM.pa_num_tbl_type;
10478:
10479: l_wp_inter_proj_depend_flag VARCHAR2(1);
10480: BEGIN
10481: SELECT Element_Version_ID, attribute15 BULK COLLECT

Line 10521: src_versions_tab SYSTEM.pa_num_tbl_type;

10517: SELECT structure_sharing_code
10518: FROM pa_projects_all
10519: WHERE project_id = p_dest_project_id;
10520:
10521: src_versions_tab SYSTEM.pa_num_tbl_type;
10522: dest_versions_tab SYSTEM.pa_num_tbl_type;
10523: l_dest_proj_struc_shr_code VARCHAR2(30);
10524:
10525: l_wp_res_assign_flag VARCHAR2(1) := 'N';

Line 10522: dest_versions_tab SYSTEM.pa_num_tbl_type;

10518: FROM pa_projects_all
10519: WHERE project_id = p_dest_project_id;
10520:
10521: src_versions_tab SYSTEM.pa_num_tbl_type;
10522: dest_versions_tab SYSTEM.pa_num_tbl_type;
10523: l_dest_proj_struc_shr_code VARCHAR2(30);
10524:
10525: l_wp_res_assign_flag VARCHAR2(1) := 'N';
10526: l_wp_ra_people_flag VARCHAR2(1) := 'N';

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

13190: -- Changes added by skannoji
13191: -- Added code for doosan customer
13192: Declare
13193: /* Bug #: 3305199 SMukka */
13194: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13195: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13196: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13197: src_versions_tab SYSTEM.pa_num_tbl_type;
13198: dest_versions_tab SYSTEM.pa_num_tbl_type;

Line 13197: src_versions_tab SYSTEM.pa_num_tbl_type;

13193: /* Bug #: 3305199 SMukka */
13194: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13195: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13196: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13197: src_versions_tab SYSTEM.pa_num_tbl_type;
13198: dest_versions_tab SYSTEM.pa_num_tbl_type;
13199: Begin
13200: Select Element_Version_ID, attribute15 BULK COLLECT
13201: INTO dest_versions_tab, src_Versions_Tab

Line 13198: dest_versions_tab SYSTEM.pa_num_tbl_type;

13194: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13195: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13196: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13197: src_versions_tab SYSTEM.pa_num_tbl_type;
13198: dest_versions_tab SYSTEM.pa_num_tbl_type;
13199: Begin
13200: Select Element_Version_ID, attribute15 BULK COLLECT
13201: INTO dest_versions_tab, src_Versions_Tab
13202: From PA_Proj_Element_Versions

Line 13904: -- to SYSTEM.pa_num_tbl_type from PA_NUM_1000_NUM

13900: /* Bug # 3420093 - Adding Progress Management modifications to create_project and update_project flow. */
13901:
13902: -- Amit Bug 3964548 Begin
13903: -- Changed l_add_task_ver_ids, l_add_planned_effort, l_add_start_date, l_add_end_date
13904: -- to SYSTEM.pa_num_tbl_type from PA_NUM_1000_NUM
13905: --l_add_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
13906: --l_add_planned_effort PA_NUM_1000_NUM := PA_NUM_1000_NUM();
13907: --l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13908: --l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();

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

13906: --l_add_planned_effort PA_NUM_1000_NUM := PA_NUM_1000_NUM();
13907: --l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13908: --l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13909:
13910: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13911: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13912: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13913: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13914: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

13907: --l_add_start_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13908: --l_add_end_date PA_DATE_1000_DATE := PA_DATE_1000_DATE();
13909:
13910: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13911: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13912: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13913: l_add_end_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13914: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
13915: l_add_plan_task_id NUMBER;

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

13926: and pstype.structure_type_id = types.structure_type_id
13927: and types.structure_type = p_structure_type);
13928: -- Amit Bug 3964548 End
13929:
13930: l_del_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13931:
13932: cursor l_task_cur(p_project_id NUMBER) is
13933: select
13934: element_version_id,planned_effort,actual_start_date,actual_finish_date

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

19972: RAISE Invalid_Arg_Exc_WP;
19973: END IF;
19974:
19975: DECLARE
19976: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19977: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19978: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
19979: BEGIN
19980: src_versions_tab.extend(1);

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

19973: END IF;
19974:
19975: DECLARE
19976: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19977: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19978: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
19979: BEGIN
19980: src_versions_tab.extend(1);
19981: dest_versions_tab.extend(1);

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

19974:
19975: DECLARE
19976: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19977: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
19978: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
19979: BEGIN
19980: src_versions_tab.extend(1);
19981: dest_versions_tab.extend(1);
19982: src_versions_tab(1) := p_structure_version_id;