1 PACKAGE PA_CONTROL_ITEMS_PKG AS
2 --$Header: PACICITS.pls 120.3 2007/02/08 11:26:45 sukhanna noship $
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 ,p_object_type IN VARCHAR2 := NULL
18 ,p_object_id IN NUMBER := NULL
19 ,p_ci_number IN VARCHAR2 := NULL
20 ,p_date_required IN DATE := NULL
21 ,p_date_closed IN DATE := NULL
22 ,p_closed_by_id IN NUMBER := NULL
23
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 ,px_ci_id IN OUT NOCOPY NUMBER
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ,p_orig_system_code IN VARCHAR2 := NULL
64 ,p_orig_system_reference IN VARCHAR2 := NULL
65 );
66
67 procedure UPDATE_ROW (
68
69 p_ci_id IN NUMBER
70 ,p_ci_type_id IN NUMBER
71 ,p_summary IN VARCHAR2
72 ,p_status_code IN VARCHAR2
73 ,p_owner_id IN NUMBER
74 ,p_highlighted_flag IN VARCHAR2
75 ,p_progress_status_code IN VARCHAR2
76 ,p_progress_as_of_date IN DATE
77 ,p_classification_code IN NUMBER
78 ,p_reason_code IN NUMBER
79 ,p_record_version_number IN NUMBER
80
81 ,p_project_id IN NUMBER
82 ,p_last_modified_by_id IN NUMBER
83 ,p_object_type IN VARCHAR2 := NULL
84 ,p_object_id IN NUMBER := NULL
85 ,p_ci_number IN VARCHAR2 := NULL
86 ,p_date_required IN DATE := NULL
87 ,p_date_closed IN DATE := NULL
88 ,p_closed_by_id IN NUMBER := NULL
89 ,p_description IN VARCHAR2 := NULL
90 ,p_status_overview IN VARCHAR2 := NULL
91
92 ,p_resolution IN VARCHAR2 := NULL
93 ,p_resolution_code IN NUMBER := NULL
94 ,p_priority_code IN VARCHAR2 := NULL
95 ,p_effort_level_code IN VARCHAR2 := NULL
96 ,p_open_action_num IN NUMBER := NULL
97
98 ,p_price IN NUMBER := NULL
99 ,p_price_currency_code IN VARCHAR2 := NULL
100 ,p_source_type_code IN VARCHAR2 := NULL
101 ,p_source_comment IN VARCHAR2 := NULL
102 ,p_source_number IN VARCHAR2 := NULL
103 ,p_source_date_received IN DATE := NULL
104 ,p_source_organization IN VARCHAR2 := NULL
105 ,p_source_person IN VARCHAR2 := NULL
106 ,p_attribute_category IN VARCHAR2 := NULL
107 ,p_attribute1 IN VARCHAR2 := NULL
108 ,p_attribute2 IN VARCHAR2 := NULL
109 ,p_attribute3 IN VARCHAR2 := NULL
110 ,p_attribute4 IN VARCHAR2 := NULL
111 ,p_attribute5 IN VARCHAR2 := NULL
112 ,p_attribute6 IN VARCHAR2 := NULL
113 ,p_attribute7 IN VARCHAR2 := NULL
114 ,p_attribute8 IN VARCHAR2 := NULL
115 ,p_attribute9 IN VARCHAR2 := NULL
116 ,p_attribute10 IN VARCHAR2 := NULL
117 ,p_attribute11 IN VARCHAR2 := NULL
118 ,p_attribute12 IN VARCHAR2 := NULL
119 ,p_attribute13 IN VARCHAR2 := NULL
120 ,p_attribute14 IN VARCHAR2 := NULL
121 ,p_attribute15 IN VARCHAR2 := NULL
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_msg_count OUT NOCOPY NUMBER
124 ,x_msg_data OUT NOCOPY VARCHAR2
125 ,p_last_updated_by in NUMBER default fnd_global.user_id
126 ,p_last_update_date in DATE default sysdate
127 ,p_last_update_login in NUMBER default fnd_global.user_id
128 );
129
130 procedure DELETE_ROW (
131 p_ci_id IN NUMBER
132 ,p_record_version_number IN NUMBER
133 ,x_return_status OUT NOCOPY VARCHAR2
134 ,x_msg_count OUT NOCOPY NUMBER
135 ,x_msg_data OUT NOCOPY VARCHAR2
136 );
137
138 END PA_CONTROL_ITEMS_PKG;