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_PVT dependencies on PA_PROJECT_PUB

Line 53: p_key_members IN pa_project_pub.project_role_tbl_type )

49: PROCEDURE add_key_members
50: ( p_return_status OUT NOCOPY VARCHAR2 , --4537865 Added nocopy hint
51: p_pa_source_template_id IN NUMBER ,
52: p_project_id IN NUMBER ,
53: p_key_members IN pa_project_pub.project_role_tbl_type )
54: IS
55:
56: --needed to get the overridable fields for this project template source
57: /* commented the code for the Bug#1891621, starts here */

Line 537: p_class_categories IN pa_project_pub.class_category_tbl_type )

533: PROCEDURE add_class_categories
534: ( p_return_status OUT NOCOPY VARCHAR2 , -- 4537865 Added the nocopy hint
535: p_pa_source_template_id IN NUMBER ,
536: p_project_id IN NUMBER ,
537: p_class_categories IN pa_project_pub.class_category_tbl_type )
538: IS
539:
540: --needed to get the overridable fields for this project template source
541: /* code commented for the bug#1891621, starts here */

Line 1011: ,p_task_rec IN pa_project_pub.task_in_rec_type

1007: -- 09-01-2006 vkadimes Changes are tagged with Bug Number 4689326.
1008: PROCEDURE add_task_round_one
1009: (p_return_status OUT NOCOPY VARCHAR2 -- 4537865 Added nocopy hint
1010: ,p_project_rec IN pa_projects%rowtype
1011: ,p_task_rec IN pa_project_pub.task_in_rec_type
1012: ,p_project_type_class_code IN pa_project_types.project_type_class_code%type
1013: ,p_service_type_code IN pa_project_types.service_type_code%type
1014: ,p_task_id OUT NOCOPY NUMBER ) -- 4537865 Added nocopy hint
1015: IS

Line 1054: l_task_in_rec pa_project_pub.task_in_rec_type;

1050:
1051: l_api_name CONSTANT VARCHAR2(30) := 'add_task_round_one';
1052: l_task_id NUMBER;
1053: l_project_id NUMBER;
1054: l_task_in_rec pa_project_pub.task_in_rec_type;
1055: l_wbs_level NUMBER :=1;
1056: l_dummy VARCHAR2(1);
1057: l_customer_id NUMBER;
1058: l_address_id NUMBER;

Line 2068: (PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' OR PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y') AND

2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;
2066: -- Added ELSE condition for Huawei enhancement to update both Workplan and financial tasks DFFs Bug 13923366
2067: ELSIF (l_task_in_rec.tasks_dff = 'N' AND
2068: (PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' OR PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y') AND
2069: (PA_PROJECT_PUB.G_FP_DFF_TBL.COUNT > 0)) THEN
2070:
2071: i := PA_PROJECT_PUB.G_FP_DFF_TBL.FIRST;
2072: WHILE i IS NOT NULL LOOP

Line 2069: (PA_PROJECT_PUB.G_FP_DFF_TBL.COUNT > 0)) THEN

2065: END IF;
2066: -- Added ELSE condition for Huawei enhancement to update both Workplan and financial tasks DFFs Bug 13923366
2067: ELSIF (l_task_in_rec.tasks_dff = 'N' AND
2068: (PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' OR PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y') AND
2069: (PA_PROJECT_PUB.G_FP_DFF_TBL.COUNT > 0)) THEN
2070:
2071: i := PA_PROJECT_PUB.G_FP_DFF_TBL.FIRST;
2072: WHILE i IS NOT NULL LOOP
2073: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).pa_task_name = l_task_in_rec.task_name AND

Line 2071: i := PA_PROJECT_PUB.G_FP_DFF_TBL.FIRST;

2067: ELSIF (l_task_in_rec.tasks_dff = 'N' AND
2068: (PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' OR PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y') AND
2069: (PA_PROJECT_PUB.G_FP_DFF_TBL.COUNT > 0)) THEN
2070:
2071: i := PA_PROJECT_PUB.G_FP_DFF_TBL.FIRST;
2072: WHILE i IS NOT NULL LOOP
2073: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).pa_task_name = l_task_in_rec.task_name AND
2074: PA_PROJECT_PUB.G_FP_DFF_TBL(i).pm_task_reference = l_task_in_rec.pm_task_reference THEN
2075: EXIT;

