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

Line 1: PACKAGE BODY pa_project_pub AS

1: PACKAGE BODY pa_project_pub AS
2: /* $Header: PAPMPRPB.pls 120.75.12010000.20 2009/02/12 13:52:52 kjai ship $ */
3: --Global constants to be used in error messages
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_PUB';
5: G_PROJECT_CODE CONSTANT VARCHAR2(7) := 'PROJECT';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_PUB';

1: PACKAGE BODY pa_project_pub AS
2: /* $Header: PAPMPRPB.pls 120.75.12010000.20 2009/02/12 13:52:52 kjai ship $ */
3: --Global constants to be used in error messages
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_PUB';
5: G_PROJECT_CODE CONSTANT VARCHAR2(7) := 'PROJECT';
6: G_CUSTOMER_CODE CONSTANT VARCHAR2(8) := 'CUSTOMER';
7: G_KEY_MEMBER CONSTANT VARCHAR2(10) := 'KEY_MEMBER';
8: G_CLASS_CATEGORY_CODE CONSTANT VARCHAR2(14) := 'CLASS_CATEGORY';

Line 119: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl

115: ,p_op_validate_flag IN VARCHAR2 := 'Y' --added by rtarway 4218977
116: ,p_project_in IN project_in_rec_type
117: ,p_project_out OUT NOCOPY project_out_rec_type /*Added the nocopy check for bug 2674619*/
118: /* Added for tracking bug - add customers */
119: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl
120: /* Added Default Value for p_class_categories and p_key_members */
121: ,p_key_members IN project_role_tbl_type := G_key_members_in_tbl
122: ,p_class_categories IN class_category_tbl_type := G_class_categories_in_tbl
123: ,p_tasks_in IN task_in_tbl_type

Line 5011: IF NVL(PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED,'N') = 'Y'

5007: --maansari5/18
5008:
5009: --Set the global variable G_OP_VALIDATE_FLAG before going for dependence validation.
5010:
5011: IF NVL(PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED,'N') = 'Y'
5012: THEN
5013: l_d_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
5014: ELSE
5015: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');

Line 5167: pa_project_pub.create_mapping

