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 180: update mtl_eam_asset_num_interface set

176: prod_organization_code = p_asset_rec.prod_organization_code
177: where interface_header_id = p_asset_rec.interface_header_id;
178:
179: --Start 8579859
180: update mtl_eam_asset_num_interface set
181: instance_number = (select instance_number from csi_item_instances
182: where serial_number = p_asset_rec.serial_number and
183: last_vld_organization_id =p_asset_rec.CURRENT_ORGANIZATION_ID and
184: inventory_item_id =p_asset_rec.inventory_item_id)

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

505: l_skip_field1 BOOLEAN := false;
506: l_skip_field2 BOOLEAN := false;
507: l_skip_field3 BOOLEAN := false;
508: l_skip_all BOOLEAN := false;
509: l_prod_organization_id MTL_EAM_ASSET_NUM_INTERFACE.prod_organization_id%TYPE := NULL;
510: l_equipment_item_id MTL_EAM_ASSET_NUM_INTERFACE.equipment_item_id%TYPE := NULL;
511: l_eqp_serial_number MTL_EAM_ASSET_NUM_INTERFACE.eqp_serial_number%TYPE := NULL;
512:
513: l_prod_equipment_type NUMBER;

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

506: l_skip_field2 BOOLEAN := false;
507: l_skip_field3 BOOLEAN := false;
508: l_skip_all BOOLEAN := false;
509: l_prod_organization_id MTL_EAM_ASSET_NUM_INTERFACE.prod_organization_id%TYPE := NULL;
510: l_equipment_item_id MTL_EAM_ASSET_NUM_INTERFACE.equipment_item_id%TYPE := NULL;
511: l_eqp_serial_number MTL_EAM_ASSET_NUM_INTERFACE.eqp_serial_number%TYPE := NULL;
512:
513: l_prod_equipment_type NUMBER;
514: l_asset_criticality_code VARCHAR2(30);

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

507: l_skip_field3 BOOLEAN := false;
508: l_skip_all BOOLEAN := false;
509: l_prod_organization_id MTL_EAM_ASSET_NUM_INTERFACE.prod_organization_id%TYPE := NULL;
510: l_equipment_item_id MTL_EAM_ASSET_NUM_INTERFACE.equipment_item_id%TYPE := NULL;
511: l_eqp_serial_number MTL_EAM_ASSET_NUM_INTERFACE.eqp_serial_number%TYPE := NULL;
512:
513: l_prod_equipment_type NUMBER;
514: l_asset_criticality_code VARCHAR2(30);
515:

Line 532: FROM MTL_EAM_ASSET_NUM_INTERFACE

528: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
529:
530: CURSOR asset_num_cur IS
531: SELECT *
532: FROM MTL_EAM_ASSET_NUM_INTERFACE
533: WHERE interface_group_id = p_interface_group_id
534: AND process_flag = 'R'
535: ORDER BY import_mode, import_scope, interface_header_id;
536:

Line 542: asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE;

538: SELECT pn_location_id, serial_number, inventory_item_id
539: FROM CSI_ITEM_INSTANCES
540: WHERE pn_location_id in (child1, parent1);
541:
542: asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE;
543:
544:
545: BEGIN
546: --dbms_output.enable(100000);

Line 947: UPDATE MTL_EAM_ASSET_NUM_INTERFACE

943: END IF;
944: --End of Import Asset Extensible attributes
945:
946: --set process_flag to 'S'. If it has come to this point, it succeeded
947: UPDATE MTL_EAM_ASSET_NUM_INTERFACE
948: SET process_flag = 'S'
949: WHERE interface_header_id = asset_rec.interface_header_id;
950: COMMIT;
951:

Line 1023: UPDATE MTL_EAM_ASSET_NUM_INTERFACE

1019: i := meavi_tab.NEXT(i);
1020: END LOOP;
1021:
1022: -- Update MEANI with error messages
1023: UPDATE MTL_EAM_ASSET_NUM_INTERFACE
1024: SET process_flag = 'E',
1025: error_code = l_error_code,
1026: error_message = l_error_message
1027: WHERE interface_header_id = asset_rec.interface_header_id;

Line 1109: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE

1105: CLOSE asset_num_cur;
1106: END IF;
1107: -- delete rows marked as success if purge option is true
1108: IF p_purge_option = 'Y' THEN
1109: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE
1110: WHERE process_flag = 'S'
1111: and interface_group_id = p_interface_group_id;
1112: END IF;
1113:

Line 1144: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE

1140: CLOSE asset_num_cur;
1141: END IF;
1142: -- delete rows marked as success if purge option is true
1143: IF p_purge_option = 'Y' THEN
1144: DELETE FROM MTL_EAM_ASSET_NUM_INTERFACE
1145: WHERE process_flag = 'S'
1146: and interface_group_id = p_interface_group_id;
1147: END IF;
1148: -- update all unprocessed records to errored status

Line 1149: UPDATE MTL_EAM_ASSET_NUM_INTERFACE

1145: WHERE process_flag = 'S'
1146: and interface_group_id = p_interface_group_id;
1147: END IF;
1148: -- update all unprocessed records to errored status
1149: UPDATE MTL_EAM_ASSET_NUM_INTERFACE
1150: SET process_flag = 'E',
1151: error_message = l_error_message
1152: WHERE interface_group_id = p_interface_group_id
1153: and process_flag = 'R';