Line 2073: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).pa_task_name = l_task_in_rec.task_name AND

2069: (PA_PROJECT_PUB.G_FP_DFF_TBL.COUNT > 0)) THEN
2070:
2071: i := PA_PROJECT_PUB.G_FP_DFF_TBL.FIRST;
2072: WHILE i IS NOT NULL LOOP
2073: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).pa_task_name = l_task_in_rec.task_name AND
2074: PA_PROJECT_PUB.G_FP_DFF_TBL(i).pm_task_reference = l_task_in_rec.pm_task_reference THEN
2075: EXIT;
2076: ELSE
2077: i := PA_PROJECT_PUB.G_FP_DFF_TBL.NEXT(i);

Line 2074: PA_PROJECT_PUB.G_FP_DFF_TBL(i).pm_task_reference = l_task_in_rec.pm_task_reference THEN

2070:
2071: i := PA_PROJECT_PUB.G_FP_DFF_TBL.FIRST;
2072: WHILE i IS NOT NULL LOOP
2073: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).pa_task_name = l_task_in_rec.task_name AND
2074: PA_PROJECT_PUB.G_FP_DFF_TBL(i).pm_task_reference = l_task_in_rec.pm_task_reference THEN
2075: EXIT;
2076: ELSE
2077: i := PA_PROJECT_PUB.G_FP_DFF_TBL.NEXT(i);
2078: END IF;

Line 2077: i := PA_PROJECT_PUB.G_FP_DFF_TBL.NEXT(i);

2073: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).pa_task_name = l_task_in_rec.task_name AND
2074: PA_PROJECT_PUB.G_FP_DFF_TBL(i).pm_task_reference = l_task_in_rec.pm_task_reference THEN
2075: EXIT;
2076: ELSE
2077: i := PA_PROJECT_PUB.G_FP_DFF_TBL.NEXT(i);
2078: END IF;
2079: END LOOP;
2080:
2081: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2081: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2077: i := PA_PROJECT_PUB.G_FP_DFF_TBL.NEXT(i);
2078: END IF;
2079: END LOOP;
2080:
2081: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2082: THEN
2083: l_attribute_category := NULL;
2084: ELSE
2085: l_attribute_category := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category;

Line 2085: l_attribute_category := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category;

2081: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2082: THEN
2083: l_attribute_category := NULL;
2084: ELSE
2085: l_attribute_category := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category;
2086: END IF;
2087: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2088: THEN
2089: l_attribute1 := NULL;

Line 2087: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2083: l_attribute_category := NULL;
2084: ELSE
2085: l_attribute_category := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute_category;
2086: END IF;
2087: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2088: THEN
2089: l_attribute1 := NULL;
2090: ELSE
2091: l_attribute1 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1;

Line 2091: l_attribute1 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1;

2087: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2088: THEN
2089: l_attribute1 := NULL;
2090: ELSE
2091: l_attribute1 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1;
2092: END IF;
2093: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2094: THEN
2095: l_attribute2 := NULL;

Line 2093: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2089: l_attribute1 := NULL;
2090: ELSE
2091: l_attribute1 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute1;
2092: END IF;
2093: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2094: THEN
2095: l_attribute2 := NULL;
2096: ELSE
2097: l_attribute2 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2;

Line 2097: l_attribute2 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2;

2093: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2094: THEN
2095: l_attribute2 := NULL;
2096: ELSE
2097: l_attribute2 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2;
2098: END IF;
2099: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2100: THEN
2101: l_attribute3 := NULL;

Line 2099: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2095: l_attribute2 := NULL;
2096: ELSE
2097: l_attribute2 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute2;
2098: END IF;
2099: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2100: THEN
2101: l_attribute3 := NULL;
2102: ELSE
2103: l_attribute3 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3;

Line 2103: l_attribute3 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3;

2099: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2100: THEN
2101: l_attribute3 := NULL;
2102: ELSE
2103: l_attribute3 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3;
2104: END IF;
2105: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2106: THEN
2107: l_attribute4 := NULL;

