APPS.CSI_T_TXN_DETAILS_PVT dependencies on DBMS_SQL

Line 67: l_cursor_id := dbms_sql.open_cursor;

63: IF l_debug_level > 10 THEN
64: csi_t_gen_utility_pvt.add(' Select Stmt:'||l_select_stmt);
65: END IF;
66:
67: l_cursor_id := dbms_sql.open_cursor;
68:
69: dbms_sql.parse(l_cursor_id, l_select_stmt , dbms_sql.native);
70:
71: IF nvl(l_txn_line_query_rec.transaction_line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

Line 69: dbms_sql.parse(l_cursor_id, l_select_stmt , dbms_sql.native);

65: END IF;
66:
67: l_cursor_id := dbms_sql.open_cursor;
68:
69: dbms_sql.parse(l_cursor_id, l_select_stmt , dbms_sql.native);
70:
71: IF nvl(l_txn_line_query_rec.transaction_line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
72: THEN
73: dbms_sql.bind_variable(l_cursor_id, 'transaction_line_id',

Line 73: dbms_sql.bind_variable(l_cursor_id, 'transaction_line_id',

69: dbms_sql.parse(l_cursor_id, l_select_stmt , dbms_sql.native);
70:
71: IF nvl(l_txn_line_query_rec.transaction_line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
72: THEN
73: dbms_sql.bind_variable(l_cursor_id, 'transaction_line_id',
74: l_txn_line_query_rec.transaction_line_id);
75: END IF;
76:
77: IF nvl(l_txn_line_query_rec.source_txn_header_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num

Line 79: dbms_sql.bind_variable(l_cursor_id, 'source_txn_header_id',

75: END IF;
76:
77: IF nvl(l_txn_line_query_rec.source_txn_header_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
78: THEN
79: dbms_sql.bind_variable(l_cursor_id, 'source_txn_header_id',
80: l_txn_line_query_rec.source_txn_header_id);
81: END IF;
82:
83: IF nvl(l_txn_line_query_rec.source_transaction_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num

Line 85: dbms_sql.bind_variable(l_cursor_id, 'source_transaction_id',

81: END IF;
82:
83: IF nvl(l_txn_line_query_rec.source_transaction_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
84: THEN
85: dbms_sql.bind_variable(l_cursor_id, 'source_transaction_id',
86: l_txn_line_query_rec.source_transaction_id);
87: END IF;
88:
89: IF nvl(l_txn_line_query_rec.source_transaction_table, fnd_api.g_miss_char) <> fnd_api.g_miss_char

Line 91: dbms_sql.bind_variable(l_cursor_id, 'source_transaction_table',

87: END IF;
88:
89: IF nvl(l_txn_line_query_rec.source_transaction_table, fnd_api.g_miss_char) <> fnd_api.g_miss_char
90: THEN
91: dbms_sql.bind_variable(l_cursor_id, 'source_transaction_table',
92: l_txn_line_query_rec.source_transaction_table);
93: END IF;
94:
95: IF nvl(l_txn_line_query_rec.processing_status, fnd_api.g_miss_char) <> fnd_api.g_miss_char

Line 97: dbms_sql.bind_variable(l_cursor_id, 'processing_status',

93: END IF;
94:
95: IF nvl(l_txn_line_query_rec.processing_status, fnd_api.g_miss_char) <> fnd_api.g_miss_char
96: THEN
97: dbms_sql.bind_variable(l_cursor_id, 'processing_status',
98: l_txn_line_query_rec.processing_status);
99: END IF;
100:
101: dbms_sql.define_column(l_cursor_id,1,l_value);

Line 101: dbms_sql.define_column(l_cursor_id,1,l_value);

97: dbms_sql.bind_variable(l_cursor_id, 'processing_status',
98: l_txn_line_query_rec.processing_status);
99: END IF;
100:
101: dbms_sql.define_column(l_cursor_id,1,l_value);
102:
103: l_processed_rows := dbms_sql.execute(l_cursor_id);
104:
105: LOOP

Line 103: l_processed_rows := dbms_sql.execute(l_cursor_id);

99: END IF;
100:
101: dbms_sql.define_column(l_cursor_id,1,l_value);
102:
103: l_processed_rows := dbms_sql.execute(l_cursor_id);
104:
105: LOOP
106: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
107: l_found := TRUE;

Line 106: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;

102:
103: l_processed_rows := dbms_sql.execute(l_cursor_id);
104:
105: LOOP
106: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
107: l_found := TRUE;
108: dbms_sql.column_value(l_cursor_id,1,l_value);
109: END LOOP;
110:

Line 108: dbms_sql.column_value(l_cursor_id,1,l_value);

104:
105: LOOP
106: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
107: l_found := TRUE;
108: dbms_sql.column_value(l_cursor_id,1,l_value);
109: END LOOP;
110:
111: dbms_sql.close_cursor(l_cursor_id);
112:

Line 111: dbms_sql.close_cursor(l_cursor_id);

107: l_found := TRUE;
108: dbms_sql.column_value(l_cursor_id,1,l_value);
109: END LOOP;
110:
111: dbms_sql.close_cursor(l_cursor_id);
112:
113: END IF;
114:
115: csi_t_gen_utility_pvt.set_debug_off;

Line 128: IF dbms_sql.is_open(l_cursor_id) THEN

124:
125: EXCEPTION
126: WHEN others THEN
127:
128: IF dbms_sql.is_open(l_cursor_id) THEN
129: dbms_sql.close_cursor(l_cursor_id);
130: END IF;
131: return false;
132:

Line 129: dbms_sql.close_cursor(l_cursor_id);

125: EXCEPTION
126: WHEN others THEN
127:
128: IF dbms_sql.is_open(l_cursor_id) THEN
129: dbms_sql.close_cursor(l_cursor_id);
130: END IF;
131: return false;
132:
133: END check_txn_details_exist;

Line 2262: l_sys_cur_id := dbms_sql.open_cursor;

2258: 'where transaction_system_id in '||p_txn_system_id_list;
2259:
2260: --csi_t_gen_utility_pvt.add(l_select_stmt);
2261:
2262: l_sys_cur_id := dbms_sql.open_cursor;
2263:
2264: dbms_sql.parse(l_sys_cur_id, l_select_stmt , dbms_sql.native);
2265:
2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);

Line 2264: dbms_sql.parse(l_sys_cur_id, l_select_stmt , dbms_sql.native);

2260: --csi_t_gen_utility_pvt.add(l_select_stmt);
2261:
2262: l_sys_cur_id := dbms_sql.open_cursor;
2263:
2264: dbms_sql.parse(l_sys_cur_id, l_select_stmt , dbms_sql.native);
2265:
2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);
2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);
2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);

Line 2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);

2262: l_sys_cur_id := dbms_sql.open_cursor;
2263:
2264: dbms_sql.parse(l_sys_cur_id, l_select_stmt , dbms_sql.native);
2265:
2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);
2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);
2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);
2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);

Line 2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);

2263:
2264: dbms_sql.parse(l_sys_cur_id, l_select_stmt , dbms_sql.native);
2265:
2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);
2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);
2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);
2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);

