eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_SYSTEMS_PVT dependencies on DBMS_SQL

Line 169: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 1, p_system_rec.system_id);

165: )
166: IS
167: BEGIN
168:
169: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 1, p_system_rec.system_id);
170: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 2, p_system_rec.customer_id);
171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);
172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);

Line 170: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 2, p_system_rec.customer_id);

166: IS
167: BEGIN
168:
169: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 1, p_system_rec.system_id);
170: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 2, p_system_rec.customer_id);
171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);
172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);

Line 171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);

167: BEGIN
168:
169: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 1, p_system_rec.system_id);
170: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 2, p_system_rec.customer_id);
171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);
172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);

Line 172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);

168:
169: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 1, p_system_rec.system_id);
170: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 2, p_system_rec.customer_id);
171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);
172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);

Line 173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);

169: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 1, p_system_rec.system_id);
170: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 2, p_system_rec.customer_id);
171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);
172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);

Line 174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);

170: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 2, p_system_rec.customer_id);
171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);
172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);

Line 175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);

171: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 3, p_system_rec.system_type_code,30);
172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);

Line 176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);

172: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 4, p_system_rec.system_number,30);
173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);

Line 177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);

173: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 5, p_system_rec.parent_system_id);
174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);

Line 178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);

174: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 6, p_system_rec.ship_to_contact_id);
175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);

Line 179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);

175: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 7, p_system_rec.bill_to_contact_id);
176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);

Line 180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);

176: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 8, p_system_rec.technical_contact_id);
177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);

Line 181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);

177: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 9, p_system_rec.service_admin_contact_id);
178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);

Line 182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);

178: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 10, p_system_rec.ship_to_site_use_id);
179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);

Line 183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);

179: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 11, p_system_rec.bill_to_site_use_id);
180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);

Line 184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);

180: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 12, p_system_rec.install_site_use_id);
181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);

Line 185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);

181: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 13, p_system_rec.coterminate_day_month,6);
182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);

Line 186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);

182: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 14, p_system_rec.autocreated_from_system_id);
183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);

Line 187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);

183: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 15, p_system_rec.start_date_active);
184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);

Line 188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);

184: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 16, p_system_rec.end_date_active);
185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);

Line 189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);

185: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 17, p_system_rec.context,30);
186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);

Line 190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);

186: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 18, p_system_rec.attribute1,240);
187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);

Line 191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);

187: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 19, p_system_rec.attribute2,240);
188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);

Line 192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);

188: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 20, p_system_rec.attribute3,240);
189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);

Line 193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);

189: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 21, p_system_rec.attribute4,240);
190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);

Line 194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);

190: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 22, p_system_rec.attribute5,240);
191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);

Line 195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);

191: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 23, p_system_rec.attribute6,240);
192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);

Line 196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);

192: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 24, p_system_rec.attribute7,240);
193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);
200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);

Line 197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);

193: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 25, p_system_rec.attribute8,240);
194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);
200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);
201: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 33, p_system_rec.object_version_number);

Line 198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);

194: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 26, p_system_rec.attribute9,240);
195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);
200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);
201: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 33, p_system_rec.object_version_number);
202: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 34, p_system_rec.operating_unit_id);

Line 199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);

195: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 27, p_system_rec.attribute10,240);
196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);
200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);
201: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 33, p_system_rec.object_version_number);
202: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 34, p_system_rec.operating_unit_id);
203: END define_columns;

Line 200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);

196: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 28, p_system_rec.attribute11,240);
197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);
200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);
201: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 33, p_system_rec.object_version_number);
202: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 34, p_system_rec.operating_unit_id);
203: END define_columns;
204:

Line 201: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 33, p_system_rec.object_version_number);

197: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 29, p_system_rec.attribute12,240);
198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);
200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);
201: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 33, p_system_rec.object_version_number);
202: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 34, p_system_rec.operating_unit_id);
203: END define_columns;
204:
205: PROCEDURE get_column_values(

Line 202: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 34, p_system_rec.operating_unit_id);

198: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 30, p_system_rec.attribute13,240);
199: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 31, p_system_rec.attribute14,240);
200: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 32, p_system_rec.attribute15,240);
201: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 33, p_system_rec.object_version_number);
202: DBMS_SQL.DEFINE_COLUMN(p_cur_get_systems, 34, p_system_rec.operating_unit_id);
203: END define_columns;
204:
205: PROCEDURE get_column_values(
206: p_cur_get_systems IN NUMBER,

Line 211: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 1, x_sys_rec.system_id);

