DBA Data[Home] [Help]

APPS.PA_PROJECT_CHECK_PVT dependencies on PA_PROJECT_PUB

Line 141: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all API in the flow. MSP calls the PA_PROJECT_PUB.check_task_mfd API

137:
138: Analysis:
139:
140: This error was also coming up from the Convert_pm_taskref_to_id_all API. There was a call to the
141: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all API in the flow. MSP calls the PA_PROJECT_PUB.check_task_mfd API
142: to determine whether a task can be deleted at all or not. This in turn calls the pa_project_pub.Check_Delete_Task_OK
143: API and that in turn calls the pa_project_check_pvt.Check_Delete_Task_OK_pvt API.
144: In this API the call to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all the structure type is also passed as shown below.
145: As the structure type 'FINANCIAL' was passed the Convert_pm_taskref_to_id_all API was looking for the task in the

Line 142: to determine whether a task can be deleted at all or not. This in turn calls the pa_project_pub.Check_Delete_Task_OK

138: Analysis:
139:
140: This error was also coming up from the Convert_pm_taskref_to_id_all API. There was a call to the
141: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all API in the flow. MSP calls the PA_PROJECT_PUB.check_task_mfd API
142: to determine whether a task can be deleted at all or not. This in turn calls the pa_project_pub.Check_Delete_Task_OK
143: API and that in turn calls the pa_project_check_pvt.Check_Delete_Task_OK_pvt API.
144: In this API the call to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all the structure type is also passed as shown below.
145: As the structure type 'FINANCIAL' was passed the Convert_pm_taskref_to_id_all API was looking for the task in the
146: PA_TASKS table in the cursor l_task_id_csr. As this was not returning any rows the above error is thrown. The task

Line 148: Ideally we should pass 'WORKPLAN' as the structure type. This is being done in the PA_PROJECT_PUB.DELETE_TASK API.

144: In this API the call to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all the structure type is also passed as shown below.
145: As the structure type 'FINANCIAL' was passed the Convert_pm_taskref_to_id_all API was looking for the task in the
146: PA_TASKS table in the cursor l_task_id_csr. As this was not returning any rows the above error is thrown. The task
147: is there but due to the structure type 'WORKPLAN' it is residing in the elements tables as it is not yet published as well.
148: Ideally we should pass 'WORKPLAN' as the structure type. This is being done in the PA_PROJECT_PUB.DELETE_TASK API.
149: -- If the following criteria is satisfied,
150: -- switch flow to WORKPLAN
151: -- i) Workplan is enabled;
152: -- ii) Structure is SHARED;

Line 1994: p_in_task_rec IN pa_project_pub.task_in_rec_type,

1990: --
1991: PROCEDURE Validate_billing_info_Pvt
1992: (p_project_id IN NUMBER, --Added for Bug 5643876
1993: p_project_class_code IN VARCHAR2,
1994: p_in_task_rec IN pa_project_pub.task_in_rec_type,
1995: p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1996: ) IS
1997: --Added for Bug 5643876
1998: l_project_id pa_projects_all.project_id%type;

Line 2110: l_task_rec pa_project_pub.task_in_rec_type;

2106: AND irs.project_id IS NULL
2107: AND TRUNC(SYSDATE) BETWEEN TRUNC(irs.start_date_active )
2108: AND NVL (irs.end_date_active,TRUNC(SYSDATE)) ;
2109:
2110: l_task_rec pa_project_pub.task_in_rec_type;
2111: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Billing_Info_Pvt';
2112: l_dummy VARCHAR2(1);
2113: l_amg_segment1 VARCHAR2(25);
2114: l_amg_task_number VARCHAR2(50);

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

2899: --
2900: --
2901: --History:
2902: -- 31-JUL-1996 R. Krishnamurthy Created
2903: -- 03-DEC-1996 L. de Werker Moved from pa_project_pub to pa_project_pvt
2904: -- 12-JUL-2000 Mohnish
2905: -- added code for ROLE BASED SECURITY:
2906: -- added the call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY
2907: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes

Line 2912: ,p_key_members IN pa_project_pub.project_role_tbl_type

2908: --
2909: PROCEDURE check_for_one_manager_Pvt
2910: (p_project_id IN NUMBER
2911: ,p_person_id IN NUMBER
2912: ,p_key_members IN pa_project_pub.project_role_tbl_type
2913: ,p_start_date IN DATE
2914: ,p_end_date IN DATE
2915: ,p_return_status OUT NOCOPY VARCHAR2 ) /*Added the nocopy check for 4537865 */
2916: IS

Line 3244: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,

3240: (p_project_id IN NUMBER,
3241: p_task_id IN NUMBER,
3242: p_array_cell_number IN NUMBER,
3243: p_in_task_number IN VARCHAR2,
3244: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,
3245: p_proceed_with_update_flag OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
3246: p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
3247: ) IS
3248:

Line 3680: /* This is a wrapper API which is called from the AMG API pa_project_pub to

3676: -- History
3677: --
3678: -- 16-Feb-2005 pkanupar created for bug #2111806
3679:
3680: /* This is a wrapper API which is called from the AMG API pa_project_pub to
3681: check the Manager date range on a Project */
3682:
3683: Procedure check_manager_date_range
3684: (p_project_id IN NUMBER,