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

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

2595: -- Added by skannoji
2596: -- Added for doosan customer to delete structure version id for workplan
2597: DECLARE
2598: /* Bug #: 3305199 SMukka */
2599: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2600: /* l_struct_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
2601: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
2602: BEGIN
2603: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN') = 'Y') THEN

Line 2601: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

2597: DECLARE
2598: /* Bug #: 3305199 SMukka */
2599: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2600: /* l_struct_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
2601: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
2602: BEGIN
2603: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN') = 'Y') THEN
2604: l_struct_version_id_tbl.extend(1); /* Venky */
2605: l_struct_version_id_tbl(1) := p_structure_version_id;

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

3024:
3025: ----------------------------------- FP_M changes : Begin
3026: -- Refer to tracking bug 3305199
3027: /* Bug #: 3305199 SMukka */
3028: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3029: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3030: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3031: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3032: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 3031: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3027: /* Bug #: 3305199 SMukka */
3028: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3029: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3030: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3031: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3032: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3033: ----------------------------------- FP_M changes : End
3034:
3035: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)

Line 3032: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3028: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3029: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3030: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3031: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3032: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3033: ----------------------------------- FP_M changes : End
3034:
3035: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)
3036: IS

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

5140:
5141: -- Changes added by skannoji
5142: -- Added code for doosan customer
5143: /* Bug #: 3305199 SMukka */
5144: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5145: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
5146: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
5147: --bug 4019845
5148: /*

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

5146: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
5147: --bug 4019845
5148: /*
5149: Declare
5150: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5151: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5152: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
5153: Begin
5154: src_versions_tab.extend(1);

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

5147: --bug 4019845
5148: /*
5149: Declare
5150: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5151: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5152: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
5153: Begin
5154: src_versions_tab.extend(1);
5155: dest_versions_tab.extend(1);

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

5148: /*
5149: Declare
5150: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5151: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5152: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
5153: Begin
5154: src_versions_tab.extend(1);
5155: dest_versions_tab.extend(1);
5156: src_versions_tab(1) := p_structure_version_id;

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

13894: -- Refer to tracking bug 3305199
13895: --
13896: Declare
13897: /* Bug #: 3305199 SMukka */
13898: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13899: /* Old_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13900: /* New_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13901: Old_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13902: New_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 13901: Old_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

13897: /* Bug #: 3305199 SMukka */
13898: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13899: /* Old_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13900: /* New_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13901: Old_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13902: New_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13903: Begin
13904: Select Element_Version_ID, attribute15 BULK COLLECT
13905: INTO New_Versions_Tab, Old_Versions_Tab

Line 13902: New_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

13898: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13899: /* Old_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13900: /* New_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13901: Old_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13902: New_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13903: Begin
13904: Select Element_Version_ID, attribute15 BULK COLLECT
13905: INTO New_Versions_Tab, Old_Versions_Tab
13906: From PA_Proj_Element_Versions

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

14002: -- Added code for doosan customer
14003: IF (l_wp_struc = 'Y') THEN
14004: Declare
14005: /* Bug #: 3305199 SMukka */
14006: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
14007: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
14008: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
14009: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
14010: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 14009: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

14005: /* Bug #: 3305199 SMukka */
14006: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
14007: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
14008: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
14009: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
14010: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
14011: Begin
14012: src_versions_tab.extend(1); /* Venky */
14013: dest_versions_tab.extend(1); /* Venky */

Line 14010: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

14006: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
14007: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
14008: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
14009: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
14010: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
14011: Begin
14012: src_versions_tab.extend(1); /* Venky */
14013: dest_versions_tab.extend(1); /* Venky */
14014: src_versions_tab(1) := p_structure_version_id;

Line 14435: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

14431: l_delv_enabled VARCHAR2(1);
14432: l_share_code VARCHAR2(30);
14433: l_new_share_code VARCHAR2(30);
14434:
14435: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
14436:
14437: /* Bug # 3420093. Progress Management changes. */
14438:
14439: l_proj_progress_attr_id NUMBER;