207: x_sys_rec OUT NOCOPY csi_datastructures_pub.system_rec
208: )
209: IS
210: BEGIN
211: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 1, x_sys_rec.system_id);
212: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 2, x_sys_rec.customer_id);
213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);
214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);

Line 212: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 2, x_sys_rec.customer_id);

208: )
209: IS
210: BEGIN
211: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 1, x_sys_rec.system_id);
212: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 2, x_sys_rec.customer_id);
213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);
214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);

Line 213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);

209: IS
210: BEGIN
211: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 1, x_sys_rec.system_id);
212: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 2, x_sys_rec.customer_id);
213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);
214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);

Line 214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);

210: BEGIN
211: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 1, x_sys_rec.system_id);
212: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 2, x_sys_rec.customer_id);
213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);
214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);

Line 215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);

211: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 1, x_sys_rec.system_id);
212: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 2, x_sys_rec.customer_id);
213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);
214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);

Line 216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);

212: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 2, x_sys_rec.customer_id);
213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);
214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);

Line 217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);

213: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 3, x_sys_rec.system_type_code);
214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);

Line 218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);

214: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 4, x_sys_rec.system_number);
215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);

Line 219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);

215: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 5, x_sys_rec.parent_system_id);
216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);

Line 220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);

216: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 6, x_sys_rec.ship_to_contact_id);
217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);

Line 221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);

217: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 7, x_sys_rec.bill_to_contact_id);
218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);

Line 222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);

218: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 8, x_sys_rec.technical_contact_id);
219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);

Line 223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);

219: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 9, x_sys_rec.service_admin_contact_id);
220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);

Line 224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);

220: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 10, x_sys_rec.ship_to_site_use_id);
221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);

Line 225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);

221: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 11, x_sys_rec.bill_to_site_use_id);
222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);

Line 226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);

222: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 12, x_sys_rec.install_site_use_id);
223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);

Line 227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);

223: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 13, x_sys_rec.coterminate_day_month);
224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);

Line 228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);

224: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 14, x_sys_rec.autocreated_from_system_id);
225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);

Line 229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);

225: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 15, x_sys_rec.start_date_active);
226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);

Line 230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);

226: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 16, x_sys_rec.end_date_active);
227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);

Line 231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);

227: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 17, x_sys_rec.context);
228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);

Line 232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);

228: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 18, x_sys_rec.attribute1);
229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);

Line 233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);

229: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 19, x_sys_rec.attribute2);
230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);

Line 234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);

230: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 20, x_sys_rec.attribute3);
231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);

Line 235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);

231: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 21, x_sys_rec.attribute4);
232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);

Line 236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);

232: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 22, x_sys_rec.attribute5);
233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);

Line 237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);

233: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 23, x_sys_rec.attribute6);
234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);

Line 238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);

234: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 24, x_sys_rec.attribute7);
235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);
242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);

Line 239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);

235: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 25, x_sys_rec.attribute8);
236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);
242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);
243: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 33, x_sys_rec.object_version_number);

Line 240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);

236: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 26, x_sys_rec.attribute9);
237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);
242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);
243: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 33, x_sys_rec.object_version_number);
244: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 34, x_sys_rec.operating_unit_id);

Line 241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);

237: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 27, x_sys_rec.attribute10);
238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);
242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);
243: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 33, x_sys_rec.object_version_number);
244: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 34, x_sys_rec.operating_unit_id);
245:

Line 242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);

238: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 28, x_sys_rec.attribute11);
239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);
242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);
243: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 33, x_sys_rec.object_version_number);
244: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 34, x_sys_rec.operating_unit_id);
245:
246: END get_column_values;

Line 243: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 33, x_sys_rec.object_version_number);

239: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 29, x_sys_rec.attribute12);
240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);
242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);
243: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 33, x_sys_rec.object_version_number);
244: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 34, x_sys_rec.operating_unit_id);
245:
246: END get_column_values;
247:

Line 244: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 34, x_sys_rec.operating_unit_id);

