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 2580: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

2576: -- Added by skannoji
2577: -- Added for doosan customer to delete structure version id for workplan
2578: DECLARE
2579: /* Bug #: 3305199 SMukka */
2580: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2581: /* l_struct_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
2582: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
2583: BEGIN
2584: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN') = 'Y') THEN

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

2578: DECLARE
2579: /* Bug #: 3305199 SMukka */
2580: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2581: /* l_struct_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
2582: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
2583: BEGIN
2584: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN') = 'Y') THEN
2585: l_struct_version_id_tbl.extend(1); /* Venky */
2586: l_struct_version_id_tbl(1) := p_structure_version_id;

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

2994:
2995: ----------------------------------- FP_M changes : Begin
2996: -- Refer to tracking bug 3305199
2997: /* Bug #: 3305199 SMukka */
2998: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2999: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3000: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3001: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3002: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

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

2997: /* Bug #: 3305199 SMukka */
2998: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2999: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3000: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3001: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3002: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3003: ----------------------------------- FP_M changes : End
3004:
3005: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)

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

2998: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2999: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3000: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3001: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3002: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3003: ----------------------------------- FP_M changes : End
3004:
3005: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)
3006: IS

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

5080:
5081: -- Changes added by skannoji
5082: -- Added code for doosan customer
5083: /* Bug #: 3305199 SMukka */
5084: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5085: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
5086: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
5087: --bug 4019845
5088: /*

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

5086: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
5087: --bug 4019845
5088: /*
5089: Declare
5090: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5091: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5092: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
5093: Begin
5094: src_versions_tab.extend(1);

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

5087: --bug 4019845
5088: /*
5089: Declare
5090: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5091: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5092: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
5093: Begin
5094: src_versions_tab.extend(1);
5095: dest_versions_tab.extend(1);

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

5088: /*
5089: Declare
5090: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5091: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5092: prev_pub_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3847386
5093: Begin
5094: src_versions_tab.extend(1);
5095: dest_versions_tab.extend(1);
5096: src_versions_tab(1) := p_structure_version_id;

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

13522: -- Refer to tracking bug 3305199
13523: --
13524: Declare
13525: /* Bug #: 3305199 SMukka */
13526: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13527: /* Old_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13528: /* New_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13529: Old_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13530: New_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

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

13525: /* Bug #: 3305199 SMukka */
13526: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13527: /* Old_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13528: /* New_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13529: Old_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13530: New_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13531: Begin
13532: Select Element_Version_ID, attribute15 BULK COLLECT
13533: INTO New_Versions_Tab, Old_Versions_Tab

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

13526: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13527: /* Old_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13528: /* New_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
13529: Old_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13530: New_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13531: Begin
13532: Select Element_Version_ID, attribute15 BULK COLLECT
13533: INTO New_Versions_Tab, Old_Versions_Tab
13534: From PA_Proj_Element_Versions

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

13630: -- Added code for doosan customer
13631: IF (l_wp_struc = 'Y') THEN
13632: Declare
13633: /* Bug #: 3305199 SMukka */
13634: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13635: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13636: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13637: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13638: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

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

13633: /* Bug #: 3305199 SMukka */
13634: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13635: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13636: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13637: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13638: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13639: Begin
13640: src_versions_tab.extend(1); /* Venky */
13641: dest_versions_tab.extend(1); /* Venky */

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

13634: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13635: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13636: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13637: src_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13638: dest_versions_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13639: Begin
13640: src_versions_tab.extend(1); /* Venky */
13641: dest_versions_tab.extend(1); /* Venky */
13642: src_versions_tab(1) := p_structure_version_id;

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

14057: l_delv_enabled VARCHAR2(1);
14058: l_share_code VARCHAR2(30);
14059: l_new_share_code VARCHAR2(30);
14060:
14061: l_struct_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
14062:
14063: /* Bug # 3420093. Progress Management changes. */
14064:
14065: l_proj_progress_attr_id NUMBER;