1 PACKAGE PA_TASK_ASSIGNMENTS_PVT AUTHID CURRENT_USER AS
2 -- $Header: PATAPVTS.pls 120.1.12020000.3 2013/03/07 02:11:04 sachandr ship $
3
4
5
6 --Internal Utiilities to convert PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM to fnd_api.g_miss_xxx
7 FUNCTION PFCHAR(P_CHAR IN VARCHAR2 DEFAULT TO_CHAR(NULL)) RETURN VARCHAR2 ;
8 FUNCTION PFNUM(P_NUM IN NUMBER DEFAULT TO_NUMBER(NULL)) RETURN NUMBER;
9 FUNCTION PFDATE(P_DATE IN DATE DEFAULT TO_DATE(NULL)) RETURN DATE ;
10
11 PROCEDURE Create_Task_Assignment_Periods
12 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
14 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19 ,p_task_assignment_periods_in IN pa_task_assignments_pub.ASSIGNMENT_PERIODS_TBL_TYPE
20 ,p_task_assignment_periods_out OUT NOCOPY pa_task_assignments_pub.ASSIGNMENT_OUT_TBL_TYPE
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ) ;
25
26 PROCEDURE lock_version( p_project_id IN NUMBER, p_structure_version_id IN NUMBER);
27 /*
28 FUNCTION GET_PERIOD_START_DATE(P_PERIOD_NAME IN VARCHAR2, P_BUDGET_VERSION_ID IN NUMBER) RETURN DATE;
29 */
30 PROCEDURE Derive_Task_Assignments
31 ( p_project_id IN PA_PROJECTS_ALL.project_id%TYPE
32 ,p_extraction_type IN VARCHAR2 DEFAULT NULL -- Added for bug 13419867
33 ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
34 ,p_scheduled_start IN DATE
35 ,p_scheduled_end IN DATE
36 ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
37 ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
38 -- CBS Change in Derive_Task_Assignments
39 ,p_cbs_element_id IN PA_RESOURCE_ASSIGNMENTS.cbs_element_id%TYPE DEFAULT NULL
40 -- End CBS Change in Derive_Task_Assignments
41 ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE
42 ,x_resource_assignment_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
43 ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
44 ,x_resource_list_member_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
45 ,x_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46 ,x_rate_based_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47 ,x_rbs_element_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2
50 ,x_return_status OUT NOCOPY VARCHAR2
51 );
52
53
54
55
56
57 PROCEDURE Copy_Missing_Unplanned_Asgmts
58 (
59 p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
60 p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
61 p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
62 p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE Check_Period_Details(
69 P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
70 p_period_set_name IN gl_periods.period_set_name%TYPE,
71 p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
72 p_accounted_period_type IN gl_periods.period_type%TYPE,
73 p_pa_period_type IN gl_periods.period_type%TYPE,
74 p_task_name IN pa_proj_elements.name%TYPE,
75 p_rlm_alias IN pa_resource_list_members.alias%TYPE,
76 P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77 P_PERIOD_START_DATE IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
78 P_PERIOD_END_DATE IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
79 x_return_status OUT NOCOPY VARCHAR2
80 );
81
82 END PA_TASK_ASSIGNMENTS_PVT;