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 PN_LOCATIONS_ALL

Line 8: p_locn_code_from IN pn_locations_all.location_code%TYPE,

4: PROCEDURE export_location_to_eam (
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY VARCHAR2,
7: p_batch_name IN VARCHAR2,
8: p_locn_code_from IN pn_locations_all.location_code%TYPE,
9: p_locn_code_to IN pn_locations_all.location_code%TYPE,
10: p_locn_type IN pn_locations_all.location_type_lookup_code%TYPE,
11: p_organization_id IN mtl_serial_numbers.current_organization_id%TYPE,
12: p_inventory_item_id IN mtl_serial_numbers.inventory_item_id%TYPE,

Line 9: p_locn_code_to IN pn_locations_all.location_code%TYPE,

5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY VARCHAR2,
7: p_batch_name IN VARCHAR2,
8: p_locn_code_from IN pn_locations_all.location_code%TYPE,
9: p_locn_code_to IN pn_locations_all.location_code%TYPE,
10: p_locn_type IN pn_locations_all.location_type_lookup_code%TYPE,
11: p_organization_id IN mtl_serial_numbers.current_organization_id%TYPE,
12: p_inventory_item_id IN mtl_serial_numbers.inventory_item_id%TYPE,
13: p_owning_department_id IN mtl_serial_numbers.owning_department_id%TYPE,

Line 10: p_locn_type IN pn_locations_all.location_type_lookup_code%TYPE,

6: retcode OUT NOCOPY VARCHAR2,
7: p_batch_name IN VARCHAR2,
8: p_locn_code_from IN pn_locations_all.location_code%TYPE,
9: p_locn_code_to IN pn_locations_all.location_code%TYPE,
10: p_locn_type IN pn_locations_all.location_type_lookup_code%TYPE,
11: p_organization_id IN mtl_serial_numbers.current_organization_id%TYPE,
12: p_inventory_item_id IN mtl_serial_numbers.inventory_item_id%TYPE,
13: p_owning_department_id IN mtl_serial_numbers.owning_department_id%TYPE,
14: p_maintainable_flag IN mtl_serial_numbers.maintainable_flag%TYPE)

Line 17: location_rec pn_locations_all%ROWTYPE;

13: p_owning_department_id IN mtl_serial_numbers.owning_department_id%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(4000);
20: l_where_clause VARCHAR2(1000);
21: l_industry VARCHAR2(30);