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.EAM_ASSET_NUM_IMPORT_PUB dependencies on MTL_EAM_ASSET_NUM_INTERFACE

Line 109: p_asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE

105: -- Updates the current table row with the error message and error code
106: procedure update_row_error (
107: p_error_code NUMBER,
108: p_error_message VARCHAR2,
109: p_asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE
110: ) is
111: begin
112: UPDATE MTL_EAM_ASSET_NUM_INTERFACE SET
113: process_flag = 'E',

Line 112: UPDATE MTL_EAM_ASSET_NUM_INTERFACE SET

108: p_error_message VARCHAR2,
109: p_asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE
110: ) is
111: begin
112: UPDATE MTL_EAM_ASSET_NUM_INTERFACE SET
113: process_flag = 'E',
114: error_code = p_error_code,
115: error_message = p_error_message
116: WHERE interface_header_id = p_asset_rec.interface_header_id;

Line 123: meavi.error_message = 'Import of corresponding row in MTL_EAM_ASSET_NUM_INTERFACE failed'

119: -- rows in Asset Attribute interface table as error
120: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
121: SET meavi.error_number = 9999,
122: meavi.process_status = 'E',
123: meavi.error_message = 'Import of corresponding row in MTL_EAM_ASSET_NUM_INTERFACE failed'
124: WHERE meavi.interface_header_id = p_asset_rec.interface_header_id
125: AND meavi.process_status = 'P';
126:
127: end update_row_error;

Line 133: UPDATE MTL_EAM_ASSET_NUM_INTERFACE

129: -- Bug # 3601150
130: -- Updates the remaining row in the batch with status as pending
131: procedure update_remaining_row_status (p_batch_id NUMBER) is
132: begin
133: UPDATE MTL_EAM_ASSET_NUM_INTERFACE
134: SET process_flag = 'P',
135: interface_group_id = NULL
136: WHERE batch_id = p_batch_id
137: AND process_flag = 'R';

Line 143: p_asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE

139:
140: -- Updates the current table row with the calculated values for derived
141: -- fields such as code from value, value from code, etc.
142: procedure update_row_calculated_values (
143: p_asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE
144: ) is
145:
146: l_api_name constant varchar2(30) := 'update_row_calculated_values';
147:

Line 165: update mtl_eam_asset_num_interface set

161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
162: 'Updating interface table with calculated values');
163: end if;
164:
165: update mtl_eam_asset_num_interface set
166: owning_department_code = p_asset_rec.owning_department_code,
167: owning_department_id = p_asset_rec.owning_department_id,
168: asset_criticality_code = p_asset_rec.asset_criticality_code,
169: asset_criticality_id = p_asset_rec.asset_criticality_id,

Line 179: update mtl_eam_asset_num_interface set

175: prod_organization_id = p_asset_rec.prod_organization_id,
176: prod_organization_code = p_asset_rec.prod_organization_code
177: where interface_header_id = p_asset_rec.interface_header_id;
178:
179: update mtl_eam_asset_num_interface set
180: instance_number = (select instance_number from csi_item_instances where serial_number = p_asset_rec.serial_number)
181: where interface_header_id = p_asset_rec.interface_header_id;
182:
183: end update_row_calculated_values;

Line 503: l_prod_organization_id MTL_EAM_ASSET_NUM_INTERFACE.prod_organization_id%TYPE := NULL;

499: l_skip_field1 BOOLEAN := false;
500: l_skip_field2 BOOLEAN := false;
501: l_skip_field3 BOOLEAN := false;
502: l_skip_all BOOLEAN := false;
503: l_prod_organization_id MTL_EAM_ASSET_NUM_INTERFACE.prod_organization_id%TYPE := NULL;
504: l_equipment_item_id MTL_EAM_ASSET_NUM_INTERFACE.equipment_item_id%TYPE := NULL;
505: l_eqp_serial_number MTL_EAM_ASSET_NUM_INTERFACE.eqp_serial_number%TYPE := NULL;
506:
507: l_prod_equipment_type NUMBER;

Line 504: l_equipment_item_id MTL_EAM_ASSET_NUM_INTERFACE.equipment_item_id%TYPE := NULL;