5163: OR
5164: ( p_tasks_in(i).mapped_task_reference IS NOT NULL AND p_tasks_in(i).mapped_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5165: )
5166: THEN
5167: pa_project_pub.create_mapping
5168: (
5169: p_api_version => p_api_version_number
5170: , p_init_msg_list => FND_API.G_FALSE
5171: , p_commit => FND_API.G_FALSE--bug 3766967

Line 5250: Pa_Project_Pub.create_deliverable

5246: -- A call to Create_Deliverables api creates one deliverable and its
5247: -- assoicated actions.
5248:
5249: -- Invoking the Create Deliverable API
5250: Pa_Project_Pub.create_deliverable
5251: ( p_api_version => p_api_version_number
5252: , p_init_msg_list => p_init_msg_list
5253: -- 3735792, passing p_commit as false to next level api calls
5254: , p_commit => FND_API.G_FALSE

Line 5680: l_tasks_in pa_project_pub.task_in_tbl_type; --dummy variables.

5676: l_amg_task_number VARCHAR2(50);
5677:
5678: --Project Structures
5679: l_ref_task_id NUMBER;
5680: l_tasks_in pa_project_pub.task_in_tbl_type; --dummy variables.
5681: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables.
5682: --Project Structures
5683: --bug 2738747
5684: l_structure_type VARCHAR2(25);

Line 5681: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables.

5677:
5678: --Project Structures
5679: l_ref_task_id NUMBER;
5680: l_tasks_in pa_project_pub.task_in_tbl_type; --dummy variables.
5681: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables.
5682: --Project Structures
5683: --bug 2738747
5684: l_structure_type VARCHAR2(25);
5685: --bug 2738747

Line 6102: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'

6098: END IF;
6099: --bug 2876703
6100:
6101: --bug 2738747
6102: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
6103: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
6104: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
6105: AND l_str_type /*p_structure_type 3746912*/= 'FINANCIAL'
6106: THEN

Line 6103: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'

6099: --bug 2876703
6100:
6101: --bug 2738747
6102: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
6103: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
6104: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
6105: AND l_str_type /*p_structure_type 3746912*/= 'FINANCIAL'
6106: THEN
6107: --Change the flow to WORKPLAN

Line 6104: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'

6100:
6101: --bug 2738747
6102: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
6103: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
6104: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
6105: AND l_str_type /*p_structure_type 3746912*/= 'FINANCIAL'
6106: THEN
6107: --Change the flow to WORKPLAN
6108: l_structure_type := 'WORKPLAN';

Line 7080: pa_project_pub.create_mapping

7076: ( l_task_in_rec.mapped_task_reference IS NOT NULL AND l_task_in_rec.mapped_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
7077: )
7078: THEN
7079:
7080: pa_project_pub.create_mapping
7081: (
7082: p_api_version => p_api_version_number
7083: , p_init_msg_list => FND_API.G_FALSE
7084: , p_commit => FND_API.G_FALSE--bug 3766967

Line 7221: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

7217: end;
7218:
7219: -- PA L Changes 3010538
7220:
7221: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7222: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7223: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7224: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7225: THEN

Line 7222: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

7218:
7219: -- PA L Changes 3010538
7220:
7221: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7222: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7223: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7224: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7225: THEN
7226:

Line 7223: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

7219: -- PA L Changes 3010538
7220:
7221: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7222: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7223: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7224: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7225: THEN
7226:
7227: /* Starts added for Bug# 7264422 */

Line 7224: PA_PROJECT_PUB.G_Published_version_exists = 'N')

7220:
7221: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7222: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7223: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7224: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7225: THEN
7226:
7227: /* Starts added for Bug# 7264422 */
7228: IF (nvl(p_structure_updates_flag, 'Y') = 'N') THEN

Line 7314: pa_project_pub.ASSOCIATE_DLV_TO_TASK (

7310: END IF;
7311:
7312: -- 3661788 pass validated deliverable id to association api
7313:
7314: pa_project_pub.ASSOCIATE_DLV_TO_TASK (
7315: p_api_version => p_api_version_number
7316: , p_init_msg_list => p_init_msg_list
7317: -- 3735792, passing p_commit as false to next level api calls
7318: , p_commit => FND_API.G_FALSE

Line 7563: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'

7559: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
7560: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7561: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7562:
7563: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
7564: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
7565: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
7566: AND p_structure_type = 'FINANCIAL'
7567: THEN

Line 7564: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'

7560: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7561: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7562:
7563: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
7564: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
7565: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
7566: AND p_structure_type = 'FINANCIAL'
7567: THEN
7568: --Change the flow to WORKPLAN

Line 7565: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'

7561: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7562:
7563: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
7564: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
7565: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
7566: AND p_structure_type = 'FINANCIAL'
7567: THEN
7568: --Change the flow to WORKPLAN
7569: l_structure_type := 'WORKPLAN';

Line 7679: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

7675: );
7676:
7677: -- PA L Changes 3010538
7678:
7679: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7680: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7681: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7682: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7683: THEN

Line 7680: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

7676:
7677: -- PA L Changes 3010538
7678:
7679: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7680: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7681: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7682: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7683: THEN
7684:

Line 7681: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

7677: -- PA L Changes 3010538
7678:
7679: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7680: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7681: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7682: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7683: THEN
7684:
7685: -- Fetch the structure version id for the task version id.

Line 7682: PA_PROJECT_PUB.G_Published_version_exists = 'N')

7678:
7679: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
7680: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
7681: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
7682: PA_PROJECT_PUB.G_Published_version_exists = 'N')
7683: THEN
7684:
7685: -- Fetch the structure version id for the task version id.
7686:

Line 8605: -- 19-FEB-2004 Rakesh Raghavan Modifications for Bug # 3379677 to fix: PA_PROJECT_PUB.LOAD_TASK.

8601: -- 22-JAN-2004 Rakesh Raghavan - Modifications for FP-M Bug # 3301192 to add parameters: predecessor_task_reference_id,
8602: -- dependency_type and lag days to tasks and create dependencies.
8603: -- 10-FEB-2004 Rakesh Raghavan - Modifications for FP-M Bug # 3301192 to replace parameters: predecessor_task_reference_id,
8604: -- dependency_type and lag days with parameters: pred_string and pred_delimiter.
8605: -- 19-FEB-2004 Rakesh Raghavan Modifications for Bug # 3379677 to fix: PA_PROJECT_PUB.LOAD_TASK.
8606: -- 05-APR-2004 Rakesh Raghavan Progress Management Changes. Bug # 3420093.
8607:
8608: PROCEDURE load_task
8609: ( p_api_version_number IN NUMBER

Line 8809: -- Modifications for Bug # 3379677 to fix: PA_PROJECT_PUB.LOAD_TASK.

8805:
8806: -- assign incoming parameters to the global table fields
8807: --!!not needed G_tasks_in_tbl(G_tasks_tbl_count).pm_project_reference := p_pm_project_reference;
8808: G_tasks_in_tbl(G_tasks_tbl_count).pm_task_reference := p_pm_task_reference;
8809: -- Modifications for Bug # 3379677 to fix: PA_PROJECT_PUB.LOAD_TASK.
8810: G_tasks_in_tbl(G_tasks_tbl_count).task_name := substrb(p_task_name,1,240); --Bug 6193314
8811: --bug 2874207
8812: /* Commented the code for bug 2982057 and handling it in create_project and update_project
8813: IF p_long_task_name IS NULL OR p_long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 8826: -- Modifications for Bug # 3379677 to fix: PA_PROJECT_PUB.LOAD_TASK

8822: G_tasks_in_tbl(G_tasks_tbl_count).long_task_name := p_long_task_name;
8823:
8824: -- END IF;
8825: --bug 2874207
8826: -- Modifications for Bug # 3379677 to fix: PA_PROJECT_PUB.LOAD_TASK
8827:
8828: G_tasks_in_tbl(G_tasks_tbl_count).pa_task_number := substrb(p_pa_task_number,1,100); --Bug 6193314
8829:
8830:

Line 9525: ,p_project_in IN pa_project_pub.project_in_rec_type

9521: ,p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
9522: ,p_workflow_started OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
9523: ,p_pm_product_code IN VARCHAR2
9524: ,p_op_validate_flag IN varchar2 := 'Y'
9525: ,p_project_in IN pa_project_pub.project_in_rec_type
9526: ,p_project_out OUT NOCOPY pa_project_pub.project_out_rec_type /*added the nocopy check for the 2674619*/
9527: /* Added for tracking bug - add customers */
9528: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl
9529: /* Added Default Value for p_key_members and p_class_categories*/

Line 9526: ,p_project_out OUT NOCOPY pa_project_pub.project_out_rec_type /added the nocopy check for the 2674619/

9522: ,p_workflow_started OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
9523: ,p_pm_product_code IN VARCHAR2
9524: ,p_op_validate_flag IN varchar2 := 'Y'
9525: ,p_project_in IN pa_project_pub.project_in_rec_type
9526: ,p_project_out OUT NOCOPY pa_project_pub.project_out_rec_type /*added the nocopy check for the 2674619*/
9527: /* Added for tracking bug - add customers */
9528: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl
9529: /* Added Default Value for p_key_members and p_class_categories*/
9530: ,p_key_members IN pa_project_pub.project_role_tbl_type := G_key_members_in_tbl

Line 9528: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl

9524: ,p_op_validate_flag IN varchar2 := 'Y'
9525: ,p_project_in IN pa_project_pub.project_in_rec_type
9526: ,p_project_out OUT NOCOPY pa_project_pub.project_out_rec_type /*added the nocopy check for the 2674619*/
9527: /* Added for tracking bug - add customers */
9528: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl
9529: /* Added Default Value for p_key_members and p_class_categories*/
9530: ,p_key_members IN pa_project_pub.project_role_tbl_type := G_key_members_in_tbl
9531: ,p_class_categories IN pa_project_pub.class_category_tbl_type := G_class_categories_in_tbl
9532: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

Line 9530: ,p_key_members IN pa_project_pub.project_role_tbl_type := G_key_members_in_tbl

9526: ,p_project_out OUT NOCOPY pa_project_pub.project_out_rec_type /*added the nocopy check for the 2674619*/
9527: /* Added for tracking bug - add customers */
9528: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl
9529: /* Added Default Value for p_key_members and p_class_categories*/
9530: ,p_key_members IN pa_project_pub.project_role_tbl_type := G_key_members_in_tbl
9531: ,p_class_categories IN pa_project_pub.class_category_tbl_type := G_class_categories_in_tbl
9532: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
9533: ,p_tasks_out OUT NOCOPY pa_project_pub.task_out_tbl_type /*added the nocopy check for the bug 2674619*/
9534: -- anlee org role changes

Line 9531: ,p_class_categories IN pa_project_pub.class_category_tbl_type := G_class_categories_in_tbl

9527: /* Added for tracking bug - add customers */
9528: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl
9529: /* Added Default Value for p_key_members and p_class_categories*/
9530: ,p_key_members IN pa_project_pub.project_role_tbl_type := G_key_members_in_tbl
9531: ,p_class_categories IN pa_project_pub.class_category_tbl_type := G_class_categories_in_tbl
9532: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
9533: ,p_tasks_out OUT NOCOPY pa_project_pub.task_out_tbl_type /*added the nocopy check for the bug 2674619*/
9534: -- anlee org role changes
9535: ,p_org_roles IN pa_project_pub.project_role_tbl_type := G_org_roles_in_tbl

Line 9532: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

9528: ,p_customers_in IN pa_project_pub.customer_tbl_type := G_customers_in_tbl
9529: /* Added Default Value for p_key_members and p_class_categories*/
9530: ,p_key_members IN pa_project_pub.project_role_tbl_type := G_key_members_in_tbl
9531: ,p_class_categories IN pa_project_pub.class_category_tbl_type := G_class_categories_in_tbl
9532: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
9533: ,p_tasks_out OUT NOCOPY pa_project_pub.task_out_tbl_type /*added the nocopy check for the bug 2674619*/
9534: -- anlee org role changes
9535: ,p_org_roles IN pa_project_pub.project_role_tbl_type := G_org_roles_in_tbl
9536: --project structures

Line 9533: ,p_tasks_out OUT NOCOPY pa_project_pub.task_out_tbl_type /added the nocopy check for the bug 2674619/

9529: /* Added Default Value for p_key_members and p_class_categories*/
9530: ,p_key_members IN pa_project_pub.project_role_tbl_type := G_key_members_in_tbl
9531: ,p_class_categories IN pa_project_pub.class_category_tbl_type := G_class_categories_in_tbl
9532: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
9533: ,p_tasks_out OUT NOCOPY pa_project_pub.task_out_tbl_type /*added the nocopy check for the bug 2674619*/
9534: -- anlee org role changes
9535: ,p_org_roles IN pa_project_pub.project_role_tbl_type := G_org_roles_in_tbl
9536: --project structures
9537: ,p_structure_in IN structure_in_rec_type := G_structure_in_rec

Line 9535: ,p_org_roles IN pa_project_pub.project_role_tbl_type := G_org_roles_in_tbl

9531: ,p_class_categories IN pa_project_pub.class_category_tbl_type := G_class_categories_in_tbl
9532: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
9533: ,p_tasks_out OUT NOCOPY pa_project_pub.task_out_tbl_type /*added the nocopy check for the bug 2674619*/
9534: -- anlee org role changes
9535: ,p_org_roles IN pa_project_pub.project_role_tbl_type := G_org_roles_in_tbl
9536: --project structures
9537: ,p_structure_in IN structure_in_rec_type := G_structure_in_rec
9538: ,p_ext_attr_tbl_in IN PA_EXT_ATTR_TABLE_TYPE := G_ext_attr_in_tbl
9539: -- ,p_structure_out OUT structure_out_rec_type

Line 9893: l_project_in_rec pa_project_pub.project_in_rec_type;

9889: l_status_code PA_PROJECT_STATUSES.project_system_status_code%TYPE; -- Bug 3611598
9890: l_deferred_tasks_index_tbl deferred_tasks_tbl_typ;
9891:
9892: l_project_rec pa_projects%ROWTYPE;
9893: l_project_in_rec pa_project_pub.project_in_rec_type;
9894: l_temp_org_id NUMBER;
9895: l_temp VARCHAR2(1);
9896:
9897: l_api_name CONSTANT VARCHAR2(30):= 'update_project';

Line 9901: l_tasks_out pa_project_pub.task_out_tbl_type;

9897: l_api_name CONSTANT VARCHAR2(30):= 'update_project';
9898: j NUMBER;
9899: i NUMBER;
9900:
9901: l_tasks_out pa_project_pub.task_out_tbl_type;
9902: l_return_status VARCHAR2(1);
9903:
9904: l_err_code NUMBER := 0;
9905: l_err_stage VARCHAR2(2000);

Line 9920: l_deferred_new_tasks_tbl pa_project_pub.task_in_tbl_type;

9916: l_project_completion_date DATE;
9917: l_max_task_date DATE;
9918: l_min_task_date DATE;
9919:
9920: l_deferred_new_tasks_tbl pa_project_pub.task_in_tbl_type;
9921: l_deferred_tasks_count NUMBER := 0;
9922: l_added_task_tbl pa_project_pub.task_in_tbl_type;
9923: l_task_id_tbl pa_project_pub.task_out_tbl_type;
9924: l_count NUMBER;

Line 9922: l_added_task_tbl pa_project_pub.task_in_tbl_type;

9918: l_min_task_date DATE;
9919:
9920: l_deferred_new_tasks_tbl pa_project_pub.task_in_tbl_type;
9921: l_deferred_tasks_count NUMBER := 0;
9922: l_added_task_tbl pa_project_pub.task_in_tbl_type;
9923: l_task_id_tbl pa_project_pub.task_out_tbl_type;
9924: l_count NUMBER;
9925: l_task_rec pa_project_pub.task_in_rec_type;
9926: l_project_type_class_code pa_project_types.project_type_class_code%type;

Line 9923: l_task_id_tbl pa_project_pub.task_out_tbl_type;

9919:
9920: l_deferred_new_tasks_tbl pa_project_pub.task_in_tbl_type;
9921: l_deferred_tasks_count NUMBER := 0;
9922: l_added_task_tbl pa_project_pub.task_in_tbl_type;
9923: l_task_id_tbl pa_project_pub.task_out_tbl_type;
9924: l_count NUMBER;
9925: l_task_rec pa_project_pub.task_in_rec_type;
9926: l_project_type_class_code pa_project_types.project_type_class_code%type;
9927: l_service_type_code pa_project_types.service_type_code%type;

Line 9925: l_task_rec pa_project_pub.task_in_rec_type;

9921: l_deferred_tasks_count NUMBER := 0;
9922: l_added_task_tbl pa_project_pub.task_in_tbl_type;
9923: l_task_id_tbl pa_project_pub.task_out_tbl_type;
9924: l_count NUMBER;
9925: l_task_rec pa_project_pub.task_in_rec_type;
9926: l_project_type_class_code pa_project_types.project_type_class_code%type;
9927: l_service_type_code pa_project_types.service_type_code%type;
9928:
9929: l_key_members_tbl pa_project_pub.project_role_tbl_type;

Line 9929: l_key_members_tbl pa_project_pub.project_role_tbl_type;

9925: l_task_rec pa_project_pub.task_in_rec_type;
9926: l_project_type_class_code pa_project_types.project_type_class_code%type;
9927: l_service_type_code pa_project_types.service_type_code%type;
9928:
9929: l_key_members_tbl pa_project_pub.project_role_tbl_type;
9930: l_key_members_in_rec pa_project_pub.project_role_rec_type;
9931: l_key_members_current_rec l_key_member_csr%ROWTYPE;
9932: l_key_members_rec l_key_member_csr%ROWTYPE;
9933: l_project_man_current_rec l_project_man_current_csr%ROWTYPE;

Line 9930: l_key_members_in_rec pa_project_pub.project_role_rec_type;

9926: l_project_type_class_code pa_project_types.project_type_class_code%type;
9927: l_service_type_code pa_project_types.service_type_code%type;
9928:
9929: l_key_members_tbl pa_project_pub.project_role_tbl_type;
9930: l_key_members_in_rec pa_project_pub.project_role_rec_type;
9931: l_key_members_current_rec l_key_member_csr%ROWTYPE;
9932: l_key_members_rec l_key_member_csr%ROWTYPE;
9933: l_project_man_current_rec l_project_man_current_csr%ROWTYPE;
9934:

Line 9959: l_org_roles_tbl pa_project_pub.project_role_tbl_type;

9955: /*CAR changes ends*/
9956:
9957:
9958: -- anlee org role changes
9959: l_org_roles_tbl pa_project_pub.project_role_tbl_type;
9960: l_org_roles_in_rec pa_project_pub.project_role_rec_type;
9961: l_org_roles_current_rec l_org_role_csr%ROWTYPE;
9962: l_org_roles_rec l_org_role_csr%ROWTYPE;
9963:

Line 9960: l_org_roles_in_rec pa_project_pub.project_role_rec_type;

9956:
9957:
9958: -- anlee org role changes
9959: l_org_roles_tbl pa_project_pub.project_role_tbl_type;
9960: l_org_roles_in_rec pa_project_pub.project_role_rec_type;
9961: l_org_roles_current_rec l_org_role_csr%ROWTYPE;
9962: l_org_roles_rec l_org_role_csr%ROWTYPE;
9963:
9964: l_class_categories_tbl pa_project_pub.class_category_tbl_type ;

Line 9964: l_class_categories_tbl pa_project_pub.class_category_tbl_type ;

9960: l_org_roles_in_rec pa_project_pub.project_role_rec_type;
9961: l_org_roles_current_rec l_org_role_csr%ROWTYPE;
9962: l_org_roles_rec l_org_role_csr%ROWTYPE;
9963:
9964: l_class_categories_tbl pa_project_pub.class_category_tbl_type ;
9965: l_temp_start_date DATE;
9966: l_temp_end_date DATE;
9967: l_update_yes_flag VARCHAR2(1) := 'N';
9968: l_out_pa_task_id NUMBER;

Line 11171: ----dbms_output.put_line('PA_PROJECT_PUB.G_Published_version_exists'||PA_PROJECT_PUB.G_Published_version_exists);

11167: -- << End >>
11168: -- "Change Project Currency" changes By avaithia
11169:
11170: --bug 2738747
11171: ----dbms_output.put_line('PA_PROJECT_PUB.G_Published_version_exists'||PA_PROJECT_PUB.G_Published_version_exists);
11172: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN'||PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN);
11173: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED'||PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED);
11174: ----dbms_output.put_line('p_structure_in.structure_type'||p_structure_in.structure_type);
11175: ----dbms_output.put_line('p_pm_product_code'||p_pm_product_code);

Line 11172: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN'||PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN);

11168: -- "Change Project Currency" changes By avaithia
11169:
11170: --bug 2738747
11171: ----dbms_output.put_line('PA_PROJECT_PUB.G_Published_version_exists'||PA_PROJECT_PUB.G_Published_version_exists);
11172: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN'||PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN);
11173: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED'||PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED);
11174: ----dbms_output.put_line('p_structure_in.structure_type'||p_structure_in.structure_type);
11175: ----dbms_output.put_line('p_pm_product_code'||p_pm_product_code);
11176: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'

Line 11173: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED'||PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED);

11169:
11170: --bug 2738747
11171: ----dbms_output.put_line('PA_PROJECT_PUB.G_Published_version_exists'||PA_PROJECT_PUB.G_Published_version_exists);
11172: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN'||PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN);
11173: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED'||PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED);
11174: ----dbms_output.put_line('p_structure_in.structure_type'||p_structure_in.structure_type);
11175: ----dbms_output.put_line('p_pm_product_code'||p_pm_product_code);
11176: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
11177: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'

Line 11176: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'

11172: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN'||PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN);
11173: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED'||PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED);
11174: ----dbms_output.put_line('p_structure_in.structure_type'||p_structure_in.structure_type);
11175: ----dbms_output.put_line('p_pm_product_code'||p_pm_product_code);
11176: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
11177: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
11178: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
11179: AND p_structure_in.structure_type = 'FINANCIAL'
11180: AND p_pm_product_code <> 'WORKPLAN' --This parameter should be checked bcoz for publishing we want it to syn up with pa_tasks . For publishing p_pm_product_code will have 'WORKPLAN'

Line 11177: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'

11173: ----dbms_output.put_line('PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED'||PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED);
11174: ----dbms_output.put_line('p_structure_in.structure_type'||p_structure_in.structure_type);
11175: ----dbms_output.put_line('p_pm_product_code'||p_pm_product_code);
11176: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
11177: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
11178: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
11179: AND p_structure_in.structure_type = 'FINANCIAL'
11180: AND p_pm_product_code <> 'WORKPLAN' --This parameter should be checked bcoz for publishing we want it to syn up with pa_tasks . For publishing p_pm_product_code will have 'WORKPLAN'
11181: THEN

Line 11178: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'

11174: ----dbms_output.put_line('p_structure_in.structure_type'||p_structure_in.structure_type);
11175: ----dbms_output.put_line('p_pm_product_code'||p_pm_product_code);
11176: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
11177: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
11178: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'
11179: AND p_structure_in.structure_type = 'FINANCIAL'
11180: AND p_pm_product_code <> 'WORKPLAN' --This parameter should be checked bcoz for publishing we want it to syn up with pa_tasks . For publishing p_pm_product_code will have 'WORKPLAN'
11181: THEN
11182: --Change the flow to WORKPLAN

Line 15196: PA_PROJECT_PUB.SETUP_PROJECT_AS_PROGRAM(

15192: pa_debug.write(l_module_name,'p_project_in.sys_program_flag='||p_project_in.sys_program_flag,3);
15193: pa_debug.write(l_module_name,'p_project_in.allow_multi_program_rollup='||p_project_in.allow_multi_program_rollup,3);
15194: END IF;
15195:
15196: PA_PROJECT_PUB.SETUP_PROJECT_AS_PROGRAM(
15197: p_api_version => p_api_version_number
15198: , p_init_msg_list => p_init_msg_list
15199: , p_commit => p_commit
15200: , p_max_msg_count => p_msg_count

Line 17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

17604:
17605: -- Changes start for Bug# 3931805
17606: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17607: THEN -- publishing flow.
17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

Line 17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

17605: -- Changes start for Bug# 3931805
17606: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17607: THEN -- publishing flow.
17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

Line 17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

17606: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17607: THEN -- publishing flow.
17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17615: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17616: THEN

Line 17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17615: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17616: THEN
17617: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);

Line 17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17615: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17616: THEN
17617: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
17618: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id

Line 17615: PA_PROJECT_PUB.G_Published_version_exists = 'N')

17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17615: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17616: THEN
17617: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
17618: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
17619: ,p_structure_version_id => l_structure_version_id ) ;

Line 18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

18121: IF l_structure_type = 'FINANCIAL'
18122: THEN
18123: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18124: THEN -- publishing flow.
18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

Line 18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

18122: THEN
18123: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18124: THEN -- publishing flow.
18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

Line 18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

18123: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18124: THEN -- publishing flow.
18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18132: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18133: THEN

Line 18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18132: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18133: THEN
18134: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);

