1 PACKAGE PA_CONTROL_ITEMS_PKG AUTHID CURRENT_USER AS
2 --$Header: PACICITS.pls 120.3.12010000.5 2010/05/06 11:59:15 rrambati ship $
3
4
5 procedure INSERT_ROW (
6 p_ci_type_id IN NUMBER
7 ,p_summary IN VARCHAR2
8 ,p_status_code IN VARCHAR2
9 ,p_owner_id IN NUMBER
10 ,p_highlighted_flag IN VARCHAR2
11 ,p_progress_status_code IN VARCHAR2
12 ,p_progress_as_of_date IN DATE
13 ,p_classification_code IN NUMBER
14 ,p_reason_code IN NUMBER
15 ,p_project_id IN NUMBER
16 ,p_last_modified_by_id IN NUMBER
17 := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
18 ,p_object_type IN VARCHAR2 := NULL
19 ,p_object_id IN NUMBER := NULL
20 ,p_ci_number IN VARCHAR2 := NULL
21 ,p_date_required IN DATE := NULL
22 ,p_date_closed IN DATE := NULL
23 ,p_closed_by_id IN NUMBER := NULL
24
25 ,p_description IN VARCHAR2 := NULL
26 ,p_status_overview IN VARCHAR2 := NULL
27 ,p_resolution IN VARCHAR2 := NULL
28 ,p_resolution_code IN NUMBER := NULL
29 ,p_priority_code IN VARCHAR2 := NULL
30 ,p_effort_level_code IN VARCHAR2 := NULL
31 ,p_open_action_num IN NUMBER := NULL
32
33 ,p_price IN NUMBER := NULL
34 ,p_price_currency_code IN VARCHAR2 := NULL
35 ,p_source_type_code IN VARCHAR2 := NULL
36 ,p_source_comment IN VARCHAR2 := NULL
37 ,p_source_number IN VARCHAR2 := NULL
38 ,p_source_date_received IN DATE := NULL
39
40 ,p_source_organization IN VARCHAR2 := NULL
41 ,p_source_person IN VARCHAR2 := NULL
42
43 ,p_attribute_category IN VARCHAR2 := NULL
44 ,p_attribute1 IN VARCHAR2 := NULL
45 ,p_attribute2 IN VARCHAR2 := NULL
46 ,p_attribute3 IN VARCHAR2 := NULL
47 ,p_attribute4 IN VARCHAR2 := NULL
48 ,p_attribute5 IN VARCHAR2 := NULL
49 ,p_attribute6 IN VARCHAR2 := NULL
50 ,p_attribute7 IN VARCHAR2 := NULL
51 ,p_attribute8 IN VARCHAR2 := NULL
52 ,p_attribute9 IN VARCHAR2 := NULL
53 ,p_attribute10 IN VARCHAR2 := NULL
54 ,p_attribute11 IN VARCHAR2 := NULL
55 ,p_attribute12 IN VARCHAR2 := NULL
56 ,p_attribute13 IN VARCHAR2 := NULL
57 ,p_attribute14 IN VARCHAR2 := NULL
58 ,p_attribute15 IN VARCHAR2 := NULL
59
60 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
61 ,p_PCO_STATUS_CODE IN VARCHAR2 := NULL
62 ,p_APPROVAL_TYPE_CODE IN VARCHAR2 := NULL
63 ,p_LOCKED_FLAG IN VARCHAR2 := 'N'
64 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
65
66 ,p_Version_number IN number := null
67 ,p_Current_Version_flag IN varchar2 := 'Y'
68 ,p_Version_Comments IN varchar2 := NULL
69 ,p_Original_ci_id IN number := NULL
70 ,p_Source_ci_id IN number := NULL
71 ,px_ci_id IN OUT NOCOPY NUMBER
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2
75 ,p_orig_system_code IN VARCHAR2 := NULL
76 ,p_orig_system_reference IN VARCHAR2 := NULL
77 ,p_change_approver IN varchar2 DEFAULT NULL --Added for bug 9108474
78 );
79
80 procedure UPDATE_ROW (
81
82 p_ci_id IN NUMBER
83 ,p_ci_type_id IN NUMBER
84 ,p_summary IN VARCHAR2
85 ,p_status_code IN VARCHAR2
86 ,p_owner_id IN NUMBER
87 ,p_highlighted_flag IN VARCHAR2
88 ,p_progress_status_code IN VARCHAR2
89 ,p_progress_as_of_date IN DATE
90 ,p_classification_code IN NUMBER
91 ,p_reason_code IN NUMBER
92 ,p_record_version_number IN NUMBER
93
94 ,p_project_id IN NUMBER
95 ,p_last_modified_by_id IN NUMBER
96 := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
97 ,p_object_type IN VARCHAR2 := NULL
98 ,p_object_id IN NUMBER := NULL
99 ,p_ci_number IN VARCHAR2 := NULL
100 ,p_date_required IN DATE := NULL
101 ,p_date_closed IN DATE := NULL
102 ,p_closed_by_id IN NUMBER := NULL
103 ,p_description IN VARCHAR2 := NULL
104 ,p_status_overview IN VARCHAR2 := NULL
105
106 ,p_resolution IN VARCHAR2 := NULL
107 ,p_resolution_code IN NUMBER := NULL
108 ,p_priority_code IN VARCHAR2 := NULL
109 ,p_effort_level_code IN VARCHAR2 := NULL
110 ,p_open_action_num IN NUMBER := NULL
111
112 ,p_price IN NUMBER := NULL
113 ,p_price_currency_code IN VARCHAR2 := NULL
114 ,p_source_type_code IN VARCHAR2 := NULL
115 ,p_source_comment IN VARCHAR2 := NULL
116 ,p_source_number IN VARCHAR2 := NULL
117 ,p_source_date_received IN DATE := NULL
118 ,p_source_organization IN VARCHAR2 := NULL
119 ,p_source_person IN VARCHAR2 := NULL
120 ,p_attribute_category IN VARCHAR2 := NULL
121 ,p_attribute1 IN VARCHAR2 := NULL
122 ,p_attribute2 IN VARCHAR2 := NULL
123 ,p_attribute3 IN VARCHAR2 := NULL
124 ,p_attribute4 IN VARCHAR2 := NULL
125 ,p_attribute5 IN VARCHAR2 := NULL
126 ,p_attribute6 IN VARCHAR2 := NULL
127 ,p_attribute7 IN VARCHAR2 := NULL
128 ,p_attribute8 IN VARCHAR2 := NULL
129 ,p_attribute9 IN VARCHAR2 := NULL
130 ,p_attribute10 IN VARCHAR2 := NULL
131 ,p_attribute11 IN VARCHAR2 := NULL
132 ,p_attribute12 IN VARCHAR2 := NULL
133 ,p_attribute13 IN VARCHAR2 := NULL
134 ,p_attribute14 IN VARCHAR2 := NULL
135 ,p_attribute15 IN VARCHAR2 := NULL
136
137 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
138 ,p_PCO_STATUS_CODE IN VARCHAR2 := NULL
139 ,p_APPROVAL_TYPE_CODE IN VARCHAR2 := NULL
140 ,p_LOCKED_FLAG IN VARCHAR2 := 'N'
141 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
142
143 ,p_Version_number IN number := null
144 ,p_Current_Version_flag IN varchar2 := 'Y'
145 ,p_Version_Comments IN varchar2 := NULL
146 ,p_Original_ci_id IN number := NULL
147 ,p_Source_ci_id IN number := NULL
148 ,p_change_approver IN varchar2 := NULL
149 ,x_return_status OUT NOCOPY VARCHAR2
150 ,x_msg_count OUT NOCOPY NUMBER
151 ,x_msg_data OUT NOCOPY VARCHAR2
152 ,p_last_updated_by in NUMBER default fnd_global.user_id
153 ,p_last_update_date in DATE default sysdate
154 ,p_last_update_login in NUMBER default fnd_global.user_id
155 );
156
157 procedure DELETE_ROW (
158 p_ci_id IN NUMBER
159 ,p_record_version_number IN NUMBER
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 );
164
165 END PA_CONTROL_ITEMS_PKG;