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 71: l_cursor := dbms_sql.open_cursor;

67: pnp_debug_pkg.log('EAM is not installed ...');
68: RETURN;
69: END IF;
70:
71: l_cursor := dbms_sql.open_cursor;
72: l_query :=
73: 'SELECT location_id,'
74: || 'parent_location_id,'
75: || 'location_code,'

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

125: l_query := l_query || ' ORDER BY location_id ';
126: l_info := 'Figuring out the max id number in the mtl_eam_asset_num_interface ';
127: pnp_debug_pkg.log(l_info);
128:
129: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
130:
131: IF p_locn_type IS NOT NULL THEN
132: dbms_sql.bind_variable
133: (l_cursor,'l_locn_type',l_locn_type );

Line 132: dbms_sql.bind_variable

128:
129: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
130:
131: IF p_locn_type IS NOT NULL THEN
132: dbms_sql.bind_variable
133: (l_cursor,'l_locn_type',l_locn_type );
134: END IF;
135:
136: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN

Line 137: dbms_sql.bind_variable

133: (l_cursor,'l_locn_type',l_locn_type );
134: END IF;
135:
136: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
137: dbms_sql.bind_variable
138: (l_cursor,'l_locn_code_from',l_locn_code_from );
139: dbms_sql.bind_variable
140: (l_cursor,'l_locn_code_to',l_locn_code_to );
141: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN

Line 139: dbms_sql.bind_variable

135:
136: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
137: dbms_sql.bind_variable
138: (l_cursor,'l_locn_code_from',l_locn_code_from );
139: dbms_sql.bind_variable
140: (l_cursor,'l_locn_code_to',l_locn_code_to );
141: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
142: dbms_sql.bind_variable
143: (l_cursor,'l_locn_code_from',l_locn_code_from );

Line 142: dbms_sql.bind_variable

138: (l_cursor,'l_locn_code_from',l_locn_code_from );
139: dbms_sql.bind_variable
140: (l_cursor,'l_locn_code_to',l_locn_code_to );
141: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
142: dbms_sql.bind_variable
143: (l_cursor,'l_locn_code_from',l_locn_code_from );
144: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
145: dbms_sql.bind_variable
146: (l_cursor,'l_locn_code_to',l_locn_code_to );

Line 145: dbms_sql.bind_variable

141: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
142: dbms_sql.bind_variable
143: (l_cursor,'l_locn_code_from',l_locn_code_from );
144: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
145: dbms_sql.bind_variable
146: (l_cursor,'l_locn_code_to',l_locn_code_to );
147: END IF;
148:
149: IF p_locn_code_to IS NOT NULL THEN

Line 150: dbms_sql.bind_variable

146: (l_cursor,'l_locn_code_to',l_locn_code_to );
147: END IF;
148:
149: IF p_locn_code_to IS NOT NULL THEN
150: dbms_sql.bind_variable
151: (l_cursor,'l_locn_code_to',l_locn_code_to );
152: END IF;
153:
154: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);

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

150: dbms_sql.bind_variable
151: (l_cursor,'l_locn_code_to',l_locn_code_to );
152: END IF;
153:
154: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
155: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
156: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
157: dbms_sql.define_column (l_cursor, 4,location_rec.active_start_date);
158: dbms_sql.define_column (l_cursor, 5,location_rec.active_end_date);

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

151: (l_cursor,'l_locn_code_to',l_locn_code_to );
152: END IF;
153:
154: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
155: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
156: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
157: dbms_sql.define_column (l_cursor, 4,location_rec.active_start_date);
158: dbms_sql.define_column (l_cursor, 5,location_rec.active_end_date);
159:

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

152: END IF;
153:
154: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
155: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
156: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
157: dbms_sql.define_column (l_cursor, 4,location_rec.active_start_date);
158: dbms_sql.define_column (l_cursor, 5,location_rec.active_end_date);
159:
160: l_rows := dbms_sql.execute(l_cursor);

Line 157: dbms_sql.define_column (l_cursor, 4,location_rec.active_start_date);