240: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 30, x_sys_rec.attribute13);
241: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 31, x_sys_rec.attribute14);
242: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 32, x_sys_rec.attribute15);
243: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 33, x_sys_rec.object_version_number);
244: DBMS_SQL.COLUMN_VALUE(p_cur_get_systems, 34, x_sys_rec.operating_unit_id);
245:
246: END get_column_values;
247:
248:

Line 260: dbms_sql.bind_variable(p_cur_get_systems, 'system_id', p_system_query_rec.system_id);

256:
257:
258: IF( (p_system_query_rec.system_id IS NOT NULL) AND (p_system_query_rec.system_id <> fnd_api.g_miss_num) )
259: THEN
260: dbms_sql.bind_variable(p_cur_get_systems, 'system_id', p_system_query_rec.system_id);
261: END IF;
262:
263: IF( (p_system_query_rec.system_type_code IS NOT NULL) AND (p_system_query_rec.system_type_code <> fnd_api.g_miss_char) )
264: THEN

Line 265: dbms_sql.bind_variable(p_cur_get_systems, 'system_type_code', p_system_query_rec.system_type_code);

261: END IF;
262:
263: IF( (p_system_query_rec.system_type_code IS NOT NULL) AND (p_system_query_rec.system_type_code <> fnd_api.g_miss_char) )
264: THEN
265: dbms_sql.bind_variable(p_cur_get_systems, 'system_type_code', p_system_query_rec.system_type_code);
266: END IF;
267:
268: IF( (p_system_query_rec.system_number IS NOT NULL) AND (p_system_query_rec.system_number <> fnd_api.g_miss_char) )
269: THEN

Line 270: dbms_sql.bind_variable(p_cur_get_systems, 'system_number', p_system_query_rec.system_number);

266: END IF;
267:
268: IF( (p_system_query_rec.system_number IS NOT NULL) AND (p_system_query_rec.system_number <> fnd_api.g_miss_char) )
269: THEN
270: dbms_sql.bind_variable(p_cur_get_systems, 'system_number', p_system_query_rec.system_number);
271: END IF;
272:
273: END bind;
274:

Line 1000: IF dbms_sql.is_open(l_cur_get_systems) THEN

996: gen_select(l_crit_systems_rec,l_select_cl);
997:
998:
999: gen_systems_where(l_crit_systems_rec,l_active_systems_only, l_systems_where);
1000: IF dbms_sql.is_open(l_cur_get_systems) THEN
1001: dbms_sql.close_CURSOR(l_cur_get_systems);
1002: END IF;
1003:
1004: l_cur_get_systems := dbms_sql.open_CURSOR;

Line 1001: dbms_sql.close_CURSOR(l_cur_get_systems);

997:
998:
999: gen_systems_where(l_crit_systems_rec,l_active_systems_only, l_systems_where);
1000: IF dbms_sql.is_open(l_cur_get_systems) THEN
1001: dbms_sql.close_CURSOR(l_cur_get_systems);
1002: END IF;
1003:
1004: l_cur_get_systems := dbms_sql.open_CURSOR;
1005:

Line 1004: l_cur_get_systems := dbms_sql.open_CURSOR;

1000: IF dbms_sql.is_open(l_cur_get_systems) THEN
1001: dbms_sql.close_CURSOR(l_cur_get_systems);
1002: END IF;
1003:
1004: l_cur_get_systems := dbms_sql.open_CURSOR;
1005:
1006: dbms_sql.parse(l_cur_get_systems, l_select_cl||l_systems_where , dbms_sql.native);
1007:
1008: bind(l_crit_systems_rec, l_cur_get_systems);

Line 1006: dbms_sql.parse(l_cur_get_systems, l_select_cl||l_systems_where , dbms_sql.native);

1002: END IF;
1003:
1004: l_cur_get_systems := dbms_sql.open_CURSOR;
1005:
1006: dbms_sql.parse(l_cur_get_systems, l_select_cl||l_systems_where , dbms_sql.native);
1007:
1008: bind(l_crit_systems_rec, l_cur_get_systems);
1009:
1010: define_columns(l_def_systems_rec, l_cur_get_systems);

Line 1012: l_ignore := dbms_sql.execute(l_cur_get_systems);

1008: bind(l_crit_systems_rec, l_cur_get_systems);
1009:
1010: define_columns(l_def_systems_rec, l_cur_get_systems);
1011:
1012: l_ignore := dbms_sql.execute(l_cur_get_systems);
1013: --
1014: -- Get the last purge date from csi_item_instances table
1015: --
1016: BEGIN