Line 2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);

2264: dbms_sql.parse(l_sys_cur_id, l_select_stmt , dbms_sql.native);
2265:
2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);
2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);
2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);
2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);

Line 2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);

2265:
2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);
2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);
2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);
2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);

Line 2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);

2266: dbms_sql.define_column(l_sys_cur_id,1,l_sys_rec.transaction_system_id);
2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);
2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);
2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);

Line 2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);

2267: dbms_sql.define_column(l_sys_cur_id,2,l_sys_rec.transaction_line_id);
2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);
2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);

Line 2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);

2268: dbms_sql.define_column(l_sys_cur_id,3,l_sys_rec.system_name,50);
2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);

Line 2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);

2269: dbms_sql.define_column(l_sys_cur_id,4,l_sys_rec.description,240);
2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);

Line 2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);

2270: dbms_sql.define_column(l_sys_cur_id,5,l_sys_rec.system_type_code,30);
2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);

Line 2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);

2271: dbms_sql.define_column(l_sys_cur_id,6,l_sys_rec.system_number,30);
2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);

Line 2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);

2272: dbms_sql.define_column(l_sys_cur_id,7,l_sys_rec.customer_id);
2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);

Line 2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);

2273: dbms_sql.define_column(l_sys_cur_id,8,l_sys_rec.bill_to_contact_id);
2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);

