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.PN_EXP_TO_EAM_PVT dependencies on DBMS_SQL

Line 79: l_cursor := dbms_sql.open_cursor;

75: pnp_debug_pkg.log('EAM is not installed ...');
76: RETURN;
77: END IF;
78:
79: l_cursor := dbms_sql.open_cursor;
80: l_query :=
81: 'SELECT location_id,'
82: || 'parent_location_id,'
83: || 'location_code,'

Line 141: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);

137: l_query := l_query || ' ORDER BY location_id ';
138: l_info := 'Figuring out the max id number in the mtl_eam_asset_num_interface ';
139: pnp_debug_pkg.log(l_info);
140:
141: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
142:
143: IF p_locn_type IS NOT NULL THEN
144: dbms_sql.bind_variable
145: (l_cursor,'l_locn_type',l_locn_type );

Line 144: dbms_sql.bind_variable

140:
141: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
142:
143: IF p_locn_type IS NOT NULL THEN
144: dbms_sql.bind_variable
145: (l_cursor,'l_locn_type',l_locn_type );
146: END IF;
147:
148: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN

Line 149: dbms_sql.bind_variable

145: (l_cursor,'l_locn_type',l_locn_type );
146: END IF;
147:
148: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
149: dbms_sql.bind_variable
150: (l_cursor,'l_locn_code_from',l_locn_code_from );
151: dbms_sql.bind_variable
152: (l_cursor,'l_locn_code_to',l_locn_code_to );
153: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN

Line 151: dbms_sql.bind_variable

147:
148: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
149: dbms_sql.bind_variable
150: (l_cursor,'l_locn_code_from',l_locn_code_from );
151: dbms_sql.bind_variable
152: (l_cursor,'l_locn_code_to',l_locn_code_to );
153: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
154: dbms_sql.bind_variable
155: (l_cursor,'l_locn_code_from',l_locn_code_from );

Line 154: dbms_sql.bind_variable

150: (l_cursor,'l_locn_code_from',l_locn_code_from );
151: dbms_sql.bind_variable
152: (l_cursor,'l_locn_code_to',l_locn_code_to );
153: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
154: dbms_sql.bind_variable
155: (l_cursor,'l_locn_code_from',l_locn_code_from );
156: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
157: dbms_sql.bind_variable
158: (l_cursor,'l_locn_code_to',l_locn_code_to );

Line 157: dbms_sql.bind_variable

153: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
154: dbms_sql.bind_variable
155: (l_cursor,'l_locn_code_from',l_locn_code_from );
156: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
157: dbms_sql.bind_variable
158: (l_cursor,'l_locn_code_to',l_locn_code_to );
159: END IF;
160:
161: IF p_locn_code_to IS NOT NULL THEN

Line 162: dbms_sql.bind_variable

158: (l_cursor,'l_locn_code_to',l_locn_code_to );
159: END IF;
160:
161: IF p_locn_code_to IS NOT NULL THEN
162: dbms_sql.bind_variable
163: (l_cursor,'l_locn_code_to',l_locn_code_to );
164: END IF;
165:
166: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);

Line 166: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);

162: dbms_sql.bind_variable
163: (l_cursor,'l_locn_code_to',l_locn_code_to );
164: END IF;
165:
166: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
167: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);
170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);

Line 167: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);

163: (l_cursor,'l_locn_code_to',l_locn_code_to );
164: END IF;
165:
166: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
167: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);
170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);
171: dbms_sql.define_column (l_cursor, 6,location_rec.active_end_date);

Line 168: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);

164: END IF;
165:
166: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
167: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);
170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);
171: dbms_sql.define_column (l_cursor, 6,location_rec.active_end_date);
172:

Line 169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);

165:
166: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
167: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);
170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);
171: dbms_sql.define_column (l_cursor, 6,location_rec.active_end_date);
172:
173: l_rows := dbms_sql.execute(l_cursor);

Line 170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);

166: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
167: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);
170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);
171: dbms_sql.define_column (l_cursor, 6,location_rec.active_end_date);
172:
173: l_rows := dbms_sql.execute(l_cursor);
174:

Line 171: dbms_sql.define_column (l_cursor, 6,location_rec.active_end_date);