Line 2105: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2101: l_attribute3 := NULL;
2102: ELSE
2103: l_attribute3 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute3;
2104: END IF;
2105: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2106: THEN
2107: l_attribute4 := NULL;
2108: ELSE
2109: l_attribute4 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4;

Line 2109: l_attribute4 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4;

2105: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2106: THEN
2107: l_attribute4 := NULL;
2108: ELSE
2109: l_attribute4 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4;
2110: END IF;
2111:
2112: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2113: THEN

Line 2112: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2108: ELSE
2109: l_attribute4 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute4;
2110: END IF;
2111:
2112: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2113: THEN
2114: l_attribute5 := NULL;
2115: ELSE
2116: l_attribute5 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5;

Line 2116: l_attribute5 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5;

2112: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2113: THEN
2114: l_attribute5 := NULL;
2115: ELSE
2116: l_attribute5 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5;
2117: END IF;
2118:
2119: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2120: THEN

Line 2119: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2115: ELSE
2116: l_attribute5 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute5;
2117: END IF;
2118:
2119: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2120: THEN
2121: l_attribute6 := NULL;
2122: ELSE
2123: l_attribute6 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6;

Line 2123: l_attribute6 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6;

2119: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2120: THEN
2121: l_attribute6 := NULL;
2122: ELSE
2123: l_attribute6 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6;
2124: END IF;
2125:
2126: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2127: THEN

Line 2126: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2122: ELSE
2123: l_attribute6 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute6;
2124: END IF;
2125:
2126: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2127: THEN
2128: l_attribute7 := NULL;
2129: ELSE
2130: l_attribute7 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7;

Line 2130: l_attribute7 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7;

2126: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2127: THEN
2128: l_attribute7 := NULL;
2129: ELSE
2130: l_attribute7 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7;
2131: END IF;
2132:
2133: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2134: THEN

Line 2133: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2129: ELSE
2130: l_attribute7 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute7;
2131: END IF;
2132:
2133: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2134: THEN
2135: l_attribute8 := NULL;
2136: ELSE
2137: l_attribute8 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8;

Line 2137: l_attribute8 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8;

2133: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2134: THEN
2135: l_attribute8 := NULL;
2136: ELSE
2137: l_attribute8 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8;
2138: END IF;
2139: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2140: THEN
2141: l_attribute9 := NULL;

Line 2139: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2135: l_attribute8 := NULL;
2136: ELSE
2137: l_attribute8 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute8;
2138: END IF;
2139: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2140: THEN
2141: l_attribute9 := NULL;
2142: ELSE
2143: l_attribute9 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9;

Line 2143: l_attribute9 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9;

2139: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2140: THEN
2141: l_attribute9 := NULL;
2142: ELSE
2143: l_attribute9 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9;
2144: END IF;
2145: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2146: THEN
2147: l_attribute10 := NULL;

Line 2145: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2141: l_attribute9 := NULL;
2142: ELSE
2143: l_attribute9 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute9;
2144: END IF;
2145: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2146: THEN
2147: l_attribute10 := NULL;
2148: ELSE
2149: l_attribute10 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute10;

Line 2149: l_attribute10 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute10;