Line 2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);

2274: dbms_sql.define_column(l_sys_cur_id,9,l_sys_rec.ship_to_contact_id);
2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);

Line 2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);

2275: dbms_sql.define_column(l_sys_cur_id,10,l_sys_rec.technical_contact_id);
2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);

Line 2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);

2276: dbms_sql.define_column(l_sys_cur_id,11,l_sys_rec.service_admin_contact_id);
2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);

Line 2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);

2277: dbms_sql.define_column(l_sys_cur_id,12,l_sys_rec.ship_to_site_use_id);
2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);

Line 2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);

2278: dbms_sql.define_column(l_sys_cur_id,13,l_sys_rec.bill_to_site_use_id);
2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);

Line 2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);

2279: dbms_sql.define_column(l_sys_cur_id,14,l_sys_rec.install_site_use_id);
2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);

Line 2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);

2280: dbms_sql.define_column(l_sys_cur_id,15,l_sys_rec.coterminate_day_month,6);
2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);

Line 2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);

2281: dbms_sql.define_column(l_sys_cur_id,16,l_sys_rec.config_system_type,30);
2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);

Line 2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);

2282: dbms_sql.define_column(l_sys_cur_id,17,l_sys_rec.context,30);
2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);

Line 2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);

2283: dbms_sql.define_column(l_sys_cur_id,18,l_sys_rec.attribute1,150);
2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);

Line 2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);

2284: dbms_sql.define_column(l_sys_cur_id,19,l_sys_rec.attribute2,150);
2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);

Line 2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);

2285: dbms_sql.define_column(l_sys_cur_id,20,l_sys_rec.attribute3,150);
2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);

Line 2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);

2286: dbms_sql.define_column(l_sys_cur_id,21,l_sys_rec.attribute4,150);
2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);

Line 2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);

2287: dbms_sql.define_column(l_sys_cur_id,22,l_sys_rec.attribute5,150);
2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);

Line 2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);

2288: dbms_sql.define_column(l_sys_cur_id,23,l_sys_rec.attribute6,150);
2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);
2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);

Line 2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);

2289: dbms_sql.define_column(l_sys_cur_id,24,l_sys_rec.attribute7,150);
2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);
2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);
2297: dbms_sql.define_column(l_sys_cur_id,32,l_sys_rec.attribute15,150);

Line 2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);

2290: dbms_sql.define_column(l_sys_cur_id,25,l_sys_rec.attribute8,150);
2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);
2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);
2297: dbms_sql.define_column(l_sys_cur_id,32,l_sys_rec.attribute15,150);
2298: dbms_sql.define_column(l_sys_cur_id,33,l_sys_rec.object_version_number);

Line 2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);

2291: dbms_sql.define_column(l_sys_cur_id,26,l_sys_rec.attribute9,150);
2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);
2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);
2297: dbms_sql.define_column(l_sys_cur_id,32,l_sys_rec.attribute15,150);
2298: dbms_sql.define_column(l_sys_cur_id,33,l_sys_rec.object_version_number);
2299:

Line 2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);

2292: dbms_sql.define_column(l_sys_cur_id,27,l_sys_rec.attribute10,150);
2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);
2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);
2297: dbms_sql.define_column(l_sys_cur_id,32,l_sys_rec.attribute15,150);
2298: dbms_sql.define_column(l_sys_cur_id,33,l_sys_rec.object_version_number);
2299:
2300: l_ind := 0;