Line 1029: IF((dbms_sql.fetch_rows(l_cur_get_systems)>0) AND ( (l_returned_rec_count

1025: NULL;
1026: END;
1027: --
1028: LOOP
1029: IF((dbms_sql.fetch_rows(l_cur_get_systems)>0) AND ( (l_returned_rec_count 1030: THEN
1031:
1032: get_column_values(l_cur_get_systems, l_sys_rec);
1033:

Line 1083: dbms_sql.close_cursor(l_cur_get_systems);

1079: x_systems_tbl := l_systems_tbl;
1080: END IF;
1081: -- END of api body
1082: --
1083: dbms_sql.close_cursor(l_cur_get_systems);
1084:
1085: -- standard call to get message count and if count is 1, get message info.
1086: fnd_msg_pub.count_and_get
1087: ( p_count => x_msg_count,

Line 5632: IF dbms_sql.is_open(l_cur_get_systems) THEN

5628: gen_select(l_crit_systems_rec,l_select_cl);
5629:
5630:
5631: gen_systems_where(l_crit_systems_rec,l_active_systems_only, l_systems_where);
5632: IF dbms_sql.is_open(l_cur_get_systems) THEN
5633: dbms_sql.close_CURSOR(l_cur_get_systems);
5634: END IF;
5635:
5636: l_cur_get_systems := dbms_sql.open_CURSOR;

Line 5633: dbms_sql.close_CURSOR(l_cur_get_systems);

5629:
5630:
5631: gen_systems_where(l_crit_systems_rec,l_active_systems_only, l_systems_where);
5632: IF dbms_sql.is_open(l_cur_get_systems) THEN
5633: dbms_sql.close_CURSOR(l_cur_get_systems);
5634: END IF;
5635:
5636: l_cur_get_systems := dbms_sql.open_CURSOR;
5637:

Line 5636: l_cur_get_systems := dbms_sql.open_CURSOR;

5632: IF dbms_sql.is_open(l_cur_get_systems) THEN
5633: dbms_sql.close_CURSOR(l_cur_get_systems);
5634: END IF;
5635:
5636: l_cur_get_systems := dbms_sql.open_CURSOR;
5637:
5638: dbms_sql.parse(l_cur_get_systems, l_select_cl||l_systems_where , dbms_sql.native);
5639:
5640: bind(l_crit_systems_rec, l_cur_get_systems);

Line 5638: dbms_sql.parse(l_cur_get_systems, l_select_cl||l_systems_where , dbms_sql.native);

5634: END IF;
5635:
5636: l_cur_get_systems := dbms_sql.open_CURSOR;
5637:
5638: dbms_sql.parse(l_cur_get_systems, l_select_cl||l_systems_where , dbms_sql.native);
5639:
5640: bind(l_crit_systems_rec, l_cur_get_systems);
5641:
5642: define_columns(l_def_systems_rec, l_cur_get_systems);

Line 5644: l_ignore := dbms_sql.execute(l_cur_get_systems);

5640: bind(l_crit_systems_rec, l_cur_get_systems);
5641:
5642: define_columns(l_def_systems_rec, l_cur_get_systems);
5643:
5644: l_ignore := dbms_sql.execute(l_cur_get_systems);
5645: --
5646: -- Get the last purge date from csi_item_instances table
5647: --
5648: BEGIN

Line 5661: IF((dbms_sql.fetch_rows(l_cur_get_systems)>0) AND ( (l_returned_rec_count

5657: NULL;
5658: END;
5659: --
5660: LOOP
5661: IF((dbms_sql.fetch_rows(l_cur_get_systems)>0) AND ( (l_returned_rec_count 5662: THEN
5663:
5664: get_column_values(l_cur_get_systems, l_sys_rec);
5665:

Line 5699: dbms_sql.close_cursor(l_cur_get_systems);

5695: END LOOP;
5696: --
5697: -- END of api body
5698: --
5699: dbms_sql.close_cursor(l_cur_get_systems);
5700: --
5701: IF l_systems_tbl.count > 0 THEN
5702: FOR sys_row IN l_systems_tbl.FIRST .. l_systems_tbl.LAST
5703: LOOP