DBA Data[Home] [Help]

APPS.INV_RECEIVING_TRANSACTION dependencies on WMS_LPN_CONTENTS

Line 178: UPDATE wms_lpn_contents

174: SET lpn_context = 6,
175: organization_id = l_organization_id
176: WHERE lpn_id = l_lpn_id;
177:
178: UPDATE wms_lpn_contents
179: SET organization_id = l_organization_id
180: WHERE parent_lpn_id = l_lpn_id;
181:
182: UPDATE mtl_serial_numbers

Line 1337: UPDATE wms_lpn_contents

1333: CLOSE c_mmtt_txn_temp_id;
1334: END;
1335:
1336: BEGIN
1337: UPDATE wms_lpn_contents
1338: SET txn_error_flag = 'Y'
1339: WHERE source_header_id = p_group_id;
1340: EXCEPTION
1341: WHEN no_data_found THEN

Line 1345: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception while updating wms_lpn_contents to error : 200',4);

1341: WHEN no_data_found THEN
1342: NULL;
1343: WHEN OTHERS THEN
1344: IF (l_debug = 1) THEN
1345: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception while updating wms_lpn_contents to error : 200',4);
1346: END IF;
1347: END;
1348:
1349: BEGIN