Line 2297: dbms_sql.define_column(l_sys_cur_id,32,l_sys_rec.attribute15,150);

2293: dbms_sql.define_column(l_sys_cur_id,28,l_sys_rec.attribute11,150);
2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);
2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);
2297: dbms_sql.define_column(l_sys_cur_id,32,l_sys_rec.attribute15,150);
2298: dbms_sql.define_column(l_sys_cur_id,33,l_sys_rec.object_version_number);
2299:
2300: l_ind := 0;
2301:

Line 2298: dbms_sql.define_column(l_sys_cur_id,33,l_sys_rec.object_version_number);

2294: dbms_sql.define_column(l_sys_cur_id,29,l_sys_rec.attribute12,150);
2295: dbms_sql.define_column(l_sys_cur_id,30,l_sys_rec.attribute13,150);
2296: dbms_sql.define_column(l_sys_cur_id,31,l_sys_rec.attribute14,150);
2297: dbms_sql.define_column(l_sys_cur_id,32,l_sys_rec.attribute15,150);
2298: dbms_sql.define_column(l_sys_cur_id,33,l_sys_rec.object_version_number);
2299:
2300: l_ind := 0;
2301:
2302: l_processed_rows := dbms_sql.execute(l_sys_cur_id);

Line 2302: l_processed_rows := dbms_sql.execute(l_sys_cur_id);

2298: dbms_sql.define_column(l_sys_cur_id,33,l_sys_rec.object_version_number);
2299:
2300: l_ind := 0;
2301:
2302: l_processed_rows := dbms_sql.execute(l_sys_cur_id);
2303: LOOP
2304: exit when dbms_sql.fetch_rows(l_sys_cur_id) = 0;
2305:
2306: l_ind := l_ind + 1;

Line 2304: exit when dbms_sql.fetch_rows(l_sys_cur_id) = 0;

2300: l_ind := 0;
2301:
2302: l_processed_rows := dbms_sql.execute(l_sys_cur_id);
2303: LOOP
2304: exit when dbms_sql.fetch_rows(l_sys_cur_id) = 0;
2305:
2306: l_ind := l_ind + 1;
2307:
2308: dbms_sql.column_value(l_sys_cur_id,1, x_txn_systems_tbl(l_ind).transaction_system_id);

Line 2308: dbms_sql.column_value(l_sys_cur_id,1, x_txn_systems_tbl(l_ind).transaction_system_id);

2304: exit when dbms_sql.fetch_rows(l_sys_cur_id) = 0;
2305:
2306: l_ind := l_ind + 1;
2307:
2308: dbms_sql.column_value(l_sys_cur_id,1, x_txn_systems_tbl(l_ind).transaction_system_id);
2309: dbms_sql.column_value(l_sys_cur_id,2, x_txn_systems_tbl(l_ind).transaction_line_id);
2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);
2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);

Line 2309: dbms_sql.column_value(l_sys_cur_id,2, x_txn_systems_tbl(l_ind).transaction_line_id);

2305:
2306: l_ind := l_ind + 1;
2307:
2308: dbms_sql.column_value(l_sys_cur_id,1, x_txn_systems_tbl(l_ind).transaction_system_id);
2309: dbms_sql.column_value(l_sys_cur_id,2, x_txn_systems_tbl(l_ind).transaction_line_id);
2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);
2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);

Line 2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);

2306: l_ind := l_ind + 1;
2307:
2308: dbms_sql.column_value(l_sys_cur_id,1, x_txn_systems_tbl(l_ind).transaction_system_id);
2309: dbms_sql.column_value(l_sys_cur_id,2, x_txn_systems_tbl(l_ind).transaction_line_id);
2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);
2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);

Line 2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);

2307:
2308: dbms_sql.column_value(l_sys_cur_id,1, x_txn_systems_tbl(l_ind).transaction_system_id);
2309: dbms_sql.column_value(l_sys_cur_id,2, x_txn_systems_tbl(l_ind).transaction_line_id);
2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);
2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);

