APPS.PN_EXP_TO_EAM_PVT dependencies on MTL_EAM_ASSET_NUM_INTERFACE

Line 18: l_serial_num mtl_eam_asset_num_interface.serial_number%TYPE;

14: p_maintainable_flag IN mtl_serial_numbers.maintainable_flag%TYPE)
15: IS
16:
17: location_rec pn_locations_all%ROWTYPE;
18: l_serial_num mtl_eam_asset_num_interface.serial_number%TYPE;
19: l_query VARCHAR2(1000);
20: l_where_clause VARCHAR2(1000);
21: l_industry VARCHAR2(30);
22: l_installation_status VARCHAR2(5);

Line 126: l_info := 'Figuring out the max id number in the mtl_eam_asset_num_interface ';

122: l_query := l_query || l_where_clause;
123: END IF;
124:
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:

Line 228: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';

224: ELSE
225: l_serial_num := location_rec.location_code;
226: END IF;
227:
228: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
229:
230: fnd_message.set_name ('PN','PN_XPEAM_INS');
231: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
232: l_message := fnd_message.get;

Line 231: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');

227:
228: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
229:
230: fnd_message.set_name ('PN','PN_XPEAM_INS');
231: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
232: l_message := fnd_message.get;
233: pnp_debug_pkg.put_log_msg(l_message);
234:
235:

Line 243: INSERT INTO mtl_eam_asset_num_interface(

239: l_message := '*** '||fnd_message.get||' ...';
240: pnp_debug_pkg.put_log_msg(l_message);
241:
242:
243: INSERT INTO mtl_eam_asset_num_interface(
244: inventory_item_id,
245: serial_number,
246: interface_header_id,
247: import_mode,