1 package PA_PROJECT_CORE as
2 -- $Header: PAXPCORS.pls 120.1.12010000.2 2008/09/30 09:38:03 sugupta ship $
3
4
5 --
6 -- PROCEDURE
7 -- delete_project
8 -- PURPOSE
9 -- This objective of this API is to delete projects from
10 -- the PA system. All detail information will be deleted.
11 -- This API can be used by Enter Project form and other
12 -- external systems.
13 --
14 -- In order to delete a project, a project must NOT
15 -- have any of the following:
16 --
17 -- * Event
18 -- * Expenditure item
19 -- * Puchase order line
20 -- * Requisition line
21 -- * Supplier invoice (ap invoice)
22 -- * Funding
23 -- * Baseline budget
24 --
25 -- HISTORY
26 -- 24-OCT-95 R. Chiu Created
27 --
28 procedure delete_project ( x_project_id IN number
29 , x_validation_mode IN VARCHAR2 DEFAULT 'U' --bug 2947492
30 , x_err_code IN OUT NOCOPY number --File.Sql.39 bug 4440895
31 , x_err_stage IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
32 , x_err_stack IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
33 , x_commit IN VARCHAR2 := FND_API.G_FALSE );
34
35
36 --
37 -- PROCEDURE
38 -- import_task
39 -- PURPOSE
40 -- This objective of this API is to import tasks into
41 -- PA system. This API can be called by task import system
42 -- and other external systems. Other task related information
43 -- can be entered by using Enter Project form or calling table
44 -- handlers.
45 --
46 --
47 -- HISTORY
48 -- 24-OCT-95 R. Chiu Created
49 --
50 procedure import_task ( x_project_id IN number
51 , x_task_name IN varchar2
52 , x_task_number IN varchar2
53 , x_service_type_code IN varchar2
54 , x_organization_id IN number
55 , x_description IN varchar2
56 , x_task_start_date IN date
57 , x_task_end_date IN date
58 , x_parent_task_id IN number
59 , x_pm_project_id IN number
60 , x_pm_task_id IN number
61 , x_manager_id IN number
62 , x_new_task_id OUT NOCOPY number --File.Sql.39 bug 4440895
63 , x_err_code IN OUT NOCOPY number --File.Sql.39 bug 4440895
64 , x_err_stage IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
65 , x_err_stack IN OUT NOCOPY varchar2); --File.Sql.39 bug 4440895
66
67
68 --
69 -- PROCEDURE
70 -- delete_task
71 -- PURPOSE
72 -- This objective of this API is to delete tasks from
73 -- the PA system. All task detail information along
74 -- with the specified task will be deleted if there's
75 -- no transaction charged to the task. This API can
76 -- be used by Enter Project form and other external systems.
77 --
78 -- To delete a top task and its subtasks, the following
79 -- requirements must be met:
80 -- * No event at top level task
81 -- * No funding at top level tasks
82 -- * No baseline budget at top level task
83 -- * Meet the following requirements for its children
84 --
85 -- To delete a mid level task, it involves checking its
86 -- children and meeting the following requirements for
87 -- its lowest level task.
88 --
89 -- To delete a lowest level task, the following requirements
90 -- must be met:
91 -- * No expenditure item at lowest level task
92 -- * No puchase order line at lowest level task
93 -- * No requisition line at lowest level task
94 -- * No supplier invoice (ap invoice) at lowest level task
95 -- * No baseline budget at lowest level task
96 --
97 -- HISTORY
98 -- 25-OCT-95 R. Chiu Created
99 -- 30-DEC-03 Rakesh Raghavan Modified
100 --
101 procedure delete_task ( x_task_id IN number
102 , x_validation_mode IN VARCHAR2 DEFAULT 'U' --bug 2947492
103 , x_validate_flag IN varchar2 DEFAULT 'Y' --Adding paramater x_validate_flag
104 , x_bulk_flag IN VARCHAR2 DEFAULT 'N' -- 4201927
105 , x_err_code IN OUT NOCOPY number --File.Sql.39 bug 4440895
106 , x_err_stage IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
107 , x_err_stack IN OUT NOCOPY varchar2); --File.Sql.39 bug 4440895
108 --
109 -- PROCEDURE
110 -- delete_project_type
111 --
112 -- HISTORY
113 -- 01-NOV-02 Mansari Created
114 --
115
116 procedure delete_project_type (
117 x_project_type_id IN number
118 , x_msg_count OUT NOCOPY number --File.Sql.39 bug 4440895
119 , x_msg_data OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
120 , x_return_status OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
121 );
122
123 --
124 -- PROCEDURE
125 -- delete_class_category
126 --
127 -- HISTORY
128 -- 01-NOV-02 Mansari Created
129 --
130
131 procedure delete_class_category (
132 x_class_category IN VARCHAR2
133 , x_msg_count OUT NOCOPY number --File.Sql.39 bug 4440895
134 , x_msg_data OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
135 , x_return_status OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
136 );
137
138 --
139 -- PROCEDURE
140 -- delete_class_code
141 --
142 -- HISTORY
143 -- 01-NOV-02 Mansari Created
144 --
145 procedure delete_class_code (
146 x_class_category IN VARCHAR2
147 , x_class_code IN VARCHAR2
148 , x_msg_count OUT NOCOPY number --File.Sql.39 bug 4440895
149 , x_msg_data OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
150 , x_return_status OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
151 );
152
153 end PA_PROJECT_CORE ;