2145: IF PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2146: THEN
2147: l_attribute10 := NULL;
2148: ELSE
2149: l_attribute10 := PA_PROJECT_PUB.G_FP_DFF_TBL(i).attribute10;
2150: END IF;
2151:
2152: --bug 6153503 added below validation.
2153: pa_task_utils.validate_flex_fields(

Line 2835: ,p_task_rec IN pa_project_pub.task_in_rec_type

2831: PROCEDURE add_task_round_two
2832: (p_return_status OUT NOCOPY VARCHAR2 -- 4537865 Added nocopy hint
2833: ,p_project_rec IN pa_projects%rowtype
2834: ,p_task_id IN NUMBER
2835: ,p_task_rec IN pa_project_pub.task_in_rec_type
2836: --Project Structures
2837: ,p_ref_task_id IN NUMBER
2838: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
2839: ,p_tasks_out IN pa_project_pub.task_out_tbl_type

Line 2838: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

2834: ,p_task_id IN NUMBER
2835: ,p_task_rec IN pa_project_pub.task_in_rec_type
2836: --Project Structures
2837: ,p_ref_task_id IN NUMBER
2838: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
2839: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
2840: ,p_task_version_id OUT NOCOPY NUMBER -- 4537865 Added nocopy hint
2841: ,p_create_task_structure IN VARCHAR2 -- Added new parameter for performance changes. Bug 2931183
2842: --Project Structures

Line 2839: ,p_tasks_out IN pa_project_pub.task_out_tbl_type

2835: ,p_task_rec IN pa_project_pub.task_in_rec_type
2836: --Project Structures
2837: ,p_ref_task_id IN NUMBER
2838: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
2839: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
2840: ,p_task_version_id OUT NOCOPY NUMBER -- 4537865 Added nocopy hint
2841: ,p_create_task_structure IN VARCHAR2 -- Added new parameter for performance changes. Bug 2931183
2842: --Project Structures
2843: )

Line 2876: l_task_in_rec pa_project_pub.task_in_rec_type;

2872:
2873: -- 4537865
2874: l_new_task_id NUMBER;
2875:
2876: l_task_in_rec pa_project_pub.task_in_rec_type;
2877: l_wbs_level NUMBER :=1;
2878: l_project_id NUMBER;
2879: l_top_task_id NUMBER;
2880: l_parent_task_id NUMBER;

Line 3364: ELSE --Called from PA_PROJECT_PUB.ADD_TASK API.

3360: THEN
3361: v_task_id_above := null; --ref is the structure version. structure version is
3362: --derived in PA_PROJ_TASK_STRUC_PUB.create_task_structure API.
3363: END IF;
3364: ELSE --Called from PA_PROJECT_PUB.ADD_TASK API.
3365: v_task_id_above := p_ref_task_id;
3366: END IF;
3367:
3368: IF l_task_id IS NOT NULL

Line 4950: p_in_task_rec IN pa_project_pub.task_in_rec_type,

4946: --
4947: PROCEDURE Validate_billing_info
4948: (p_project_id IN NUMBER, -- Added for Bug 5643876
4949: p_project_class_code IN VARCHAR2,
4950: p_in_task_rec IN pa_project_pub.task_in_rec_type,
4951: p_return_status OUT NOCOPY VARCHAR2 ) IS -- 4537865 Added nocopy
4952:
4953: BEGIN
4954:

Line 5049: -- 03-DEC-1996 L. de Werker Moved from pa_project_pub to pa_project_pvt

5045: --
5046: --
5047: --History:
5048: -- 31-JUL-1996 R. Krishnamurthy Created
5049: -- 03-DEC-1996 L. de Werker Moved from pa_project_pub to pa_project_pvt
5050: --
5051: PROCEDURE check_for_one_manager
5052: (p_project_id IN NUMBER
5053: ,p_person_id IN NUMBER

Line 5054: ,p_key_members IN pa_project_pub.project_role_tbl_type

5050: --
5051: PROCEDURE check_for_one_manager
5052: (p_project_id IN NUMBER
5053: ,p_person_id IN NUMBER
5054: ,p_key_members IN pa_project_pub.project_role_tbl_type
5055: ,p_start_date IN DATE
5056: ,p_end_date IN DATE
5057: ,p_return_status OUT NOCOPY VARCHAR2 ) -- 4537865 Added nocopy hint
5058: IS

Line 5104: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,

5100: (p_project_id IN NUMBER,
5101: p_task_id IN NUMBER,
5102: p_array_cell_number IN NUMBER,
5103: p_in_task_number IN VARCHAR2,
5104: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,
5105: p_proceed_with_update_flag OUT NOCOPY VARCHAR2, -- 4537865
5106: p_return_status OUT NOCOPY VARCHAR2 ) -- 4537865
5107: IS
5108:

Line 5683: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN

5679: -- since the user does not have access to such functions
5680:
5681: -- Added the IF conditions below for Huawei enhancemnet bug 13923366 by skkoppul
5682: -- We are caching the security access
5683: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5684: IF PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED IS NULL THEN
5685:
5686:
5687: PA_PM_FUNCTION_SECURITY_PUB.check_function_security

Line 5684: IF PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED IS NULL THEN

5680:
5681: -- Added the IF conditions below for Huawei enhancemnet bug 13923366 by skkoppul
5682: -- We are caching the security access
5683: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5684: IF PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED IS NULL THEN
5685:
5686:
5687: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
5688: (p_api_version_number => p_api_version_number,

Line 5706: PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED := l_function_allowed;

5702: THEN
5703:
5704: RAISE FND_API.G_EXC_ERROR;
5705: END IF;
5706: PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED := l_function_allowed;
5707: ELSE
5708: l_function_allowed := PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED;
5709: END IF;
5710: ELSE

Line 5708: l_function_allowed := PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED;

5704: RAISE FND_API.G_EXC_ERROR;
5705: END IF;
5706: PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED := l_function_allowed;
5707: ELSE
5708: l_function_allowed := PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED;
5709: END IF;
5710: ELSE
5711: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
5712: (p_api_version_number => p_api_version_number,

Line 5781: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN

5777: --bug 2841158
5778:
5779: -- added IF conditions for Huawei enhancement bug 13923366 by skkoppul
5780: -- Caching pm_product_code
5781: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5782: IF PA_PROJECT_PUB.G_VALID_PRODUCT_CODE IS NULL THEN
5783: /*added for bug no :2413400*/
5784: OPEN p_product_code_csr (p_pm_product_code);
5785: FETCH p_product_code_csr INTO l_pm_product_code;

Line 5782: IF PA_PROJECT_PUB.G_VALID_PRODUCT_CODE IS NULL THEN

5778:
5779: -- added IF conditions for Huawei enhancement bug 13923366 by skkoppul
5780: -- Caching pm_product_code
5781: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5782: IF PA_PROJECT_PUB.G_VALID_PRODUCT_CODE IS NULL THEN
5783: /*added for bug no :2413400*/
5784: OPEN p_product_code_csr (p_pm_product_code);
5785: FETCH p_product_code_csr INTO l_pm_product_code;
5786: IF p_product_code_csr%NOTFOUND THEN

Line 5791: PA_PROJECT_PUB.G_VALID_PRODUCT_CODE := l_pm_product_code;

5787: l_pm_product_code := 'Y';
5788: END IF;
5789: CLOSE p_product_code_csr;
5790:
5791: PA_PROJECT_PUB.G_VALID_PRODUCT_CODE := l_pm_product_code;
5792: ELSE
5793: l_pm_product_code := PA_PROJECT_PUB.G_VALID_PRODUCT_CODE;
5794: END IF;
5795: ELSE

Line 5793: l_pm_product_code := PA_PROJECT_PUB.G_VALID_PRODUCT_CODE;

5789: CLOSE p_product_code_csr;
5790:
5791: PA_PROJECT_PUB.G_VALID_PRODUCT_CODE := l_pm_product_code;
5792: ELSE
5793: l_pm_product_code := PA_PROJECT_PUB.G_VALID_PRODUCT_CODE;
5794: END IF;
5795: ELSE
5796: OPEN p_product_code_csr (p_pm_product_code);
5797: FETCH p_product_code_csr INTO l_pm_product_code;

Line 5866: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN

5862: p_return_status := FND_API.G_RET_STS_ERROR;
5863: RAISE FND_API.G_EXC_ERROR;
5864: ELSE
5865: -- Caching for Huawei enhancement bug 13923366 by skkoppul
5866: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5867: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED IS NULL THEN
5868: PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED := pa_security.allow_update (x_project_id => l_project_id );
5869: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED = 'N' THEN
5870: pa_interface_utils_pub.map_new_amg_msg

Line 5867: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED IS NULL THEN

5863: RAISE FND_API.G_EXC_ERROR;
5864: ELSE
5865: -- Caching for Huawei enhancement bug 13923366 by skkoppul
5866: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5867: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED IS NULL THEN
5868: PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED := pa_security.allow_update (x_project_id => l_project_id );
5869: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED = 'N' THEN
5870: pa_interface_utils_pub.map_new_amg_msg
5871: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'

Line 5868: PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED := pa_security.allow_update (x_project_id => l_project_id );

5864: ELSE
5865: -- Caching for Huawei enhancement bug 13923366 by skkoppul
5866: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5867: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED IS NULL THEN
5868: PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED := pa_security.allow_update (x_project_id => l_project_id );
5869: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED = 'N' THEN
5870: pa_interface_utils_pub.map_new_amg_msg
5871: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
5872: ,p_msg_attribute => 'CHANGE'

Line 5869: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED = 'N' THEN

5865: -- Caching for Huawei enhancement bug 13923366 by skkoppul
5866: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5867: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED IS NULL THEN
5868: PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED := pa_security.allow_update (x_project_id => l_project_id );
5869: IF PA_PROJECT_PUB.G_UPDATE_PRJ_ALLOWED = 'N' THEN
5870: pa_interface_utils_pub.map_new_amg_msg
5871: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
5872: ,p_msg_attribute => 'CHANGE'
5873: ,p_resize_flag => 'Y'

Line 5927: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN

5923: END IF;
5924:
5925: -- Get segment1 for AMG messages
5926: -- Caching for Huawei enhancement bug 13923366 by skkoppul
5927: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5928: l_amg_segment1 := PA_PROJECT_PUB.G_SEGMENT1;
5929: ELSE
5930:
5931: OPEN l_amg_project_csr( l_project_id );

Line 5928: l_amg_segment1 := PA_PROJECT_PUB.G_SEGMENT1;

5924:
5925: -- Get segment1 for AMG messages
5926: -- Caching for Huawei enhancement bug 13923366 by skkoppul
5927: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
5928: l_amg_segment1 := PA_PROJECT_PUB.G_SEGMENT1;
5929: ELSE
5930:
5931: OPEN l_amg_project_csr( l_project_id );
5932: FETCH l_amg_project_csr INTO l_amg_segment1;

Line 6302: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN

6298: /* Added for bug#2666913 */
6299: -- Caching for Huawei enhancement bug 13923366 by skkoppul
6300: -- Assumption: currently in Bulk update mode, we are allowing p_billable_flag attribute to be updated
6301: -- but in future if this is accomodated following code needs to be changed.
6302: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN
6303:
6304: OPEN l_get_project_type_info_csr (l_task_rec.project_id);
6305: FETCH l_get_project_type_info_csr INTO l_project_type_class_code;
6306: CLOSE l_get_project_type_info_csr;

Line 6412: PA_PROJECT_PUB.CHECK_TASK_NUMBER_CHANGE_OK

6408: THEN
6409: /* CODE CHANGE BEGIN BY ADITI for Bug 4120380 **/
6410: --dbms_output.put_line('before caling CHECK_TASK_NUMBER_CHANGE_OK');
6411: /* bug #5243018: Reverting the fix in bug 4120380.
6412: PA_PROJECT_PUB.CHECK_TASK_NUMBER_CHANGE_OK
6413: ( p_api_version_number => p_api_version_number
6414: , p_return_status => L_RETURN_STATUS
6415: , p_msg_count => l_msg_count
6416: , p_msg_data => l_msg_data

Line 6513: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEn

6509: OR NVL(p_task_completion_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6510: OR (p_task_start_date is NULL and p_task_completion_date is NULL)) /*Bug 8854864*/
6511: THEN
6512: -- Caching for Huawei enhancement bug 13923366 by skkoppul
6513: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEn
6514: l_project_start_date := PA_PROJECT_PUB.G_PROJ_START_DATE;
6515: l_project_completion_date := PA_PROJECT_PUB.G_PROJ_COMPLETION_DATE;
6516: ELSE
6517: OPEN l_project_date_csr (l_project_id);

Line 6514: l_project_start_date := PA_PROJECT_PUB.G_PROJ_START_DATE;

6510: OR (p_task_start_date is NULL and p_task_completion_date is NULL)) /*Bug 8854864*/
6511: THEN
6512: -- Caching for Huawei enhancement bug 13923366 by skkoppul
6513: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEn
6514: l_project_start_date := PA_PROJECT_PUB.G_PROJ_START_DATE;
6515: l_project_completion_date := PA_PROJECT_PUB.G_PROJ_COMPLETION_DATE;
6516: ELSE
6517: OPEN l_project_date_csr (l_project_id);
6518: FETCH l_project_date_csr INTO l_project_start_date, l_project_completion_date; --l_project_date_rec;

Line 6515: l_project_completion_date := PA_PROJECT_PUB.G_PROJ_COMPLETION_DATE;

6511: THEN
6512: -- Caching for Huawei enhancement bug 13923366 by skkoppul
6513: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEn
6514: l_project_start_date := PA_PROJECT_PUB.G_PROJ_START_DATE;
6515: l_project_completion_date := PA_PROJECT_PUB.G_PROJ_COMPLETION_DATE;
6516: ELSE
6517: OPEN l_project_date_csr (l_project_id);
6518: FETCH l_project_date_csr INTO l_project_start_date, l_project_completion_date; --l_project_date_rec;
6519: CLOSE l_project_date_csr;

Line 6542: IF pa_project_pub.G_ParChildTsk_chks_deferred = 'N' THEN

6538: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6539: RAISE FND_API.G_EXC_ERROR;
6540: END IF;
6541:
6542: IF pa_project_pub.G_ParChildTsk_chks_deferred = 'N' THEN
6543: IF l_children_exist = 'Y' THEN
6544: OPEN l_outer_child_dates_csr (l_project_id,l_task_id);
6545: FETCH l_outer_child_dates_csr INTO
6546: l_min_child_start_date, l_max_child_completion_date;

Line 6583: IF pa_project_pub.G_ParChildTsk_chks_deferred = 'N' THEN

6579:
6580: -- Do the comparison between parent and child task dates only if
6581: -- the global variable is set to 'N'
6582:
6583: IF pa_project_pub.G_ParChildTsk_chks_deferred = 'N' THEN
6584: IF l_children_exist = 'Y' THEN
6585: IF l_min_child_start_date < p_task_start_date THEN
6586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6587: pa_interface_utils_pub.map_new_amg_msg

Line 6619: END IF; -- End if pa_project_pub.G_ParChildTsk_chks_deferred

6615: END IF;
6616: RAISE FND_API.G_EXC_ERROR;
6617: END IF;
6618: END IF;
6619: END IF; -- End if pa_project_pub.G_ParChildTsk_chks_deferred
6620:
6621: --BUG 4081329 rtarway, validate for EI date also
6622: --bug 13011347 start
6623: --bypass the date validation for the partially shared when source is workplan and msproject.

Line 6680: IF pa_project_pub.G_ParChildTsk_chks_deferred = 'N' THEN

6676:
6677: -- Do the comparison between parent and child task dates only if
6678: -- the global variable is set to 'N'
6679:
6680: IF pa_project_pub.G_ParChildTsk_chks_deferred = 'N' THEN
6681: /* IF l_children_exist = 'Y' THEN
6682: IF l_max_child_completion_date > p_task_completion_date THEN
6683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6684: THEN

Line 6720: END IF; -- End if pa_project_pub.G_ParChildTsk_chks_deferred;

6716: END IF;
6717: RAISE FND_API.G_EXC_ERROR;
6718: END IF;
6719: END IF;
6720: END IF; -- End if pa_project_pub.G_ParChildTsk_chks_deferred;
6721:
6722: --BUG 4081329, rtarway
6723: -- Validate for END EI dates too
6724: --bug 13011347 start

Line 6839: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN

6835:
6836: -- Caching for Huawei enhancement bug 13923366 by skkoppul
6837: -- Assumption: currently in Bulk update mode, we are allowing p_pm_parent_task_reference value to be passed
6838: -- but in future if this is accomodated following code needs to be changed.
6839: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN
6840:
6841: IF p_pm_parent_task_reference IS NULL AND
6842: l_task_rec.parent_task_id IS NOT NULL THEN
6843:

Line 6869: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN

6865: AND l_new_parent_task_id <> NVL(l_task_rec.parent_task_id,
6866: PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6867: THEN
6868: --rtarway, for DHI ER, BUG 4413568
6869: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN
6870: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
6871: p_msg_name => 'PA_WBS_CANT_CHANGE');
6872: RAISE FND_API.G_EXC_ERROR;
6873: END IF;

Line 7169: (PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' AND PA_PROJECT_PUB.G_FP_DFF_TBL.COUNT > 0)) THEN -- BEGIN changes for bug 13680655

7165:
7166: END IF;
7167:
7168: IF (p_tasks_dff = 'Y' OR
7169: (PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' AND PA_PROJECT_PUB.G_FP_DFF_TBL.COUNT > 0)) THEN -- BEGIN changes for bug 13680655
7170: --bug 6153503
7171: IF (p_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
7172: p_attribute_category IS NULL) THEN
7173:

Line 7261: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'1234') = 'Y' THEN

7257: l_attribute10 := l_task_rec.attribute10;
7258: END IF;
7259: /* Bug 7403227 start */
7260: -- Caching for Huawei enhancement bug 13923366 by skkoppul
7261: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'1234') = 'Y' THEN
7262: l_project_type2 := PA_PROJECT_PUB.G_PROJECT_TYPE;
7263: ELSE
7264:
7265: BEGIN

Line 7262: l_project_type2 := PA_PROJECT_PUB.G_PROJECT_TYPE;

7258: END IF;
7259: /* Bug 7403227 start */
7260: -- Caching for Huawei enhancement bug 13923366 by skkoppul
7261: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'1234') = 'Y' THEN
7262: l_project_type2 := PA_PROJECT_PUB.G_PROJECT_TYPE;
7263: ELSE
7264:
7265: BEGIN
7266: IF p_pa_project_id IS NOT NULL THEN

Line 8011: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN

8007: -- Schedule type validation is not need as we are not passing the values
8008: -- Assumption: currently in Bulk update mode, we are allowing atttributes like p_labor_sch_type,
8009: -- p_nl_sch_type and p_pm_task_reference to be passed in to be updated
8010: -- but in future if these are accomodated following code needs to be changed.
8011: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN
8012:
8013: Check_Schedule_type
8014: (p_pa_task_id => l_task_id,
8015: p_pa_project_id => l_project_id,

Line 10060: The task deletion calls the PA_PROJECT_PUB.DELETE_TASK API. This was returning an error with status 'E' and error

10056: The task deletion from MSP was erroring out.
10057:
10058: Analysis:
10059:
10060: The task deletion calls the PA_PROJECT_PUB.DELETE_TASK API. This was returning an error with status 'E' and error
10061: message PA_TASK_REF_AND_ID_MISSING. There is a call to Convert_pm_taskref_to_id_all API in the PA_PROJECT_PVT.DELETE_TASK1
10062: in the WORKPLAN portion of the code.
10063: Please note that the same local variable l_task_id is used for both IN and OUT parameters. Due to the NOCOPY hint the variable
10064: l_task_id was becoming null when the control enters into the Convert_pm_taskref_to_id_all API. As the required parameter was

Line 10693: p_org_roles IN pa_project_pub.project_role_tbl_type )

10689: PROCEDURE add_org_roles
10690: ( p_return_status OUT NOCOPY VARCHAR2 , -- 4537865 Added nocopy hint
10691: p_pa_source_template_id IN NUMBER ,
10692: p_project_id IN NUMBER ,
10693: p_org_roles IN pa_project_pub.project_role_tbl_type )
10694: IS
10695: --Bug#10124493 - project_role_type validation should be from pa_project_role_types_vl view
10696: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2)
10697: IS

Line 11014: ,p_structure_versions_out OUT NOCOPY PA_PROJECT_PUB.struc_out_tbl_type )

11010: --Project Connect 4.0
11011:
11012: PROCEDURE get_structure_version(
11013: p_project_id IN NUMBER
11014: ,p_structure_versions_out OUT NOCOPY PA_PROJECT_PUB.struc_out_tbl_type )
11015: IS
11016: CURSOR cur_proj_elems
11017: IS
11018: SELECT ppe.proj_element_id