500: l_skip_field2 BOOLEAN := false;
501: l_skip_field3 BOOLEAN := false;
502: l_skip_all BOOLEAN := false;
503: l_prod_organization_id MTL_EAM_ASSET_NUM_INTERFACE.prod_organization_id%TYPE := NULL;
504: l_equipment_item_id MTL_EAM_ASSET_NUM_INTERFACE.equipment_item_id%TYPE := NULL;
505: l_eqp_serial_number MTL_EAM_ASSET_NUM_INTERFACE.eqp_serial_number%TYPE := NULL;
506:
507: l_prod_equipment_type NUMBER;
508: l_asset_criticality_code VARCHAR2(30);

Line 505: l_eqp_serial_number MTL_EAM_ASSET_NUM_INTERFACE.eqp_serial_number%TYPE := NULL;

501: l_skip_field3 BOOLEAN := false;
502: l_skip_all BOOLEAN := false;
503: l_prod_organization_id MTL_EAM_ASSET_NUM_INTERFACE.prod_organization_id%TYPE := NULL;
504: l_equipment_item_id MTL_EAM_ASSET_NUM_INTERFACE.equipment_item_id%TYPE := NULL;
505: l_eqp_serial_number MTL_EAM_ASSET_NUM_INTERFACE.eqp_serial_number%TYPE := NULL;
506:
507: l_prod_equipment_type NUMBER;
508: l_asset_criticality_code VARCHAR2(30);
509:

Line 526: FROM MTL_EAM_ASSET_NUM_INTERFACE

522: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
523:
524: CURSOR asset_num_cur IS
525: SELECT *
526: FROM MTL_EAM_ASSET_NUM_INTERFACE
527: WHERE interface_group_id = p_interface_group_id
528: AND process_flag = 'R'
529: ORDER BY import_mode, import_scope, interface_header_id;
530:

Line 536: asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE;

532: SELECT pn_location_id, serial_number, inventory_item_id
533: FROM CSI_ITEM_INSTANCES
534: WHERE pn_location_id in (child1, parent1);
535:
536: asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE;
537:
538:
539: BEGIN
540: --dbms_output.enable(100000);

Line 932: UPDATE MTL_EAM_ASSET_NUM_INTERFACE

928: END IF;
929: --End of Import Asset Extensible attributes
930:
931: --set process_flag to 'S'. If it has come to this point, it succeeded
932: UPDATE MTL_EAM_ASSET_NUM_INTERFACE
933: SET process_flag = 'S'
934: WHERE interface_header_id = asset_rec.interface_header_id;
935: COMMIT;
936:

Line 1008: UPDATE MTL_EAM_ASSET_NUM_INTERFACE

1004: i := meavi_tab.NEXT(i);
1005: END LOOP;
1006:
1007: -- Update MEANI with error messages
1008: UPDATE MTL_EAM_ASSET_NUM_INTERFACE
1009: SET process_flag = 'E',
1010: error_code = l_error_code,
1011: error_message = l_error_message
1012: WHERE interface_header_id = asset_rec.interface_header_id;

Line 1094: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE

1090: CLOSE asset_num_cur;
1091: END IF;
1092: -- delete rows marked as success if purge option is true
1093: IF p_purge_option = 'Y' THEN
1094: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE
1095: WHERE process_flag = 'S'
1096: and interface_group_id = p_interface_group_id;
1097: END IF;
1098:

Line 1129: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE

1125: CLOSE asset_num_cur;
1126: END IF;
1127: -- delete rows marked as success if purge option is true
1128: IF p_purge_option = 'Y' THEN
1129: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE
1130: WHERE process_flag = 'S'
1131: and interface_group_id = p_interface_group_id;
1132: END IF;
1133: -- update all unprocessed records to errored status

Line 1134: UPDATE MTL_EAM_ASSET_NUM_INTERFACE

1130: WHERE process_flag = 'S'
1131: and interface_group_id = p_interface_group_id;
1132: END IF;
1133: -- update all unprocessed records to errored status
1134: UPDATE MTL_EAM_ASSET_NUM_INTERFACE
1135: SET process_flag = 'E',
1136: error_message = l_error_message
1137: WHERE interface_group_id = p_interface_group_id
1138: and process_flag = 'R';