Line 2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);

2308: dbms_sql.column_value(l_sys_cur_id,1, x_txn_systems_tbl(l_ind).transaction_system_id);
2309: dbms_sql.column_value(l_sys_cur_id,2, x_txn_systems_tbl(l_ind).transaction_line_id);
2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);
2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);

Line 2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);

2309: dbms_sql.column_value(l_sys_cur_id,2, x_txn_systems_tbl(l_ind).transaction_line_id);
2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);
2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);

Line 2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);

2310: dbms_sql.column_value(l_sys_cur_id,3, x_txn_systems_tbl(l_ind).system_name);
2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);

Line 2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);

2311: dbms_sql.column_value(l_sys_cur_id,4, x_txn_systems_tbl(l_ind).description);
2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);

Line 2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);

2312: dbms_sql.column_value(l_sys_cur_id,5, x_txn_systems_tbl(l_ind).system_type_code);
2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);

Line 2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);

2313: dbms_sql.column_value(l_sys_cur_id,6, x_txn_systems_tbl(l_ind).system_number);
2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);

Line 2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);

2314: dbms_sql.column_value(l_sys_cur_id,7, x_txn_systems_tbl(l_ind).customer_id);
2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);

Line 2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);

2315: dbms_sql.column_value(l_sys_cur_id,8, x_txn_systems_tbl(l_ind).bill_to_contact_id);
2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);

Line 2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);

2316: dbms_sql.column_value(l_sys_cur_id,9, x_txn_systems_tbl(l_ind).ship_to_contact_id);
2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);

Line 2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);

2317: dbms_sql.column_value(l_sys_cur_id,10, x_txn_systems_tbl(l_ind).technical_contact_id);
2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);

Line 2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);

2318: dbms_sql.column_value(l_sys_cur_id,11, x_txn_systems_tbl(l_ind).service_admin_contact_id);
2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);

Line 2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);

2319: dbms_sql.column_value(l_sys_cur_id,12, x_txn_systems_tbl(l_ind).ship_to_site_use_id);
2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);

Line 2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);

2320: dbms_sql.column_value(l_sys_cur_id,13, x_txn_systems_tbl(l_ind).bill_to_site_use_id);
2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);

Line 2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);

2321: dbms_sql.column_value(l_sys_cur_id,14, x_txn_systems_tbl(l_ind).install_site_use_id);
2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);

Line 2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);

2322: dbms_sql.column_value(l_sys_cur_id,15, x_txn_systems_tbl(l_ind).coterminate_day_month);
2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);

Line 2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);

2323: dbms_sql.column_value(l_sys_cur_id,16, x_txn_systems_tbl(l_ind).config_system_type);
2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);

Line 2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);

2324: dbms_sql.column_value(l_sys_cur_id,17, x_txn_systems_tbl(l_ind).context);
2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);

Line 2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);

2325: dbms_sql.column_value(l_sys_cur_id,18, x_txn_systems_tbl(l_ind).attribute1);
2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);

Line 2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);

2326: dbms_sql.column_value(l_sys_cur_id,19, x_txn_systems_tbl(l_ind).attribute2);
2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);

Line 2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);

2327: dbms_sql.column_value(l_sys_cur_id,20, x_txn_systems_tbl(l_ind).attribute3);
2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);

Line 2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);

2328: dbms_sql.column_value(l_sys_cur_id,21, x_txn_systems_tbl(l_ind).attribute4);
2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);

Line 2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);

2329: dbms_sql.column_value(l_sys_cur_id,22, x_txn_systems_tbl(l_ind).attribute5);
2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);

Line 2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);

2330: dbms_sql.column_value(l_sys_cur_id,23, x_txn_systems_tbl(l_ind).attribute6);
2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);
2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);

Line 2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);

2331: dbms_sql.column_value(l_sys_cur_id,24, x_txn_systems_tbl(l_ind).attribute7);
2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);
2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);
2339: dbms_sql.column_value(l_sys_cur_id,32, x_txn_systems_tbl(l_ind).attribute15);

