[Home] [Help]
PACKAGE: APPS.CUG_SR_TYPE_ATTR_MAPS_PKG_W
Source
1 package cug_sr_type_attr_maps_pkg_w AUTHID CURRENT_USER as
2 /* $Header: CUGSRTYS.pls 115.6 2004/03/29 21:43:56 aneemuch ship $ */
3 procedure insert_row(x_rowid in out nocopy VARCHAR2
4 , x_sr_type_attr_map_id NUMBER
5 , x_sr_type_attr_seq_num NUMBER
6 , x_object_version_number NUMBER
7 , x_incident_type_id NUMBER
8 , x_sr_attribute_code VARCHAR2
9 , x_sr_attr_mandatory_flag VARCHAR2
10 , x_sr_attr_displayed_flag VARCHAR2
11 , x_sr_attr_dup_check_flag VARCHAR2
12 , x_sr_attribute_list_name VARCHAR2
13 , x_attribute1 VARCHAR2
14 , x_attribute2 VARCHAR2
15 , x_attribute3 VARCHAR2
16 , x_attribute4 VARCHAR2
17 , x_attribute5 VARCHAR2
18 , x_attribute6 VARCHAR2
19 , x_attribute7 VARCHAR2
20 , x_attribute8 VARCHAR2
21 , x_attribute9 VARCHAR2
22 , x_attribute10 VARCHAR2
23 , x_attribute11 VARCHAR2
24 , x_attribute12 VARCHAR2
25 , x_attribute13 VARCHAR2
26 , x_attribute14 VARCHAR2
27 , x_attribute15 VARCHAR2
28 , x_attribute_category VARCHAR2
29 , x_start_date_active date
30 , x_end_date_active date
31 , x_security_group_id NUMBER
32 , x_template_id NUMBER
33 , x_reqd_for_close_flag VARCHAR2
34 , x_show_on_update_flag VARCHAR2
35 , x_update_allowed_flag VARCHAR2
36 , x_sr_attr_default_value VARCHAR2
37 , x_creation_date date
38 , x_created_by NUMBER
39 , x_last_update_date date
40 , x_last_updated_by NUMBER
41 , x_last_update_login NUMBER
42 );
43 procedure lock_row(x_sr_type_attr_map_id NUMBER
44 , x_sr_type_attr_seq_num NUMBER
45 , x_object_version_number NUMBER
46 , x_incident_type_id NUMBER
47 , x_sr_attribute_code VARCHAR2
48 , x_sr_attr_mandatory_flag VARCHAR2
49 , x_sr_attr_displayed_flag VARCHAR2
50 , x_sr_attr_dup_check_flag VARCHAR2
51 , x_sr_attribute_list_name VARCHAR2
52 , x_attribute1 VARCHAR2
53 , x_attribute2 VARCHAR2
54 , x_attribute3 VARCHAR2
55 , x_attribute4 VARCHAR2
56 , x_attribute5 VARCHAR2
57 , x_attribute6 VARCHAR2
58 , x_attribute7 VARCHAR2
59 , x_attribute8 VARCHAR2
60 , x_attribute9 VARCHAR2
61 , x_attribute10 VARCHAR2
62 , x_attribute11 VARCHAR2
63 , x_attribute12 VARCHAR2
64 , x_attribute13 VARCHAR2
65 , x_attribute14 VARCHAR2
66 , x_attribute15 VARCHAR2
67 , x_attribute_category VARCHAR2
68 , x_start_date_active date
69 , x_end_date_active date
70 , x_security_group_id NUMBER
71 , x_template_id NUMBER
72 , x_reqd_for_close_flag VARCHAR2
73 , x_show_on_update_flag VARCHAR2
74 , x_update_allowed_flag VARCHAR2
75 , x_sr_attr_default_value VARCHAR2
76 );
77 procedure update_row(x_sr_type_attr_map_id NUMBER
78 , x_sr_type_attr_seq_num NUMBER
79 , x_object_version_number NUMBER
80 , x_incident_type_id NUMBER
81 , x_sr_attribute_code VARCHAR2
82 , x_sr_attr_mandatory_flag VARCHAR2
83 , x_sr_attr_displayed_flag VARCHAR2
84 , x_sr_attr_dup_check_flag VARCHAR2
85 , x_sr_attribute_list_name VARCHAR2
86 , x_attribute1 VARCHAR2
87 , x_attribute2 VARCHAR2
88 , x_attribute3 VARCHAR2
89 , x_attribute4 VARCHAR2
90 , x_attribute5 VARCHAR2
91 , x_attribute6 VARCHAR2
92 , x_attribute7 VARCHAR2
93 , x_attribute8 VARCHAR2
94 , x_attribute9 VARCHAR2
95 , x_attribute10 VARCHAR2
96 , x_attribute11 VARCHAR2
97 , x_attribute12 VARCHAR2
98 , x_attribute13 VARCHAR2
99 , x_attribute14 VARCHAR2
100 , x_attribute15 VARCHAR2
101 , x_attribute_category VARCHAR2
102 , x_start_date_active date
103 , x_end_date_active date
104 , x_security_group_id NUMBER
105 , x_template_id NUMBER
106 , x_reqd_for_close_flag VARCHAR2
107 , x_show_on_update_flag VARCHAR2
108 , x_update_allowed_flag VARCHAR2
109 , x_sr_attr_default_value VARCHAR2
110 , x_last_update_date date
111 , x_last_updated_by NUMBER
112 , x_last_update_login NUMBER
113 );
114 procedure load_row(x_sr_type_attr_map_id NUMBER
115 , x_incident_type_id NUMBER
116 , x_sr_attribute_code VARCHAR2
117 , x_sr_attr_mandatory_flag VARCHAR2
118 , x_sr_attr_displayed_flag VARCHAR2
119 , x_sr_attr_dup_check_flag VARCHAR2
120 , x_sr_attribute_list_name VARCHAR2
121 , x_start_date_active date
122 , x_end_date_active date
123 , x_sr_attr_default_value VARCHAR2
124 , x_template_id NUMBER
125 , x_reqd_for_close_flag VARCHAR2
126 , x_show_on_update_flag VARCHAR2
127 , x_update_allowed_flag VARCHAR2
128 , x_sr_type_attr_seq_num NUMBER
129 , x_security_group_id NUMBER
130 , x_creation_date VARCHAR2
131 , x_created_by NUMBER
132 , x_last_update_date VARCHAR2
133 , x_last_updated_by NUMBER
134 , x_last_update_login NUMBER
135 , x_owner VARCHAR2
136 );
137 end cug_sr_type_attr_maps_pkg_w;