153:
154: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
155: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
156: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
157: dbms_sql.define_column (l_cursor, 4,location_rec.active_start_date);
158: dbms_sql.define_column (l_cursor, 5,location_rec.active_end_date);
159:
160: l_rows := dbms_sql.execute(l_cursor);
161:

Line 158: dbms_sql.define_column (l_cursor, 5,location_rec.active_end_date);

154: dbms_sql.define_column (l_cursor, 1,location_rec.location_id);
155: dbms_sql.define_column (l_cursor, 2,location_rec.parent_location_id);
156: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
157: dbms_sql.define_column (l_cursor, 4,location_rec.active_start_date);
158: dbms_sql.define_column (l_cursor, 5,location_rec.active_end_date);
159:
160: l_rows := dbms_sql.execute(l_cursor);
161:
162: LOOP

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

156: dbms_sql.define_column (l_cursor, 3,location_rec.location_code,90);
157: dbms_sql.define_column (l_cursor, 4,location_rec.active_start_date);
158: dbms_sql.define_column (l_cursor, 5,location_rec.active_end_date);
159:
160: l_rows := dbms_sql.execute(l_cursor);
161:
162: LOOP
163: l_count := dbms_sql.fetch_rows( l_cursor );
164: EXIT WHEN l_count <> 1;

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

159:
160: l_rows := dbms_sql.execute(l_cursor);
161:
162: LOOP
163: l_count := dbms_sql.fetch_rows( l_cursor );
164: EXIT WHEN l_count <> 1;
165:
166: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
167: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);

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

162: LOOP
163: l_count := dbms_sql.fetch_rows( l_cursor );
164: EXIT WHEN l_count <> 1;
165:
166: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
167: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
169: dbms_sql.column_value (l_cursor, 4,location_rec.active_start_date);
170: dbms_sql.column_value (l_cursor, 5,location_rec.active_end_date);

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

163: l_count := dbms_sql.fetch_rows( l_cursor );
164: EXIT WHEN l_count <> 1;
165:
166: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
167: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
169: dbms_sql.column_value (l_cursor, 4,location_rec.active_start_date);
170: dbms_sql.column_value (l_cursor, 5,location_rec.active_end_date);
171:

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

164: EXIT WHEN l_count <> 1;
165:
166: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
167: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
169: dbms_sql.column_value (l_cursor, 4,location_rec.active_start_date);
170: dbms_sql.column_value (l_cursor, 5,location_rec.active_end_date);
171:
172: l_process_flag := TRUE;

Line 169: dbms_sql.column_value (l_cursor, 4,location_rec.active_start_date);

165:
166: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
167: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
169: dbms_sql.column_value (l_cursor, 4,location_rec.active_start_date);
170: dbms_sql.column_value (l_cursor, 5,location_rec.active_end_date);
171:
172: l_process_flag := TRUE;
173: l_count_lines := l_count_lines + 1;

Line 170: dbms_sql.column_value (l_cursor, 5,location_rec.active_end_date);

166: dbms_sql.column_value (l_cursor, 1,location_rec.location_id);
167: dbms_sql.column_value (l_cursor, 2,location_rec.parent_location_id);
168: dbms_sql.column_value (l_cursor, 3,location_rec.location_code);
169: dbms_sql.column_value (l_cursor, 4,location_rec.active_start_date);
170: dbms_sql.column_value (l_cursor, 5,location_rec.active_end_date);
171:
172: l_process_flag := TRUE;
173: l_count_lines := l_count_lines + 1;
174:

Line 357: IF dbms_sql.is_open (l_cursor) THEN

353: END IF;
354:
355: END LOOP;
356:
357: IF dbms_sql.is_open (l_cursor) THEN
358: dbms_sql.close_cursor (l_cursor);
359: END IF;
360:
361:

Line 358: dbms_sql.close_cursor (l_cursor);

354:
355: END LOOP;
356:
357: IF dbms_sql.is_open (l_cursor) THEN
358: dbms_sql.close_cursor (l_cursor);
359: END IF;
360:
361:
362: pnp_debug_pkg.put_log_msg('===========================================================================');