1 PACKAGE EGO_LIFECYCLE_USER_PUB AS
2 /* $Header: EGOPLCUS.pls 120.2 2007/05/30 10:47:53 srajapar ship $ */
3
4 FUNCTION get_change_name (p_change_id IN NUMBER) return VARCHAR2;
5
6 PROCEDURE Check_Delete_Project_OK
7 (
8 p_api_version IN NUMBER
9 , p_project_id IN NUMBER
10 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11 , x_delete_ok OUT NOCOPY VARCHAR2
12 , x_return_status OUT NOCOPY VARCHAR2
13 , x_errorcode OUT NOCOPY NUMBER
14 , x_msg_count OUT NOCOPY NUMBER
15 , x_msg_data OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE Get_Policy_For_Revise
19 (
20 p_api_version IN NUMBER
21 , p_inventory_item_id IN NUMBER
22 , p_organization_id IN NUMBER
23 , p_curr_phase_id IN NUMBER
24 , x_policy_code OUT NOCOPY VARCHAR2
25 , x_return_status OUT NOCOPY VARCHAR2
26 , x_errorcode OUT NOCOPY NUMBER
27 , x_msg_count OUT NOCOPY NUMBER
28 , x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31
32 PROCEDURE Get_Policy_For_Phase_Change
33 (
34 p_api_version IN NUMBER
35 , p_project_id IN NUMBER DEFAULT NULL
36 , p_inventory_item_id IN NUMBER DEFAULT NULL
37 , p_organization_id IN NUMBER DEFAULT NULL
38 , p_curr_phase_id IN NUMBER
39 , p_future_phase_id IN NUMBER
40 , p_phase_change_code IN VARCHAR2
41 , p_lifecycle_id IN NUMBER
42 , x_policy_code OUT NOCOPY VARCHAR2
43 , x_return_status OUT NOCOPY VARCHAR2
44 , x_errorcode OUT NOCOPY NUMBER
45 , x_msg_count OUT NOCOPY NUMBER
46 , x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE Get_Policy_For_Phase_Change
50 (
51 p_api_version IN NUMBER
52 , p_project_id IN NUMBER
53 , p_curr_phase_id IN NUMBER
54 , p_future_phase_id IN NUMBER
55 , p_phase_change_code IN VARCHAR2
56 , p_lifecycle_id IN NUMBER
57 , x_policy_code OUT NOCOPY VARCHAR2
58 , x_error_message OUT NOCOPY VARCHAR2
59 , x_return_status OUT NOCOPY VARCHAR2
60 , x_errorcode OUT NOCOPY NUMBER
61 , x_msg_count OUT NOCOPY NUMBER
62 , x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65
66 PROCEDURE Check_Lc_Tracking_Project
67 (
68 p_api_version IN NUMBER
69 , p_project_id IN NUMBER
70 , x_is_lifecycle_tracking OUT NOCOPY VARCHAR2
71 , x_return_status OUT NOCOPY VARCHAR2
72 , x_errorcode OUT NOCOPY NUMBER
73 , x_msg_count OUT NOCOPY NUMBER
74 , x_msg_data OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE Delete_All_Item_Assocs
78 (
79 p_api_version IN NUMBER
80 , p_project_id IN NUMBER
81 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
82 , x_return_status OUT NOCOPY VARCHAR2
83 , x_errorcode OUT NOCOPY NUMBER
84 , x_msg_count OUT NOCOPY NUMBER
85 , x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Sync_Phase_Change
89 (
90 p_api_version IN NUMBER
91 , p_project_id IN NUMBER
92 , p_lifecycle_id IN NUMBER
93 , p_phase_id IN NUMBER
94 , p_effective_date IN DATE
95 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
96 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
97 , x_return_status OUT NOCOPY VARCHAR2
98 , x_errorcode OUT NOCOPY NUMBER
99 , x_msg_count OUT NOCOPY NUMBER
100 , x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE Sync_Phase_Change
104 (
105 p_api_version IN NUMBER
106 , p_organization_id IN NUMBER
107 , p_inventory_item_id IN NUMBER
108 , p_revision IN VARCHAR2 DEFAULT NULL
109 , p_lifecycle_id IN NUMBER
110 , p_phase_id IN NUMBER
111 , p_effective_date IN DATE
112 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
113 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
114 , x_return_status OUT NOCOPY VARCHAR2
115 , x_errorcode OUT NOCOPY NUMBER
116 , x_msg_count OUT NOCOPY NUMBER
117 , x_msg_data OUT NOCOPY VARCHAR2
118 );
119
120
121 PROCEDURE Create_Project_Item_Assoc
122 (
123 p_api_version IN NUMBER
124 , p_project_id IN NUMBER
125 , p_organization_id IN NUMBER
126 , p_inventory_item_id IN NUMBER
127 , p_revision IN VARCHAR2 DEFAULT NULL
128 , p_revision_id IN NUMBER DEFAULT NULL
129 , p_task_id IN NUMBER DEFAULT NULL
130 , p_association_type IN VARCHAR2
131 , p_association_code IN VARCHAR2
132 , p_organization_specific IN VARCHAR2 DEFAULT FND_API.G_FALSE
133 -- Currently not used
134 , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_TRUE
135 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
136 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
137 , x_return_status OUT NOCOPY VARCHAR2
138 , x_errorcode OUT NOCOPY NUMBER
139 , x_msg_count OUT NOCOPY NUMBER
140 , x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143 PROCEDURE Copy_Project
144 (
145 p_api_version IN NUMBER
146 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
147 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
148 , p_source_item_id IN NUMBER
149 , p_source_org_id IN NUMBER
150 , p_source_rev_id IN NUMBER
151 , p_association_type IN VARCHAR2
152 , p_association_code IN VARCHAR2
153 , p_dest_item_id IN NUMBER
154 , p_dest_org_id IN NUMBER
155 , p_dest_rev_id IN NUMBER
156 , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_FALSE
157 , x_return_status OUT NOCOPY VARCHAR2
158 , x_error_code OUT NOCOPY NUMBER
159 , x_msg_count OUT NOCOPY NUMBER
160 , x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163 PROCEDURE Copy_Item_Assocs
164 (
165 p_api_version IN NUMBER
166 ,p_project_id_from IN NUMBER
167 ,p_project_id_to IN NUMBER
168 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
170 ,x_return_status OUT NOCOPY VARCHAR2
171 ,x_errorcode OUT NOCOPY NUMBER
172 ,x_msg_count OUT NOCOPY NUMBER
173 ,x_msg_data OUT NOCOPY VARCHAR2
174 );
175
176 FUNCTION Has_LC_Tracking_Project (
177 p_organization_id IN NUMBER
178 , p_inventory_item_id IN NUMBER
179 , p_revision IN VARCHAR2 DEFAULT NULL
180 ) RETURN VARCHAR2;
181
182 END EGO_LIFECYCLE_USER_PUB;
183