Line 2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);

2332: dbms_sql.column_value(l_sys_cur_id,25, x_txn_systems_tbl(l_ind).attribute8);
2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);
2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);
2339: dbms_sql.column_value(l_sys_cur_id,32, x_txn_systems_tbl(l_ind).attribute15);
2340: dbms_sql.column_value(l_sys_cur_id,33, x_txn_systems_tbl(l_ind).object_version_number);

Line 2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);

2333: dbms_sql.column_value(l_sys_cur_id,26, x_txn_systems_tbl(l_ind).attribute9);
2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);
2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);
2339: dbms_sql.column_value(l_sys_cur_id,32, x_txn_systems_tbl(l_ind).attribute15);
2340: dbms_sql.column_value(l_sys_cur_id,33, x_txn_systems_tbl(l_ind).object_version_number);
2341:

Line 2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);

2334: dbms_sql.column_value(l_sys_cur_id,27, x_txn_systems_tbl(l_ind).attribute10);
2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);
2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);
2339: dbms_sql.column_value(l_sys_cur_id,32, x_txn_systems_tbl(l_ind).attribute15);
2340: dbms_sql.column_value(l_sys_cur_id,33, x_txn_systems_tbl(l_ind).object_version_number);
2341:
2342: END LOOP;

Line 2339: dbms_sql.column_value(l_sys_cur_id,32, x_txn_systems_tbl(l_ind).attribute15);

2335: dbms_sql.column_value(l_sys_cur_id,28, x_txn_systems_tbl(l_ind).attribute11);
2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);
2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);
2339: dbms_sql.column_value(l_sys_cur_id,32, x_txn_systems_tbl(l_ind).attribute15);
2340: dbms_sql.column_value(l_sys_cur_id,33, x_txn_systems_tbl(l_ind).object_version_number);
2341:
2342: END LOOP;
2343:

Line 2340: dbms_sql.column_value(l_sys_cur_id,33, x_txn_systems_tbl(l_ind).object_version_number);

2336: dbms_sql.column_value(l_sys_cur_id,29, x_txn_systems_tbl(l_ind).attribute12);
2337: dbms_sql.column_value(l_sys_cur_id,30, x_txn_systems_tbl(l_ind).attribute13);
2338: dbms_sql.column_value(l_sys_cur_id,31, x_txn_systems_tbl(l_ind).attribute14);
2339: dbms_sql.column_value(l_sys_cur_id,32, x_txn_systems_tbl(l_ind).attribute15);
2340: dbms_sql.column_value(l_sys_cur_id,33, x_txn_systems_tbl(l_ind).object_version_number);
2341:
2342: END LOOP;
2343:
2344: dbms_sql.close_cursor(l_sys_cur_id);

Line 2344: dbms_sql.close_cursor(l_sys_cur_id);

2340: dbms_sql.column_value(l_sys_cur_id,33, x_txn_systems_tbl(l_ind).object_version_number);
2341:
2342: END LOOP;
2343:
2344: dbms_sql.close_cursor(l_sys_cur_id);
2345:
2346: EXCEPTION
2347: WHEN others THEN
2348:

Line 2351: IF dbms_sql.is_open(l_sys_cur_id) THEN

2347: WHEN others THEN
2348:
2349: csi_t_gen_utility_pvt.add(sqlerrm);
2350:
2351: IF dbms_sql.is_open(l_sys_cur_id) THEN
2352: dbms_sql.close_cursor(l_sys_cur_id);
2353: END IF;
2354:
2355: END get_txn_systems;

Line 2352: dbms_sql.close_cursor(l_sys_cur_id);

2348:
2349: csi_t_gen_utility_pvt.add(sqlerrm);
2350:
2351: IF dbms_sql.is_open(l_sys_cur_id) THEN
2352: dbms_sql.close_cursor(l_sys_cur_id);
2353: END IF;
2354:
2355: END get_txn_systems;
2356: