[Home] [Help]
PACKAGE: APPS.PA_ASSIGNMENTS_PVT
Source
1 PACKAGE pa_assignments_pvt AUTHID CURRENT_USER AS
2 /*$Header: PARAPVTS.pls 120.1 2005/08/19 16:47:44 mwasowic noship $*/
3 --
4 PROCEDURE Create_Assignment
5 ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
6 ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
7 ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
8 ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
9 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
10 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
11 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
12 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
13 ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
14 ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
15 ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16 ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17 ,p_number_of_requirements IN NUMBER := 1
18 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
19 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
20 ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
21 ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
22 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
23 ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
24 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25 );
26
27
28
29 PROCEDURE Update_Assignment
30 ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
31 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
32 ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
33 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
34 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
35 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
36 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
37 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
38 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39 );
40
41
42 PROCEDURE Delete_Assignment
43 ( p_assignment_row_id IN ROWID := NULL
44 ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
45 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
46 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
47 ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
48 ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
49 ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
50 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
51 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
52 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53 );
54
55 PROCEDURE Update_Revenue_Bill_Rate
56 ( p_assignment_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp
57 ,p_revenue_bill_rate_tbl IN PA_PLSQL_DATATYPES.NumTabTyp
58 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59 );
60
61 /* Added procedure Update_Transfer_Price for bug 3051110*/
62 PROCEDURE Update_Transfer_Price
63 ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
64 ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
65 ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
66 ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
67 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
68 );
69
70 /* Added procedure Calc_Init_Transfer_Price for bug 3051110*/
71 PROCEDURE Calc_Init_Transfer_Price
72 ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
73 ,p_start_date IN pa_project_assignments.start_date%TYPE
74 ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
75 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77 ,x_msg_count OUT NOCOPY Number --File.Sql.39 bug 4440895
78 );
79
80 PROCEDURE Update_Task_Assignments
81 ( p_mode IN VARCHAR2 := 'UPDATE'
82 ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
83 ,p_task_version_id_tbl IN system.pa_num_tbl_type
84 ,p_budget_version_id_tbl IN system.pa_num_tbl_type
85 ,p_struct_version_id_tbl IN system.pa_num_tbl_type
86 ,p_project_assignment_id IN NUMBER := NULL
87 ,p_resource_list_member_id IN NUMBER := NULL
88 ,p_resource_class_flag IN VARCHAR2 := NULL
89 ,p_resource_class_code IN VARCHAR2 := NULL
90 ,p_resource_class_id IN NUMBER := NULL
91 ,p_res_type_code IN VARCHAR2 := NULL
92 ,p_incur_by_res_type IN VARCHAR2 := NULL
93 ,p_person_id IN NUMBER := NULL
94 ,p_job_id IN NUMBER := NULL
95 ,p_person_type_code IN VARCHAR2 := NULL
96 ,p_named_role IN VARCHAR2 := NULL
97 ,p_bom_resource_id IN NUMBER := NULL
98 ,p_non_labor_resource IN VARCHAR2 := NULL
99 ,p_inventory_item_id IN NUMBER := NULL
100 ,p_item_category_id IN NUMBER := NULL
101 ,p_project_role_id IN NUMBER := NULL
102 ,p_organization_id IN NUMBER := NULL
103 ,p_fc_res_type_code IN VARCHAR2 := NULL
104 ,p_expenditure_type IN VARCHAR2 := NULL
105 ,p_expenditure_category IN VARCHAR2 := NULL
106 ,p_event_type IN VARCHAR2 := NULL
107 ,p_revenue_category_code IN VARCHAR2 := NULL
108 ,p_supplier_id IN NUMBER := NULL
109 ,p_spread_curve_id IN NUMBER := NULL
110 ,p_etc_method_code IN VARCHAR2 := NULL
111 ,p_mfc_cost_type_id IN NUMBER := NULL
112 ,p_incurred_by_res_flag IN VARCHAR2 := NULL
113 ,p_incur_by_res_class_code IN VARCHAR2 := NULL
114 ,p_incur_by_role_id IN NUMBER := NULL
115 ,p_unit_of_measure IN VARCHAR2 := NULL
116 ,p_org_id IN NUMBER := NULL
117 ,p_rate_based_flag IN VARCHAR2 := NULL
118 ,p_rate_expenditure_type IN VARCHAR2 := NULL
119 ,p_rate_func_curr_code IN VARCHAR2 := NULL
120 ,p_rate_incurred_by_org_id IN NUMBER := NULL
121 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122 );
123
124 END pa_assignments_pvt;