1 PACKAGE PA_TASK_ASSIGNMENTS_PVT AS
2 -- $Header: PATAPVTS.pls 120.1 2005/08/19 17:03:23 mwasowic noship $
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_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
33 ,p_scheduled_start IN DATE
34 ,p_scheduled_end IN DATE
35 ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
36 ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
37 ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE
38 ,x_resource_assignment_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
39 ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
40 ,x_resource_list_member_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41 ,x_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42 ,x_rate_based_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 ,x_rbs_element_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 ,x_return_status OUT NOCOPY VARCHAR2
47 );
48
49
50
51
52
53 PROCEDURE Copy_Missing_Unplanned_Asgmts
54 (
55 p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
56 p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
57 p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
58 p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE Check_Period_Details(
65 P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
66 p_period_set_name IN gl_periods.period_set_name%TYPE,
67 p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
68 p_accounted_period_type IN gl_periods.period_type%TYPE,
69 p_pa_period_type IN gl_periods.period_type%TYPE,
70 p_task_name IN pa_proj_elements.name%TYPE,
71 p_rlm_alias IN pa_resource_list_members.alias%TYPE,
72 P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
73 P_PERIOD_START_DATE IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
74 P_PERIOD_END_DATE IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
75 x_return_status OUT NOCOPY VARCHAR2
76 );
77
78 END PA_TASK_ASSIGNMENTS_PVT;