Line 18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18132: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18133: THEN
18134: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18135: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id

Line 18132: PA_PROJECT_PUB.G_Published_version_exists = 'N')

18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18132: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18133: THEN
18134: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18135: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18136: ,p_structure_version_id => l_structure_version_id ) ;

Line 21455: pa_project_pub.update_mapping

21451: OR
21452: (l_task_in_rec.mapped_task_id IS NULL OR l_task_in_rec.mapped_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
21453: )
21454: THEN
21455: pa_project_pub.update_mapping
21456: (
21457: p_api_version => p_api_version_number
21458: , p_init_msg_list => FND_API.G_FALSE
21459: , p_commit => FND_API.G_FALSE--bug 3766967

Line 21662: Pa_Project_Pub.create_deliverable

21658:
21659: IF (l_dlvr_dml_action = G_CREATE_MODE) THEN
21660:
21661: -- Invoking the Create Deliverable API
21662: Pa_Project_Pub.create_deliverable
21663: (
21664: p_api_version => p_api_version_number
21665: , p_init_msg_list => p_init_msg_list
21666: -- 3735792, passing p_commit as false to next level api calls

Line 22466: l_tasks_out pa_project_pub.task_out_tbl_type; --bug 4199694

22462:
22463: --BUG 4106154, rtarway
22464: l_update_pa_tasks VARCHAR2(1);
22465:
22466: l_tasks_out pa_project_pub.task_out_tbl_type; --bug 4199694
22467:
22468: --BUG 4081329, rtarway
22469: cursor cur_get_child_task_dates (l_project_id NUMBER, l_task_id NUMBER)
22470: IS select task_id, start_date, completion_date, parent_task_id from pa_tasks --Fix for 7427388

Line 23792: pa_project_pub.update_mapping

23788: OR
23789: ( p_mapped_task_id IS NULL OR p_mapped_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
23790: )
23791: THEN
23792: pa_project_pub.update_mapping
23793: (
23794: p_api_version => p_api_version_number
23795: , p_init_msg_list => p_init_msg_list
23796: , p_commit => FND_API.G_FALSE--bug 3766967

Line 23893: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457

23889: END IF;
23890: ---bug 4199694
23891:
23892: -- These globals have been intialized before they are used!
23893: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457
23894: /* Commented the code below for bug#3451073
23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
23896: /* Added the If condition Bug#3451073 */
23897: IF p_is_wp_seperate_from_fn = 'X'

Line 23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */

23891:
23892: -- These globals have been intialized before they are used!
23893: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457
23894: /* Commented the code below for bug#3451073
23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
23896: /* Added the If condition Bug#3451073 */
23897: IF p_is_wp_seperate_from_fn = 'X'
23898: THEN
23899: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457

Line 23899: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457

23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
23896: /* Added the If condition Bug#3451073 */
23897: IF p_is_wp_seperate_from_fn = 'X'
23898: THEN
23899: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457
23900: ELSE
23901: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073
23902: END IF;
23903:

Line 23901: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073

23897: IF p_is_wp_seperate_from_fn = 'X'
23898: THEN
23899: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457
23900: ELSE
23901: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073
23902: END IF;
23903:
23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457
23905:

Line 23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457

23900: ELSE
23901: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073
23902: END IF;
23903:
23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457
23905:
23906: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
23907: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 23906: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

23902: END IF;
23903:
23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457
23905:
23906: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
23907: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
23909: PA_PROJECT_PUB.G_Published_version_exists = 'N')
23910: THEN

Line 23907: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

23903:
23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457
23905:
23906: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
23907: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
23909: PA_PROJECT_PUB.G_Published_version_exists = 'N')
23910: THEN
23911:

Line 23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457
23905:
23906: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
23907: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
23909: PA_PROJECT_PUB.G_Published_version_exists = 'N')
23910: THEN
23911:
23912: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- Bug 3106457 p_pa_project_id