167: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);
170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);
171: dbms_sql.define_column (l_cursor, 6,location_rec.active_end_date);
172:
173: l_rows := dbms_sql.execute(l_cursor);
174:
175: LOOP

Line 173: l_rows := dbms_sql.execute(l_cursor);

169: dbms_sql.define_column (l_cursor, 4,l_parent_instance_number,30);
170: dbms_sql.define_column (l_cursor, 5,location_rec.active_start_date);
171: dbms_sql.define_column (l_cursor, 6,location_rec.active_end_date);
172:
173: l_rows := dbms_sql.execute(l_cursor);
174:
175: LOOP
176: l_count := dbms_sql.fetch_rows( l_cursor );
177: EXIT WHEN l_count <> 1;

Line 176: l_count := dbms_sql.fetch_rows( l_cursor );

172:
173: l_rows := dbms_sql.execute(l_cursor);
174:
175: LOOP
176: l_count := dbms_sql.fetch_rows( l_cursor );
177: EXIT WHEN l_count <> 1;
178:
179: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);

Line 179: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);

175: LOOP
176: l_count := dbms_sql.fetch_rows( l_cursor );
177: EXIT WHEN l_count <> 1;
178:
179: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
181: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
182: dbms_sql.column_value (l_cursor, 4,l_parent_instance_number);
183: dbms_sql.column_value (l_cursor, 5,location_rec.active_start_date);

Line 180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);

176: l_count := dbms_sql.fetch_rows( l_cursor );
177: EXIT WHEN l_count <> 1;
178:
179: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
181: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
182: dbms_sql.column_value (l_cursor, 4,l_parent_instance_number);
183: dbms_sql.column_value (l_cursor, 5,location_rec.active_start_date);
184: dbms_sql.column_value (l_cursor, 6,location_rec.active_end_date);

Line 181: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);

177: EXIT WHEN l_count <> 1;
178:
179: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
181: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
182: dbms_sql.column_value (l_cursor, 4,l_parent_instance_number);
183: dbms_sql.column_value (l_cursor, 5,location_rec.active_start_date);
184: dbms_sql.column_value (l_cursor, 6,location_rec.active_end_date);
185:

Line 182: dbms_sql.column_value (l_cursor, 4,l_parent_instance_number);

178:
179: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
181: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
182: dbms_sql.column_value (l_cursor, 4,l_parent_instance_number);
183: dbms_sql.column_value (l_cursor, 5,location_rec.active_start_date);
184: dbms_sql.column_value (l_cursor, 6,location_rec.active_end_date);
185:
186: l_process_flag := TRUE;

Line 183: dbms_sql.column_value (l_cursor, 5,location_rec.active_start_date);

179: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
181: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
182: dbms_sql.column_value (l_cursor, 4,l_parent_instance_number);
183: dbms_sql.column_value (l_cursor, 5,location_rec.active_start_date);
184: dbms_sql.column_value (l_cursor, 6,location_rec.active_end_date);
185:
186: l_process_flag := TRUE;
187: l_count_lines := l_count_lines + 1;

Line 184: dbms_sql.column_value (l_cursor, 6,location_rec.active_end_date);

180: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
181: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
182: dbms_sql.column_value (l_cursor, 4,l_parent_instance_number);
183: dbms_sql.column_value (l_cursor, 5,location_rec.active_start_date);
184: dbms_sql.column_value (l_cursor, 6,location_rec.active_end_date);
185:
186: l_process_flag := TRUE;
187: l_count_lines := l_count_lines + 1;
188:

Line 395: IF dbms_sql.is_open (l_cursor) THEN

391: END IF;
392:
393: END LOOP;
394:
395: IF dbms_sql.is_open (l_cursor) THEN
396: dbms_sql.close_cursor (l_cursor);
397: END IF;
398:
399:

Line 396: dbms_sql.close_cursor (l_cursor);

392:
393: END LOOP;
394:
395: IF dbms_sql.is_open (l_cursor) THEN
396: dbms_sql.close_cursor (l_cursor);
397: END IF;
398:
399:
400: pnp_debug_pkg.put_log_msg('===========================================================================');