Line 23909: PA_PROJECT_PUB.G_Published_version_exists = 'N')

23905:
23906: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
23907: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
23909: PA_PROJECT_PUB.G_Published_version_exists = 'N')
23910: THEN
23911:
23912: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- Bug 3106457 p_pa_project_id
23913: ,p_structure_version_id => l_structure_version_id ) ; -- Bug 3106457

Line 26799: PA_PROJECT_PUB.load_task (

26795:
26796: -- Progress Management Changes. Bug # 3420093.
26797:
26798:
26799: PA_PROJECT_PUB.load_task (
26800: p_api_version_number => G_API_VERSION_NUMBER
26801: ,p_init_msg_list => p_init_msg_list
26802: ,p_return_status => l_return_status
26803: ,p_pm_task_reference => p_pm_task_reference(i)

Line 27086: P_TRANSACTION_TYPE IN VARCHAR2 := PA_PROJECT_PUB.G_SYNC_MODE,

27082: PROCEDURE load_extensible_attribute(P_API_VERSION_NUMBER IN NUMBER := 1.0,
27083: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
27084: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
27085: X_RETURN_STATUS OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
27086: P_TRANSACTION_TYPE IN VARCHAR2 := PA_PROJECT_PUB.G_SYNC_MODE,
27087: P_TASK_ID IN NUMBER := NULL,
27088: P_TASK_REFERENCE IN VARCHAR2 := NULL,
27089: P_ATTR_GRP_INTERNAL_NAME IN VARCHAR2 := NULL,
27090: P_ATTR_GRP_ID IN NUMBER := NULL,

Line 27189: P_TRANSACTION_TYPE IN PA_VC_1000_10 := PA_VC_1000_10(PA_PROJECT_PUB.G_SYNC_MODE),

27185: PROCEDURE load_extensible_attributes(P_API_VERSION_NUMBER IN NUMBER,
27186: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
27187: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
27188: X_RETURN_STATUS OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
27189: P_TRANSACTION_TYPE IN PA_VC_1000_10 := PA_VC_1000_10(PA_PROJECT_PUB.G_SYNC_MODE),
27190: P_TASK_ID IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(NULL),
27191: P_TASK_REFERENCE IN PA_VC_1000_150 := PA_VC_1000_150(NULL),
27192: P_ATTR_GRP_INTERNAL_NAME IN PA_VC_1000_30 := PA_VC_1000_30(NULL),
27193: P_ATTR_GRP_ID IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(NULL),

Line 27217: l_transaction_type_flag BOOLEAN := (P_TRANSACTION_TYPE.count = 1 and P_TRANSACTION_TYPE(1) = PA_PROJECT_PUB.G_SYNC_MODE);

27213: l_attr_value_num_flag BOOLEAN := (P_ATTR_VALUE_NUM.count = 1 and P_ATTR_VALUE_NUM(1) = NULL);
27214: l_attr_value_date_flag BOOLEAN := (P_ATTR_VALUE_DATE.count = 1 and P_ATTR_VALUE_DATE(1) = NULL);
27215: l_attr_disp_value_flag BOOLEAN := (P_ATTR_DISP_VALUE.count = 1 and P_ATTR_DISP_VALUE(1) = NULL);
27216: l_attr_unit_of_measure_flag BOOLEAN := (P_ATTR_VALUE_NUM_UOM.count = 1 and P_ATTR_VALUE_NUM_UOM(1) = NULL);
27217: l_transaction_type_flag BOOLEAN := (P_TRANSACTION_TYPE.count = 1 and P_TRANSACTION_TYPE(1) = PA_PROJECT_PUB.G_SYNC_MODE);
27218:
27219: l_proj_element_id NUMBER;
27220: l_proj_element_reference VARCHAR2(30);
27221: l_attr_group_int_name VARCHAR2(30);

Line 27323: l_transaction_type := PA_PROJECT_PUB.G_SYNC_MODE;

27319:
27320: if (l_transaction_type_flag <> TRUE) then
27321: l_transaction_type := P_TRANSACTION_TYPE(i);
27322: else
27323: l_transaction_type := PA_PROJECT_PUB.G_SYNC_MODE;
27324: end if;
27325:
27326: -- call unit api
27327: load_extensible_attribute

Line 27589: -- IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

27585: END IF;
27586:
27587: -- PA L Changes 3010538
27588: --Commenting as for a publishing case we need to always check for update wbs required flag
27589: -- IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
27590: -- ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
27591: -- PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
27592: -- PA_PROJECT_PUB.G_Published_version_exists = 'N')
27593: -- THEN

Line 27590: -- ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

27586:
27587: -- PA L Changes 3010538
27588: --Commenting as for a publishing case we need to always check for update wbs required flag
27589: -- IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
27590: -- ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
27591: -- PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
27592: -- PA_PROJECT_PUB.G_Published_version_exists = 'N')
27593: -- THEN
27594:

Line 27591: -- PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

27587: -- PA L Changes 3010538
27588: --Commenting as for a publishing case we need to always check for update wbs required flag
27589: -- IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
27590: -- ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
27591: -- PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
27592: -- PA_PROJECT_PUB.G_Published_version_exists = 'N')
27593: -- THEN
27594:
27595: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_pa_project_id

Line 27592: -- PA_PROJECT_PUB.G_Published_version_exists = 'N')

27588: --Commenting as for a publishing case we need to always check for update wbs required flag
27589: -- IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
27590: -- ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
27591: -- PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
27592: -- PA_PROJECT_PUB.G_Published_version_exists = 'N')
27593: -- THEN
27594:
27595: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_pa_project_id
27596: ,p_structure_version_id => p_published_struct_ver_id ) ;

Line 30668: ---- --dbms_output.put_line('entering pa_project_pub.Update_deliverable['||p_project_id||']['||p_task_id||']');

30664: -- Initialize the message table if requested.
30665: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
30666: FND_MSG_PUB.initialize;
30667: END IF;
30668: ---- --dbms_output.put_line('entering pa_project_pub.Update_deliverable['||p_project_id||']['||p_task_id||']');
30669:
30670: -- 3735792, setting save point unconditionally
30671: --IF (p_commit = FND_API.G_TRUE) THEN
30672: savepoint UPDATE_DELIVERABLE_PUB;

Line 35310: This is happening due to value 'M' being returned from the PA_PROJECT_PUB.check_task_mfd APIs OUT param p_check_task_mfd_flag.

35306: present in the published versions should be deleted right away and the MSP should not show any message.
35307:
35308: Analysis:
35309:
35310: This is happening due to value 'M' being returned from the PA_PROJECT_PUB.check_task_mfd APIs OUT param p_check_task_mfd_flag.
35311: The reason is due to the bug in the cursor l_amg_task_csr.
35312: This SQL is starting with an element id i.e the task id and getting the parent sturcture id and looking for that parent
35313: structure id's published status in other tables.
35314:

Line 35474: -- pa_project_pub.Check_Delete_Task_OK

35470: , x_structure_version_id => l_structure_version_id
35471: , x_task_version_id => l_task_version_id);
35472: --------------------------------------------------------------------------------------------------------------------------------
35473: -- If p_perform_check_delete_task_ok is "Y" , then we need to call the API
35474: -- pa_project_pub.Check_Delete_Task_OK
35475:
35476: IF p_perform_check_delete_task_ok ='Y' THEN
35477: pa_project_pub.Check_Delete_Task_OK
35478: (

Line 35477: pa_project_pub.Check_Delete_Task_OK

35473: -- If p_perform_check_delete_task_ok is "Y" , then we need to call the API
35474: -- pa_project_pub.Check_Delete_Task_OK
35475:
35476: IF p_perform_check_delete_task_ok ='Y' THEN
35477: pa_project_pub.Check_Delete_Task_OK
35478: (
35479: p_api_version_number => p_api_version_number
35480: -- Start OUT params
35481: , p_return_status => l_return_status

Line 35673: -- We set the value for out param x_deleted_task_ver_ids in the global VARRAY PA_PROJECT_PUB.G_DELETED_TASK_IDS_FROM_OP

35669: -- This API is supposed to be calling only in AMG/MSP context.
35670: --
35671: -- This is not a standalone API .This API will produce useful output only if its called after WP publishing flow
35672: --
35673: -- We set the value for out param x_deleted_task_ver_ids in the global VARRAY PA_PROJECT_PUB.G_DELETED_TASK_IDS_FROM_OP
35674: -- in the Publish_Structure API (PAXSTCVB.pls) ONLY if p_calling_module in that API is 'AMG'
35675:
35676: PROCEDURE get_deleted_tasks_from_op
35677: (

Line 35688: x_deleted_task_ids := PA_PROJECT_PUB.G_DELETED_TASK_IDS_FROM_OP;

35684: BEGIN
35685: x_msg_count := 0;
35686: x_return_status := FND_API.G_RET_STS_SUCCESS;
35687: x_msg_data := NULL;
35688: x_deleted_task_ids := PA_PROJECT_PUB.G_DELETED_TASK_IDS_FROM_OP;
35689: EXCEPTION
35690: WHEN OTHERS THEN
35691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
35692: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 36064: PA_PROJECT_PUB.process_structure_updates

36060: and NVL(ppes.process_code,'WUE') = 'WUE'
36061: and ppes.pev_structure_id = i.pev_structure_id;
36062:
36063: if nvl(l_exists,'Y') = 'X' Then
36064: PA_PROJECT_PUB.process_structure_updates
36065: ( p_api_version_number => 1.0
36066: , p_init_msg_list => FND_API.G_TRUE
36067: , p_commit => FND_API.G_FALSE
36068: , p_return_status => l_return_status

Line 36364: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE

36360: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
36361: , p_commit IN VARCHAR2 := FND_API.G_FALSE
36362: , p_debug_mode IN VARCHAR2 := 'N'
36363: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36364: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE
36365: , x_return_status OUT NOCOPY VARCHAR2
36366: , x_msg_count OUT NOCOPY NUMBER
36367: , x_msg_data OUT NOCOPY VARCHAR2)
36368: is

Line 36942: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE

36938: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
36939: , p_commit IN VARCHAR2 := FND_API.G_FALSE
36940: , p_debug_mode IN VARCHAR2 := 'N'
36941: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36942: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE
36943: , x_return_status OUT NOCOPY VARCHAR2
36944: , x_msg_count OUT NOCOPY NUMBER
36945: , x_msg_data OUT NOCOPY VARCHAR2)
36946: is

Line 38047: end PA_PROJECT_PUB;

38043: END UPDATE_FINANCIAL_ATTRIBUTES;
38044: --End of fix for Bug 7525628
38045:
38046:
38047: end PA_PROJECT_PUB;